topic Re: exact SAS result in dataset in SAS Programming

exact SAS result in dataset

Srigyan — Mon, 10 Jun 2019 15:07:43 GMT

When I run the following code.

proc means data=sd.customer NMISS N mean median mode min max ; output out=abc; run;

I get the following result:

Variable	N Miss	N	Mean	Median	Mode	Minimum	Maximum
identifier	0	509693	255001.16	255004	.	1	510000
birth_year	47	509646	1978.57	1981	1990	1900	1999
date_start	0	509693	20287.45	20283	20783	19724	20819
date_default	477886	31807	20527.28	20565	20633	19871	20893
date_completed	221487	288206	20429.46	20423	20675	19725	20895
date_last_payment	162336	347357	20509.99	20588	20878	19724	20896
open_to_buy_amt	0	509693	233.992523	0	0	-11410	10000
LTIME_NET_SALES_AMT	0	509693	343.159197	47.99	0	-2024	28336.7
LTIME_NO_ORDERS	0	509693	3.4911663	1	1	0	483
LTIME_RETURNED_AMT	0	509693	59.3251234	0	0	0	16231.2

but the table has different result.

How can I get the same result in dataset what we see in the result.

Re: exact SAS result in dataset

PaigeMiller — Mon, 10 Jun 2019 15:10:22 GMT

output out=abc nmiss=nmiss n=n mean=mean median=median mode=mode
    min=minimum max=maximum;

Re: exact SAS result in dataset

Srigyan — Mon, 10 Jun 2019 15:16:32 GMT

This is giving me overall count instead of variable wise.

Re: exact SAS result in dataset

Srigyan — Mon, 10 Jun 2019 15:17:37 GMT

_TYPE_	_FREQ_	nmiss	n	mean	median	mode	minimum	maximum
0	509693	0	509693	255001	255004	.	1	510000

Re: exact SAS result in dataset

Reeza — Mon, 10 Jun 2019 15:19:59 GMT

@Srigyan wrote:

This is giving me overall count instead of variable wise.

proc means data=sd.customer NMISS N mean median mode min max  STACKODS; 

ods output summary=abc;
 run;

The statistics on the OUTPUT statement control what goes to the OUT=data set.

The statistics on the PROC MEANS statement control what goes to the ODS output (listing/HTML). If you want the ODS table, you need an ODS statement and I like the STACKODS option to get it in a clean format.

Re: exact SAS result in dataset

PaigeMiller — Mon, 10 Jun 2019 15:20:37 GMT

You need to specify the variables by using the VAR statement.

proc means data=whatever nmiss n mean median mode min max;
    var identifier birth_year ... ; /* You type the rest */
    output out=abc nmiss=nmiss n=n mean=mean median=median mode=mode
        min=minimum max=maximum;
run;

Re: exact SAS result in dataset

Srigyan — Mon, 10 Jun 2019 15:25:54 GMT

what is stackods?

Re: exact SAS result in dataset

ballardw — Mon, 10 Jun 2019 15:30:18 GMT

@Srigyan wrote:

_TYPE_ _FREQ_ nmiss n mean median mode minimum maximum

0 509693 0 509693 255001 255004 . 1 510000

Without posting the EXACT code that you ran, preferably from the log with any notes, it is hard to tell what you may have done

Add / autoname to the OUTPUT statement after the requested statistics on the OUTPUT statement. The statistics on the proc statement do not affect the content of the output data set.

That will add variables with _mean _min _max etc. appended to the variable names.

Re: exact SAS result in dataset

Reeza — Mon, 10 Jun 2019 16:22:29 GMT

@Srigyan wrote:

what is stackods?

Example 13: Using the STACKODSOUTPUT Option to Control Data

https://documentation.sas.com/?docsetId=proc&docsetTarget=p17h6q7ygvkl1sn13qzf947dundi.htm&docsetVersion=9.4&locale=en#p17h6q7ygvkl1sn13qzf947dundi

https://documentation.sas.com/?docsetId=proc&docsetVersion=9.4&docsetTarget=n1qnc9bddfvhzqn105kqitnf29cp.htm&locale=en#p1jlrxmcdwyj5nn1ug9fmdzp9c2l

STACKODSOUTPUT

produces an ODS output object whose data set resembles the printed output.

The STACKODSOUTPUT option affects output data sets created by ODS OUTPUT statements, not the PROC MEANS OUTPUT statement.

Alias STACKODS

See Using the STACKODSOUTPUT Option to Control Data

Please refer to the SAS documentation, it is quite detailed and helpful.

Re: exact SAS result in dataset

Ksharp — Tue, 11 Jun 2019 10:25:35 GMT

Another way is PROC UNIVARIATE.

Pick stat you need.

proc univariate data=sashelp.class outtable=want noprint;
var _numeric_;
run;

proc print;run;

Re: exact SAS result in dataset

Srigyan — Tue, 11 Jun 2019 11:06:17 GMT

how to get all these details for char & numeric both. I can understand all thing are not possible for char but atleast n,nmiss and unique value in each column. How can i get it in a sas dataset.

if you have something for this...I didn't find any answer yet.

https://communities.sas.com/t5/SAS-Programming/Exploratory-analysis-macro/m-p/562031#M157402

Re: exact SAS result in dataset

Ksharp — Wed, 12 Jun 2019 10:57:18 GMT

Try SQL.

proc sql;
select sex,n(name) as n,nmiss(name) as nmiss,
count(distinct name) as distinct_name
 from sashelp.class
  group by sex;
quit;

Alias	STACKODS
See	Using the STACKODSOUTPUT Option to Control Data