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 |
how do you debug and test your sas programs? : Sas programming
How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?
For clinical entire study how many tables will create approx?
What are the statements that are executed only?
What is SAS? What are the functions does it performs?
What is criteria for adverse events and treatment-emergent adverse events?
What is the purpose of the trailing and How would you use them?
how to generate report for 0 observation dataset?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
What are symbol tables?Differemce between Local N Global Symbol tables.....
what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?