Answer / sibin

Use
1.WHERE Condition
2.DROP KEEP in Set Statement
3.ARRAY
4.Mutually Exclusive Conditions like DO ,DO UNTIL,DO WHILE

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.

Answer / koduri

Using Arrays .

Answer / solasa

for large datasets we use proc sql joins

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.

Answer / dvsr

1)compress the datasets

2)use DROP KEEP options while creating temp data sets

3)Index creation on the Frequently using variables

In sas, what are the areas that you are most interested in? : sas-grid-administration

0 Answers  

how would you determine the number of missing or nonmissing values in computations? : Sas programming

0 Answers  

what is the use of proc contents and proc print in sas? : Sas-administrator

0 Answers  

it will become easy if uuu provide website linkssss and list of consultanciessssss

0 Answers  

what is Difference between PROC SQL JOINS and MERGE?

3 Answers   Accenture, Wipro,

i want to upload titles and footnotes to excel file?how it is possible?

1 Answers  

What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?

2 Answers   Accenture,

if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

0 Answers   CTS,

What is the difference between %local and %global? : sas-macro

0 Answers  

how can u import .csv file in to SAS?tell Syntax?

7 Answers   CitiGroup, Franklin Templeton,

how can you get the single data set from the library(which has the number of data sets)?

3 Answers   Accenture, Deloitte,

what is OLAP?

4 Answers   CitiGroup, TCS,