what are 5 ways to perform a table lookup in sas? : Sas-administrator


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SAS Interview Questions

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?

3 Answers  


What are the advantages of using sas?

0 Answers  


what is the difference between compiler and interpreter? give any one example (software product) that act as a interpreter?

36 Answers   Accenture, College School Exams Tests, CTS, IBM, IHRD, Infosys, Sylhet Engineering College, TCS, Wipro,


how are numeric and character missing values represented internally? : Sas programming

0 Answers  


What other SAS features do you use for error trapping and data validation?

2 Answers  






data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

0 Answers  


What are the prime responsibilities of data integration administrator? : Sas-di

0 Answers  


Given an unsorted data set, how to read the last observation to a new data set?

0 Answers  


Which is the best training institute for SAS in hyderabad.

112 Answers   Stansys Software Solutions,


Compare sas with other data analytics tools.

0 Answers  


What was the last computer book you purchased? Why?

0 Answers   Oracle,


Explain proc univariate?

0 Answers  


Categories