· What are some good SAS programming practices for
processing very large data sets?
Answers were Sorted based on User's Feedback
Answer / sibin
Use
1.WHERE Condition
2.DROP KEEP in Set Statement
3.ARRAY
4.Mutually Exclusive Conditions like DO ,DO UNTIL,DO WHILE
Is This Answer Correct ? | 16 Yes | 1 No |
Answer / 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 |
Answer / vicky
1.we can compress the dataset
2.if we wana do merge a bigdate set with another dataset
having few variables for instance a fact with dimension
having key variable and description column
in this case sorting n merging this bigdateset(fact) with
dimension apply formats.so dat u can avoid sort n merge.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / dvsr
1)compress the datasets
2)use DROP KEEP options while creating temp data sets
3)Index creation on the Frequently using variables
Is This Answer Correct ? | 0 Yes | 1 No |
what is treatment emergent events and treatment emregent adverse event
i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
tell me about intnx, intcx functions?
What does a PROC TRANSPOSE do?
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
Mention the category in which sas informats are placed?
how do you read binary data in sas?
how will you locate the sas platform applications? : Sas-bi
How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;
how do you derive descriptive statistics?
1 Answers Accenture, Quintiles,
what can you learn from the sas log when debugging? : Sas programming
what is data access? : Sas-di