Interested to Buy Any Domain ? << Click Here >> for more details...
define table lookup and how may ways it can be
done...explian
- 3 Answers
- 6442 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Describe the function and untility of the most difficult SAS macro that you have written.
What is slibref?
Baseline definition in your study
3 Answers Accenture, Quintiles,
how to read raw data in sas. Do it manually and throw the programming.
how to delete the duplicates by using proc sql?
If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?
Do you need to know if there are any missing values?
Does anybody has lastest SAS certification dumps,if anybody has please mail me on saggydesai@gmail.com
how many types prompting framework can be broken down to? : Sas-bi
i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?
is there any differnce between proc means and proc summary?
how do you debug and test your sas programs? : Sas programming
Teradata 
