OUTPUT

[SASTad]

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.

[data_null__ · Accepted solution]

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;

[SASTad]

Thank you so much for the help.