Diff between proc sql merge and join?
Answer / anand
Merge - Data sets must be sorted by or indexed on the BY variable prior to merging.
Proc SQL - Data sets doesnot need to be sorted or indexed.
Is This Answer Correct ? | 8 Yes | 0 No |
Which statement does not perform automatic conversions in comparisons?
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance
/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
Can you execute a macro within a macro? Describe. : sas-macro
when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.
what is transformation in sas data integration? : Sas-di
Do you need to know if there are any missing values?
What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;
At compile time when a SAS data set is read, what items are created?
What are TEAEs
2 Answers Accenture, Quintiles,