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 are the data types in sas?
What is the difference between one to one merge and match merge? Give an example.
For clinical entire study how many tables will create approx?
Why and when do you use proc sql?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
What are the parameters of scan function?
what is sas business intelligence? : Sas-bi
Which function is used to count the number of intervals between two sas dates?
What are the prime responsibilities of data integration administrator? : Sas-di
What is the difference between using drop = data set option in data statement and set statement?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
Describe the function and untility of the most difficult SAS macro that you have written.
how does sas handle missing values in functions? : Sas programming
what are informats in sas? : Sas-administrator