Briefly describe 5 ways to do a "table lookup" in sas.
- 4 Answers
- 20207 Views
- Quintiles, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Arrays
Index
Merg statement
Hashes
proc format
SQL JOINS
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / tulika
DAta step and Merge Statement
SQL Inner Join
SQL subquery
Format procedure and Put function
Call execute routine
for more information look up
http://www2.sas.com/proceedings/sugi27/p011-27.pdf
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / lakshmi
update
modify
fact to dimension
sql joins
merge statement
| Is This Answer Correct ? | 0 Yes | 0 No |
When merging 2 datasets with a common variable (not merge key), how to keep both?
What is difference between Global n Local Macro Variables..?
What is program data vector (pdv) and what are its functions?
We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?
data study; input Subj : $3. Group : $1. Dose : $4. Weight : $8. Subgroup; x= input(Weight,5.1); datalines; 001 A Low 220 2 002 A High 90 1 003 B Low 193.6 1 004 B High 165 2 005 A Low 123.4 1 ; Why does X get truncated? X shows up as 22 instead of 220,9 instead of 90 and 19.8 instead of 198? This problem doesnt happen with the values 193.6 and 123.4. This does not happen if x is read on the 5. informat instead of the 5.1 informat
Explain the special input delimiters used in sas programming.
Give an example where SAS fails to convert character value to numeric value automatically?
What is the order of application for output data set options, input data set options and SAS statements?
Can we use where and having clauses in a single SAS program. ex: proc sql; select a,b,c from test where state in 'KA' and having <some condition>. Is the above program run correctly, if not why ?
What do you feel about hardcoding?
Explain the difference between using drop = data set option in set and data statement?
How to convert .xls file into CSV format?
Teradata 
