how can you sort the dataset having millions of OBS(instead
of sort procedure?
Answers were Sorted based on User's Feedback
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||1 No|
Answer / chandrakanth
create table dataset-name as select * from source-dataset-name group by sorting-variable-name;
GROUP BY option is for sorting the data.
Please let me know if you have more questions
|Is This Answer Correct ?||4 Yes||3 No|
Answer / ram
using there TAG SORT. it is more efficient than Sort procedure.
|Is This Answer Correct ?||4 Yes||4 No|
Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.
I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?
I use NOCUM/NOPERCENT option in the tables statement like this Proc freq data = deepak; tables x y /nocum nopercent; run; Here I get nopercent and nocum in the output only for variables x and y. How do i do it for all variables? Deepak
If you could design your ideal job, what would it look like?
What is the difference between nodup and nodupkey options?
Do you prefer Proc Report or Proc Tabulate? Why?
how to do user inputs and command line arguments in sas?
How to get part of string form the source string without using sub string function in SAS?
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE