Why and when do you use proc sql?
No Answer is Posted For this Question
Be the First to Post Answer
how to debug and test the sas program? : Sas-administrator
If a variable contains only numbers, can it be a character data type?
why is a stop statement needed for the point=option on a set statement? : Sas programming
Name statements that are execution only?
data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
What is maximum storage capability of SAS?
in ods is there any lib's
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.
what is the SAS/ACCESS and SAS/CONNECT?
9 Answers Accenture, iFlex, TCS,
what is the difference between proc report and proc format?
What does P-value signify about the statistical data?