how can you sort the dataset having millions of OBS(instead
of sort procedure?
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
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
Did you used proc test? when?
What is by-group processing?
what are informats in sas? : Sas-administrator
Describe 5 ways to do a “table lookup” in SAS?
What are the table names in oracle database...?
In proc transpose and data step with arrays which one you pick?
How do dates work in sas?
What is PROC in SAS?
What is the difference between order and group variable in proc report?
What versions of SAS have you used (on which platforms)?
what is sas olap server? : Sas-di
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
What is the maximum and minimum length of macro variable
What is the role of sas grid administrator? : sas-grid-administration