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 |
Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.
Can we create datasets by proc step ? (Proc contents, Means)?
Explain the difference between using drop = data set option in set and data statement?
what is the purpose of _error_? : Sas programming
Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
Intern stastical programmer written test
How do you convert basic cube to transaction cube and transaction cube to basic cube?
how can you code the confidence intervals?
6 Answers Cytel, IIT, Ranbaxy,
What does the RUN statement do?
In which format does Date stores in sas..? What is the use of DATE in SAS.?
how can get the first and last observations in a dataset using Proc SQl?