how can you sort the dataset having millions of OBS(instead
of sort procedure?
- 4 Answers
- 9621 Views
- EXL, I also Faced
- E-Mail Answers
Answer Posted / chandrakanth
proc sql;
create table dataset-name as select * from source-dataset-name group by sorting-variable-name;
quit;
GROUP BY option is for sorting the data.
Please let me know if you have more questions
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What are the prime responsibilities of data integration administrator? : Sas-di
List down the reasons for choosing sas over other data analytics tools.
Explain the difference between using drop = data set option in set and data statement?
How do dates work in SAS data?
Explain the purpose of substr functions in sas programming.
How to limit decimal places for the variable using proc means?
What does the RUN statement do?
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
Explain the difference between nodup and nodupkey options?
what are several options for creating reports in web report studio? : Sas-bi
what does the run statement do? : Sas programming
how can you put a "trace" in your program? : Sas programming
what is the Population you used in your project, is it ITT or PP?
Describe a time when you were really stuck on a problem and how you solved it?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
