How will you generate test data with no input data?
No Answer is Posted For this Question
Be the First to Post Answer
what is syntax of proc merge ?
how are numeric and character missing values represented internally? : Sas programming
Name types of category in which SAS Informats are placed?
What are the criticality that you have faced during your project in SAS?
create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;
in data set200 observation how to take 110,150,170 using sql procedure?
Describe a time when you were really stuck on a problem and how you solved it?
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.
How do you add a number to a macro variable? : sas-macro
Identify statements whose placement in the DATA step is critical?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
What is the order of evaluation of the following operators + - * / ** () ???