Code the MEANS to produce output to be used later.
Answers were Sorted based on User's Feedback
Answer / siri
proc means data=XYZ noprint;
by var;
output out=ZYX;
run;
output out is important to producethe poutputt to be used
in later stages
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / ss
Actually they aksed to produce output to be used later, in
that case you have to give the permanent libref.
| Is This Answer Correct ? | 4 Yes | 3 No |
What is SAS informats?
Are you familiar with special input delimiters? How are they used?
What is the work of tranwrd function?
tell me about use of arrays in sas
you have a data set like this. data qqq; input name $ total; cards; qq 22 ww 33 qq 22 ee 44 rr 33 ww 44 ; run; and you want output like this......... name total qq 22 ww 44 Do it by data set step.
What is difference between Global n Local Macro Variables..?
Name statements that are execution only.
what are the different ways of merging two datasets.name atleast 4.
what is syntax of proc merge ?
How necessary is it to be creative in your work?
what do the pad and dim functions do? : 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.