how can you sort the dataset having millions of OBS(instead
of sort procedure?

Answers were Sorted based on User's Feedback



how can you sort the dataset having millions of OBS(instead of sort procedure?..

Answer / ram

using there TAG SORT. it is more efficient than Sort procedure.

Is This Answer Correct ?    4 Yes 4 No

how can you sort the dataset having millions of OBS(instead of sort procedure?..

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

how can you sort the dataset having millions of OBS(instead of sort procedure?..

Answer / solasa

Using INDEX option save the cpu time and helps in fast
processing

Is This Answer Correct ?    1 Yes 2 No

how can you sort the dataset having millions of OBS(instead of sort procedure?..

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

Post New Answer

More SAS Interview Questions

How would you include common or reuse code to be processed along with your statements?

3 Answers   Accenture,


What is shift table? have you ever created shift that?

2 Answers   Accenture, Clinical Research, Quintiles,


What's the difference between VAR A1 - A4 and VAR A1 - A4?

1 Answers   Quintiles,


What is the basic syntax of a sas program?

0 Answers  


Hi All.I am looking for Good Institute who could Provide the online SAS BI+DI Training along with software.Primarily in Delhi/NCR or in Hyderabad Please help with name and contact number of concerned person!! Thanks in Advance! :)

1 Answers  






what type of reports you are generating in your company...???

2 Answers   GSK GlaxoSmithKline,


Explain proc sort?

0 Answers  


Does anybody has SAS Platform Administration certification dumps. pls send to hariithepalli@gmail.com

0 Answers  


what is sas metadata server? : Sas-di

0 Answers  


is QUALCOMM using SAS ?

1 Answers  


In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)

8 Answers   GSK GlaxoSmithKline,


what does the run statement do? : Sas programming

0 Answers  


Categories