Hi again all, Does anyone know how, using the Export File step in an EG project, to include a variable value in the output filename?  For example, if the report prompts for a favorite colour and I pick Red, I'd like for Red to appear in the filename of the saved report. Thanks again! ... View more

Hi again folks, As a newbie, I coded a report from scratch to practice using proc report - here's that code: proc report data=WORK.DISP_FMT_ALL nofs; columns COUNT_of_ALERT_DISPOSITION_ID SUM_of_HR SUM_of_SU SUM_of_CR SUM_of_FN SUM_of_CL SavedAmount LossAmount; define COUNT_of_ALERT_DISPOSITION_ID / display style(header)=[cellwidth=60]; define SUM_of_HR / display style(header)=[cellwidth=50] "HR"; define SUM_of_SU / display style(header)=[cellwidth=50] "SU"; define SUM_of_CR / display style(header)=[cellwidth=50] "CR"; define SUM_of_FN / display style(header)=[cellwidth=50] "FN"; define SUM_of_CL / display style(header)=[cellwidth=50] "CL"; define SavedAmount / display style(column)=[cellwidth=100] FORMAT=dollfmt. "Saved"; define LossAmount / display style(column)=[cellwidth=100] FORMAT=dollfmt. "Loss"; run; Question: How can I give the last 3 rows the same formatting as the header row?  It will help as a visual cue between the detail and total rows. Thanks in advance! ... View more

Hi all, I have been trying to create a calendar-style report - when I've seen examples using proc calendar, the output is very 80s like, using only ANSI characters.  But there must be a way to create a calendar report with a properly formatted grid and more up-to-date style, right?  I've found code that just creates the calendar, but don't know how to incorporate the dataset into this, as I am still pretty new to SAS: Data Calendar; Array Days(7) Sun Mon Tue Wed Thu Fri Sat (7*.); Format Sun Mon Tue Wed Thu Fri Sat Date Date5.;   Drop Date X; Do Date = '01Jan2013'D to '31Mar2013'D by 1;    Days(WeekDay(Date)) = Date;    /*Quarter = Put(Date,YYQ6.);*/    If WeekDay(Date) = 7 Then    Do; Output;     Do X=1 to Dim(Days); Days(X)=.; End;    End;   If Month(Date) NE Month(Date+1)Then    Do; Output;    Do X=1 to Dim(Days); Days(X)=.; End;    End; End; If NMiss(Sun,Mon,Tue,Wed,Thu,Fri,Sat) < 7 Then Output; Proc Print; Title1 'Calendar Data Step Output'; Run; This displays what's in the attachment.  Would I be able to do this using PROC Tabulate (or similar) and use NOOBS to hide the observation numbers? ... View more