Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

· What are some good SAS programming practices for
processing very large data sets?

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


Please Help Members By Posting Answers For Below Questions

What is the difference between nodupkey and nodup options?

972


what are the considerations when picking a SAS/STAT procedure?

3323


How does the internal authentication work in sas? : sas-grid-administration

1066


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3529


Enlist the syntax rules followed in sas statements.

1029


describe how to adjust the performance of data integrator? : Sas-di

945


What is maximum storage capability of SAS?

1352


In ARRAY processing, what does the DIM function do?

1113


Explain the purpose of retain statement.

1006


what is treatment emergent events and treatment emregent adverse event

2325


what are several options for creating reports in web report studio? : Sas-bi

1076


What do you know about sas data set?

1022


Give some ways by which you can define the variables to produce the summary report (using proc report)?

1032


Difference between informat and format?

1043


What’s the difference between var b1 – b3 and var b1 — b3?

1278