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

What sas features do you use to check errors and data validation?

0 Answers  

what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?

1 Answers  

Explain the purpose of substr functions in sas programming.

0 Answers  

If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?

8 Answers   HCL,

what is the difference between x=substr(name,1,2); and substr(name,1,2)='x';

3 Answers   HSBC,

for whom is sas data integration studio designed? : Sas-di

0 Answers  

There is a field containing a date. It needs to be displayed in the format “ddmonyy” if it’s before 1975,”dd mon ccyy” if it’s after 1985, and as ‘disco years’ if its between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT.

3 Answers   CTS,

What procedure you used to calculate p-value?

2 Answers   Accenture, Quintiles,

what do the pad and dim functions do? : Sas programming

0 Answers  

Can you excute a macro within a macro? Describe.

2 Answers   Genta,

What is difference between (a-z) and (a--z)

8 Answers   Accenture,

I Here clinical SAS training by Ramesh Azmeera is good. Is it confirm ?

2 Answers