BookmarkSubscribeRSS Feed
MUIZVHORA
Calcite | Level 5
data neg_prices;
	set homework_one;
	if price<0 then price_type = 'neg';  * create new label: negative when price is less than zero and otherwise;
	else price_type = 'pos';
run;

proc means data=neg_prices n;a
	class price_type;					 * get number of observations for negative prices;
	var price;
run;
 

I have a proc means output as shown below:
I want to extract N from the table and evaluate N for neg/(N for neg + N for pos), pretty much get the proportion of negative data from total data. How to go about this problem?
SAS Output

The MEANS Procedure
Analysis Variable: Price price_type N Obs N
neg 594
pos 69478
594
69478
1 REPLY 1
Reeza
Super User

You need to direct your output to a data set and then you can use it in further steps.

 

*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;

Though, PROC FREQ is more suited to what you want, not PROC MEANS.

This generates an output data set called WANT_FREQ. It should generate the percents as well.

 

proc freq data=sashelp.class;
table price_type /out=want_freq;
run;

 

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 714 views
  • 0 likes
  • 2 in conversation