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 maximum length of the macro variable?
what is metadata? : Sas-bi
What is the order of application for output data set options, input data set options and SAS statements?
what is intially documentation in sas?
Describe the function and untility of the most difficult SAS macro that you have written.
Explain the purpose of retain statement.
What system options would you use to help debug a macro? : sas-macro
Describe the ways in which you can create macro variables? : sas-macro
what is information maps?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
how will you location sas platform applications available from web browser? : Sas-bi
what is change analysis in sas di ? : Sas-di
What are the parameters of scan function?
What are the features of SAS?
What is the use of the %include statement?