If i doest required Cumilative frequency in my table,
generated by using PROC FREQ what i had to do?
Answer Posted / naveen
proc freq data=xxx;
tables name/out=hosp (drop=percent);
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are 5 ways to perform a table lookup in sas? : Sas-administrator
do you prefer proc report or proc tabulate? Why? : Sas programming
What is a method to debug and test your SAS program?
what are _numeric_ and _character_ and what do they do? : Sas programming
what is data access? : Sas-di
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
why is sas considered self-documenting? : Sas programming
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
I have a dataset concat having variable a b & c. How to rename a b to e & f?
why is a stop statement needed for the point=option on a set statement? : Sas programming
what is sas application server? : Sas-di
What are the data types that sas contain?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
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.