topic Re: proc means in SAS Procedures

proc means

yaswoman — Fri, 18 Mar 2011 21:48:26 GMT

Hi can someone please tell me how I can do a PROC MEANS min max on a date value to find the lowest date and the higest date.

My code:
PROC MEANS DATA = temp.ms_trans MIN MAX;
VAR efectv_dt;
RUN;

The informat and format of the variable is DATE9.

I am getting

CUST_ID 08:54 Thursday, March 17, 2011 217
The MEANS Procedure

Analysis Variable : EFECTV_DT EFECTV_DT

Minimum Maximum
----------------------------
18322.00 18686.00
----------------------------

thanks so much for any input.

Re: proc means

Reeza — Fri, 18 Mar 2011 23:33:30 GMT

I don't know how to do it with proc means directly but what about outputting it to a dataset and printing it or using proc sql?

[pre]
proc means data=temp.ms_trans noprint;
var efectv_dt;
output out=sample min=min_date max=max_date;
run;

proc print;
run;

OR

proc sql;
select max(efectv_dt) as max_date, min(efectv_dt) as min_date
from temp.ms_trans;
quit;

[/pre]

Re: proc means

yaswoman — Fri, 18 Mar 2011 23:46:00 GMT

Thank You so much, will try that,

Re: proc means

Reeza — Sat, 19 Mar 2011 00:24:17 GMT

It is a friday afternoon...for the sql statement also need a format,
format=date9.

proc sql;
select max(date) as max_date format =date9., min(date) as min_date format =date9.
from sashelp.stocks;
quit;

Re: proc means

yaswoman — Sat, 19 Mar 2011 01:08:43 GMT

Yes I realized that, so I did add that + an create statement that would let me print.
thanks so much for your help.

Re: proc means

data_null__ — Sat, 19 Mar 2011 01:46:07 GMT

If you create an output data set with MEANS/SUMMARY the MIN and MAX will inherit the associated format.

[pre]
data test;
do date = today() to today()+10;
output;
end;
format date date9.;
run;
proc summary data=test;
var date;
output out=mm min=min max=max;
run;
proc contents varnum;
run;
proc print;
run;

Variables in Creation Order

# Variable Type Len Format

1 _TYPE_ Num 8
2 _FREQ_ Num 8
3 min Num 8 DATE9.
4 max Num 8 DATE9.

[/pre]

Re: proc means

yaswoman — Sat, 19 Mar 2011 03:48:05 GMT

Sorry I am not quite sure I understand what exactly that means.
the MIN and MAX will inherit the associated format.

thanks

Re: proc means

data_null__ — Sat, 19 Mar 2011 12:19:52 GMT

The format associated with the analysis variable will also be associated with the statistics, MIN and MAX.

RTM