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
What does the trace option do?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
What is the difference between %put and symbolgen? : sas-macro
Do you need to know if there are any missing values?
What can you learn from the SAS log when debugging?
Can you execute a macro within a macro? Describe. : sas-macro
What is Linear Regression?
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 we can call macros with in data step? : sas-macro
what is change analysis in sas di ? : Sas-di
What are the functions which are used for character handling functions?
Describe the ways in which you can create macro variables?
Describe a time when you were really stuck on a problem and how you solved it?
What is slibref?
How do dates work in sas?