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
For clinical entire study how many tables will create approx?
how many types of prompts are there? : Sas-bi
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
Mention the validation tools used in SAS?
How to include or exclude specific variables in a data set?
Can you execute macro within another macro? : sas-macro
Explain the main difference between the sas procedures and functions? : Sas-administrator
What does the trace option do?
What’s the difference between var b1 – b3 and var b1 — b3?
Name types of category in which SAS Informats are placed?
What areas of SAS are you most interested in?
What do the put and input function do?
What are types of transport files?
What are the difficulties u faced while doing vital signs table or dataset?
How do you add a number to a macro variable? : sas-macro