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

what r the job openings SAS for fresher graduates !

2013


Mention the category in which sas informats are placed?

624


Explain append procedure?

630


Differentiate between sas functions and sas procedures.

637


which date function advances a date, time or datetime value by a given interval? : Sas programming

588






If money were no object, what would you like to do?

2684


How is character variable converted into numeric variable and vice versa?

591


Difference between SAS STATA & SPSS?

676


What would you change about your job?

1920


what is the Population you used in your project, is it ITT or PP?

2179


Mention sas system options to debug sas macros.

659


Have you used macros? For what purpose you have used? : sas-macro

556


What is the purpose of trailing @ and @@? How do you use them?

607


How do you add a number to a macro variable? : sas-macro

542


Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

2088