Interested to Buy Any Domain ? << Click Here >> for more details...
How would you keep from overlaying the a SAS set with its
sorted version?
- 4 Answers
- 9499 Views
- I also Faced
- E-Mail Answers
Answer Posted / tangyoulei
proc sort data=*** out=###;
by;
run;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
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.
Why double trailing @@ is used in input statement?
What is the difference between %put and symbolgen? : sas-macro
what other sas products have you used and consider yourself proficient in using? : Sas programming
What is a put statement?
what is data access? : Sas-di
What is the role of unrestrictive users? : sas-grid-administration
Enlist the syntax rules followed in sas statements.
Mention the category in which sas informats are placed?
Explain data_null_?
How you can read the variables that you need?
where are dashboard components are created and maintained? : Sas-bi
Explain proc sort?
What areas of SAS are you most interested in?
