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
- 4949 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 |
What are the scrubbing procedures in sas?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
What is the pound sign used for in the data_null_ ?
what is the Population you used in your project, is it ITT or PP?
0 Answers Accenture, Quintiles,
How will you generate test data with no input data?
Hi All.I am looking for Good Institute who could Provide the online SAS BI+DI Training along with software.Primarily in Delhi/NCR or in Hyderabad Please help with name and contact number of concerned person!! Thanks in Advance! :)
what are different analysis datasets you created and what are the new variables created
Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated
how to import HTML files into SAS datasets?
Have you been involved in editing the data or writing data queries?
1 Answers BioServe, Oracle, Sasken,
Explain why double trailing @@ is used in input statement?
Teradata 
