Difference b/n proc means and proc summary procedures?
Answer Posted / sasswarup
Proc SUMMARY and Proc MEANS are essentially the same procedure. Both procedures compute descriptive statistics. The main difference concerns the default type of output they produce. Proc MEANS by default produces printed output in the LISTING window or other open destination whereas Proc SUMMARY does not. Inclusion of the print option on the Proc SUMMARY statement will output results to the output window.
The second difference between the two procedures is reflected in the omission of the VAR statement. When all variables in the data set are character the same output: a simple count of observations, is produced for each procedure. However, when some variables in the dataset are numeric, Proc MEANS analyses all numeric variables not listed in any of the other statements and produces default statistics for these variables (N, Mean, Standard Deviation, Minimum and Maximum).
Using the SASHELP data set SHOES the example reflecting this difference is shown.
proc means data = sashelp.shoes;
run;
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the different servers in sas? : sas-grid-administration
In sas admin differentiate between roles and capabilities? : sas-grid-administration
what techniques and/or procs do you use for tables? : Sas programming
What is the role of unrestrictive users? : sas-grid-administration
explain what is data set in sas? : Sas-administrator
how can you create zero observation dataset? : Sas programming
What would you change about your job?
What is connection profile? : sas-grid-administration
explain about various caches available in data integrator? : Sas-di
How do you delete duplicate observations in sas?
What is the difference between SAS functions and procedures?
How do dates work in sas?
Name types of category in which SAS Informats are placed?
Name and describe few sas character functions that are used for data cleaning in brief.
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.