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 |
In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?
what is the difference between SET and MERGE?
How to get the repeated values by using sql in sas ?
What are the parameters of scan function?
Do you need to know if there are any missing values?
Identify statements whose placement in the DATA step is critical?
How would you include common or reuse to be processed along with your statements?
How substr function works in sas?
Briefly explain input and put function?
Differentiate input and infile.
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
how do i get last 10obs from a dataset when we don't know about the number of obsevations in that dataset?