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?

Answers were Sorted based on User's Feedback



You need to perform an analysis on a massive dataset by groups, but are unable to sort the data du..

Answer / 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

You need to perform an analysis on a massive dataset by groups, but are unable to sort the data du..

Answer / rock

Before grouping the dataset first compress the dataset
using compress=yes option whicle creation of dataset like

data x(compress=yes reuse=yes);
set y;
run;
proc sql;
select --- do the grouping now

Sure that sorting will take less time. Try this once
Main trick here is we are compressing the unused space in
dataset so the size of the dataset will get reduce.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SAS Interview Questions

is it possible to generate sas datasets using proc print ???

1 Answers   GSK GlaxoSmithKline,


How to find out no. of business days in a month using macros.???(excluding weekends and holidays).

2 Answers   HSBC,


How do you convert basic cube to transaction cube and transaction cube to basic cube?

0 Answers  


Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

0 Answers  


why is the use of Retrive statement and give me with example?

1 Answers   ME,


Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

0 Answers  


Does SAS ‘Translate’ (compile) or does it ‘Interpret’? Explain.

4 Answers   Accenture,


What are the main differences between sas versions 8.2, 9.0, 9.1?

4 Answers  


how do u validate sas program

3 Answers   Accenture,


if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??

6 Answers   Accenture,


what is pdv? how it is related to input buffer in sas?

5 Answers   HSBC, Satyam,


what is the effect of the options statement errors=1? : Sas programming

0 Answers  


Categories