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...


define table lookup and how may ways it can be
done...explian

Answers were Sorted based on User's Feedback



define table lookup and how may ways it can be done...explian..

Answer / vijaya mekala

Table lookup is a process of retriving information from
second dataset and add to first data set. different ways to
do look up.
1. data step with merge function.
2. set statement and Key option.
3. Proc sql into clause, inner join, subquery
4. proc format 5. conditional logics if, where, update
statements. 6. arrays with do loops 7. update statement.

Is This Answer Correct ?    7 Yes 0 No

define table lookup and how may ways it can be done...explian..

Answer / rc

I guess lot of ways, but I cna quickly think of two.

1. Create format with code and values, Put the formats in a
catalog and set option for fmtsearch and apply format to
teh variable.

2. Create temp dataset with input data in datastep. And use
proc SQL to join or use DATA step merge.

Is This Answer Correct ?    2 Yes 0 No

define table lookup and how may ways it can be done...explian..

Answer / srinu

WE CAN USE HASHING AND OTHER STEPS SPECIFIED

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SAS Interview Questions

what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?

3 Answers  


For what purpose(s) would use the RETURN statement?

1 Answers  


What do you understand by the term Normal Distribution?

0 Answers  


In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;

1 Answers  


name some data transformation used in sas di? : Sas-di

0 Answers  


What does a PROC TRANSPOSE do?

8 Answers   Accenture,


what is option year cuttoff in sas

2 Answers   L&T,


If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?

4 Answers  


what is the formula to measure Baseline

3 Answers   Sristek,


Are the preferred term counts are always equal to Body system counts? If so, Why are they equal if not why they are not equal?

1 Answers   Icon,


What SAS statements would you code to read an external raw data file to a DATA step?

6 Answers   Accenture,


Explain what is data step?

0 Answers  


Categories