Mention few ways with which a “table lookup’ is done in sas programming.
Answer / vineetha
Match-merging
Proc SQL
Arrays
Hash object
Direct access
Format tables
Is This Answer Correct ? | 0 Yes | 0 No |
what is sas metadata server? : Sas-di
what is slowly changing dimension? : Sas-di
1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.
How does Mr.Lanka Srinivas teach SAS? Are his accomplishments real? What are the future prospects for SAS?
What is the command used to find missing values?
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
what are scrubing procedures in SAS?
Which are the statements whose placement in the data step is critical?
What is the difference between Regression and Logistic Regression? Can u explain the Assumptions/Conditions?
What is _n_?
Explain the difference between nodup and nodupkey options?