how can you sort the dataset having millions of OBS(instead
of sort procedure?
- 4 Answers
- 9258 Views
- EXL, I also Faced
- E-Mail Answers
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
Did you used proc test? when?
what is the difference between infile and input? : Sas-administrator
How to limit decimal places for the variable using proc means?
What are the parameters of scan function?
Do you know the features of sas?
what is function of retain statment
Explain what is SAS informats?
What is the difference between match merge and one to one merge?
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
How do you delete duplicate observations in sas?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
AE datasets names? how many types?
Can you explain the process of calendar?
What is the sas data set? : sas-grid-administration
Explain proc univariate?
