Interested to Buy Any Domain ? << Click Here >> for more details...
· What are some good SAS programming practices for
processing very large data sets?
- 6 Answers
- 20954 Views
- Quintiles, I also Faced
- E-Mail Answers
Answer Posted / pricil kurian
1) Compressing dataset
2) Using where instead of if as subsetting conditions
3) Deleting the temporary datasets at the end of the program
4) If we use "if..else ..if conditions"..use most occuring
situations first
5)Use keep and drop appropriately to avoid the unneceesary
variable
6).Creattion of index variable
7)Use of array statement
8)Create one byte required numeric variable which we don't
use for calcualting process as charcater..Using this this
variable need 1 byte where numeric variable's minimum
length is 3.
9)Minimize the CPU time that SAS uses by executing the
minimum number of statements in the most efficient
order.
10)Use SQL for code simplification. A single SQL statement
is generally easier to code and understand than a
long series of SORT and DATA steps.
11)Use of data _null_; when we don't need to output into a
new dataset.
12)Use macros for redundant code.
13)When data sets are large and unsorted, the SQL inner
join may beter than SORT and MERGE.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
How does the internal authentication work in sas? : sas-grid-administration
What is the difference between nodupkey and nodup options?
What are the limitations for memory allocation for SAS variables
How would you define the end of a macro?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
What are the difference between sas functions and procedures?
what are the considerations when picking a SAS/STAT procedure?
What is the difference between one to one merge and match merge? Give an example.
how to read the variables in sas? : Sas-administrator
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
How do dates work in sas?
What is by-group processing?
Have you used macros? For what purpose you have used? : sas-macro
