how can you sort the dataset having millions of OBS(instead
of sort procedure?
Answers were Sorted based on User's Feedback
Answer / ram
using there TAG SORT. it is more efficient than Sort procedure.
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / venkatesh
by using proc format u can do sort in eficient wway
but u need to use cntlin for dataset
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / 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 |
How would you include common or reuse code to be processed along with your statements?
do you prefer proc report or proc tabulate? Why? : Sas programming
Explain why double trailing @@ is used in input statement?
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
How do you add a number to a macro variable? : sas-macro
is QUALCOMM using SAS ?
Approximately what date is represented by SAS date value of 730
What versions of SAS have you used (on which platforms)?
Which is the best training Institute for SAS Business Intelligence course?
Name and describe few sas character functions that are used for data cleaning in brief.
What are the default statistics for means procedure?
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B