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 |
What is a pdv and what are its functions?
What do you feel about hardcoding?
if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record
What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?
is QUALCOMM using SAS ?
What are the joins,types of joins and thier functions?
What are common programming errors committed in sas
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.
what is the purpose of _error_? : Sas programming
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT
Describe how you would pass data to macro.
when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.