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 is the command used to find missing values?
Have you used macros? For what purpose you have used? : sas-macro
Mention the validation tools used in SAS?
What are the data types in sas?
how to remove duplicates using proc sql?
what is sas data set?
What will calendar procedure do?
How would you determine the number of missing or nonmissing values in computations?
In sas admin differentiate between roles and capabilities? : sas-grid-administration
Which command is used to perform sorting in sas program?
How do dates work in SAS data?
What system options would you use to help debug a macro? : sas-macro
how many types of prompts are there? : Sas-bi
Enlist the syntax rules followed in sas statements.
what are _numeric_ and _character_ and what do they do? : Sas programming