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
- 5434 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 |
hi i am nipun can anybody tell me that if a clinical sas programmer write the code and after successfull execution where do they store it. how they submit tables to TL how work is assigned to programmers either both code, log, output to be submitted. can any one tell me the process
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
Give e an example of..
what are the sites did u refer for enquiries and doubts for SAS
Describe the ways in which you can create macro variables? : sas-macro
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
If a variable contains letters or special characters, can it be numeric data type?
how do you read binary data in sas?
I have a dataset with variables empid and doj how to calculate retirement age?
what is intially documentation in sas?
Code a PROC MEANS that shows both summed and averaged output of the data.
What are the rows present in protocol Violation table?
2 Answers Accenture, Quintiles,
Teradata 
