I finally was able to use the import wizard to convert my excel table into SAS. First time I am using excel.with data
I have attached my excel
I would like mean and standard deviation per column and rows.
Cant do it correctly./Can anybody provide with simple code.
thank you
Sure, you likely want to be using the STACKODS options.
If you run these examples and follow them through, you'll see the different kinds of output you can get. In this particular case the analysis is grouped by ID and feature, so different statistics for each ID level. If you don't need this, ignore the BY statement.
*Create summary statistics for a dataset by a 'grouping' variable and store it in a dataset;
*Generate sample fake data;
data have;
input ID feature1 feature2 feature3;
cards;
1 7.72 5.43 4.35
1 5.54 2.25 8.22
1 4.43 6.75 2.22
1 3.22 3.21 7.31
2 6.72 2.86 6.11
2 5.89 4.25 5.25
2 3.43 7.30 8.21
2 1.22 3.55 6.55
;
run;
*Create summary data;
proc means data=have noprint;
by id;
var feature1-feature3;
output out=want median= var= mean= /autoname;
run;
*Show for display;
proc print data=want;
run;
*First done here:https://communities.sas.com/t5/General-SAS-Programming/Getting-creating-new-summary-variables-longitudinal-data/m-p/347940/highlight/false#M44842;
*Another way to present data is as follows;
proc means data=have stackods nway n min max mean median std p5 p95;
by id;
var feature1-feature3;
ods output summary=want2;
run;
*Show for display;
proc print data=want2;
run;
https://github.com/statgeek/SAS-Tutorials/blob/master/proc_means_basic.sas
And some other useful ones here:
Note there are more examples, click through the menu on the left hand side to see the other variations.
Specifically STACKODS here:
@ralphbenno wrote:
I finally was able to use the import wizard to convert my excel table into SAS. First time I am using excel.with data
I have attached my excel
I would like mean and standard deviation per column and rows.
Cant do it correctly./Can anybody provide with simple code.
thank you
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.