Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 5527 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
how the sas basic syntax style described? : Sas-administrator
explain the main difference between the nodup and nodupkey options? : Sas-administrator
How do you add a number to a macro variable?
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?
When you will use nowd option in report???
which domain is better in sas? clinical trails or banking
What is _n_?
What are the special input delimiters used in SAS?
Difference Between Scan and Substr
what are all the reports you generated in your recent project?
0 Answers Accenture, Quintiles,
what are the categories that sas informats are used to the place the data? : Sas-administrator
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
Teradata 
