Hello Everyone, I am trying to create a report with numeric headers (i.e. 1 2 3 4 5 etc.) using proc report. Each number represents a work day of the month (1=1st work day of the month, notice 6 is skipped because it's a weekend).  The code below is manually updated to add a new day of data (next one would be _9) and produce a new report everyday.  The code works for that.  BUT I am trying to automate this process without manually updating the program daily.  The problem is with the column statement in proc report (high lighted in brown).  If  I pre-define all the work days of the month (_1 thru _30 or _31) proc report will generate an error "variable _XX not found".   Do I make sense?  Does anyone have any suggestions on getting around this obsticle? I really appreciate any input from anyone!! Thank you DATA: ID    _1  _2   _3  _4  _5  _7  _8 AA  45  78   44  09  74   77  99 BF  20   43   65  87  32   40  48 CODE: data new1; set new0; label id='ID' _1='1' _2='2' _3='3' _4='4' _5='5' _6='6' _7='7' _8='8'; run; proc report data=new1; column id _1-_5 _7 _8; define id /group; rbreak after /summarize; compute after;      id = 'Total'; endcomp; run;quit; ... View more

Hello Everyone, I am trying to format a SAS date from MMMYY to MMM-YY  (i.e. OCT12 to OCT-12). This is the code.  I can't figure out how to add a - between the month and the year. Thank you for input you may have! proc  format ; picture fmt(default=5) other='%b%y'(datatype=date); run; data _null_; a=23234; format a fmt.; put a= ; run; ... View more

Hello Everyone, How do I format a numeric field (i.e. 102012) as Oct 2012? I basically want to show the month (Oct) plus the year (2012).  Is this possible? Thank you so much for any input! ... View more