topic Re: OUTPUT in SAS Procedures

OUTPUT

SASTad — Thu, 19 Feb 2015 22:22:56 GMT

Hello All,

I was trying to create an output for the dataset

ID Date Plan

1 jan2013 a

1 feb2013 a

1 mar2013 a

1 may2013 b

1 jun2013 b

1 jul2013 a

1 aug2013 a

the output i'm looking to get is ID Plan Date_range

1 a 1-3

2 b 5-6

3 a 7-8

Thanks. Looking forward to some responses.

Re: OUTPUT

data_null__ — Thu, 19 Feb 2015 22:51:15 GMT

You can format the min and max into date range yourself right?

data date;
   input ID Date:monyy.  Plan :$1.; 
   format date monyy.; 
   cards; 
1 jan2013   a
1 feb2013   a
1 mar2013   a
1 may2013   b
1 jun2013   b
1 jul2013   a
1 aug2013   a 
;;;;
   run; 
proc print; 
   run; 
proc summary data=date nway; 
   by id plan notsorted; 
   format date mmyy.; 
   output out=range min(date)=min max(date)=max; 
   run; 
proc print; 
   run;

Re: OUTPUT

SASTad — Thu, 19 Feb 2015 23:01:25 GMT

Thank you so much for the help.