You need to perform an analysis on a massive dataset by
groups, but are unable to sort the data due to memory
constraint. How would you accomplish the task?

Answer Posted / satheesh

you can use index statement,

proc sql;
create index indexname on Tablename(Variable or Columnname);
quit;

the above code is equivalent to sort.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can you import .csv file in to sas? : Sas programming

866


What do you know about symput and symget?

968


What are the functions used for character handling?

904


Explain the use of proc print and proc contents?

745


what is the difference between nodup and nodupkey options? : Sas programming

891


what is the basic structure sas administrator? : Sas-administrator

803


What is the function of Stop statement in a SAS Program?

912


Describe the ways in which you can create macro variables?

868


what is sas application server? : Sas-di

758


what is data integration? : Sas-di

871


what is operational data and operational system? : Sas-di

880


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

869


How are numeric and character missing values represented internally?

1406


What are the difference between sas functions and procedures?

869


what versions of sas have you used (on which platforms)? : Sas programming

827