how do you want missing values handled? : Sas programming
Which is the best training institute for SAS in hyderabad.
112 Answers Stansys Software Solutions,
What is _n_?
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?
how sas deals with business intelligence? : Sas-bi
WHAT IS LAG FUNCTION ? WHERE CAN YOU IMPLEMENT THIS FUNCTION?
which features do you use to check the data validations and errors? : Sas-administrator
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.
Briefly describe 5 ways to do a "table lookup" in sas.
for what purpose would you use the retain statement? : Sas programming
wat is sas? is a package or programming language?
Explain the difference between nodup and nodupkey options?
what has been your most common programming mistake? : Sas programming