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
- 5545 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How to create an external dataset with sas code?
Explain the purpose of retain statement.
What is the command used to find missing values?
What is connection profile? : sas-grid-administration
What is Linear Regression?
What is the difference between order and group variable in proc report?
What are the special input delimiters used in SAS?
Tell me about % include and % eval? : sas-macro
Explain how you can debug and test your SAS program?
what is data integration? : Sas-di
What system options would you use to help debug a macro? : sas-macro
Explain what is SAS informats?
explain the key concept of sas? : Sas-administrator
Do you need to know if there are any missing values?
For clinical entire study how many tables will create approx?
