I am importing text file and want to build the file path based on the month and year from a prompt variable, then use the file path in  an infile statement. Normally strings are my thing but apparently not in SAS. I have included a condensed version of my code to show what I am trying to accomplish. Any advice?    Data myDataSet ; %let month = %sysfunc(putn(%sysfunc(month("&PV_ReportMonth."d)), z2.)); %let year = %sysfunc(year("&PV_ReportMonth."d)); /* I want to dynamically build the file name and path from a Date Prompt variable &PV_ReportMonth */ mytextfilepath = "C:\mypath\mytextfile"||@month||@day||".txt"; /* So if user chose May 2018. mytextfilepath would be "C:\mypath\mytextfile052018.txt" /* And use it like this */ infile mytextfilepath DLM='|' firstobs=2; input Var1 ~$10. Var2 $ Yada $ Blah $; run;   ... View more

In a PROC REPORT I figured out how to insert a sub-title row before a new group begins, but I cannot figure out out to get the correct group name into the sub-title.   Notice that in my output : 1st sub-title text is 'Make:' 2nd sub-title is 'Make: Chevy' It is supposed to be 1st sub-title should be 'Make: Chevy' 2nd sub-title should be  'Make: Ford' My code is below, screen shot of output is attached.   Here is the code to create data for this example: data cars; infile datalines dlm=','; input makeNum make:$12. _BREAK_:$25. description:$50. retail myCost; datalines; 1,Chevy, , Chevy-Impala-Red, 32000, 29000 1,Chevy, , Chevy-Impala-Blue,32000, 29500 1,Chevy,makeModel, Total: Chevy-Impala, 64000, 58500 1,Chevy, , Chevy-Malibu-White, 28000, 26500 1,Chevy,makeModel, Total: Chevy-Malibu, 28000, 26500 1,Chevy,make, Total: Chevy,92000, 85000 2,Ford, ,Ford-Fiesta-Silver,14000,12000 2,Ford, ,Ford-Fiesta-Blue,14000,12000 2,Ford,, ,Ford-Fiesta-Gold,14500,12000 2,Ford,makeModel, Total: FordFiesta, 42500,36000 2,Ford, ,Ford-Focus-Silver, 17000, 16000 2,Ford, ,Ford-Focus-Blue,1700,15800 2,Ford,makeModel, Total: Ford-Focus,34000,31800 2,Ford,make, Total: Ford, 76500,67800 , , _RBREAK_, TOTAL: ,168500,152800 ; run;   Here is my code for the report: TITLE1 "List Report"; FOOTNOTE1 "Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), TIMEAMPM12.))"; proc report data=WORK.CARS nowd; column makeNum make _BREAK_ description retail myCost; define makeNum / group missing order=data noprint; define make /group missing order=data noprint; compute make; if make ne ' ' then hold1=make; if make eq ' ' then make=hold1; endcomp; define _BREAK_ / display '_BREAK_' missing order=data noprint; define description / display 'description' missing order=data; define retail / display missing order=data; define myCost / display missing order=data; compute _BREAK_; if _BREAK_ ne ' ' then do; call define(_ROW_,'style','style=[font_weight=bold foreground=Black paddingbottom=10]'); end; endcomp; COMPUTE Before makeNum; LENGTH text $ 50; IF makeNum > 0 THEN DO; text = cat('Make: ', make); num=50; END; ELSE DO; text = ""; num=0; END; LINE text $VARYING. num ; ENDCOMP; run; quit; TITLE; FOOTNOTE; ... View more

For debugging purposes is there a way I can write a variable (column) value to the log in a PROC REPORT?       ... View more

I am currently porting report summary SQL from COGNOS Report Sudio to SAS EG. The SQL in the below segment defines a sub-total label for widgets in 2 different grouping categories. I know widget (type) is suppose to resolve to a range of either 1-11 or 13-28 based on its subtype, but I am baffled how this logic works once it finishes the inner most case statement.    Could someone help me understand the logic of the 5th line from the bottom  i.e. "end  < 1"  and how it pertains to the remaining 4 lines? I see the obvious logic but it does not make sense to me as applied to the result, specifically the "end  < 1". Here is and abridged version of the SQL segment:   case when case when (case when (Widget.SubType in (100, 105, 110, 115)) then 1 when (Widget.SubType in (140, 145)) then 3 ........... ........... when (Widget.SubType in (133, 138)) then 11 when (Widget.SubType in (71, 72)) then 13 when (Widget.SubType in (80, 81, 85, 88)) then 14 ........... ........... when (Widget.SubType in (200, 201, 202, 205, 210, 215, 225, 230, 235)) then 28 else 999 end < 1) then '1' else '2' end = '1' then 'Widget Types 1 through 11' else 'Widget Types 13 through 28' end   ... View more

Platform: SAS EG   Problem: I have a macro variable (&PV_EndDate) from a date prompt that I display in a reaport header. The date is displayed as 31Dec2016, but I want it displayed as 12/31/2016. After much trial an error I cannot get it to work. Any Suggestions?   My Code: data _null_;     %put &PV_EndDate; /* prints '31Dec2016' to log */     End_Date="&PV_EndDate"d;     newDate = put(&&End_Date,mmddyy10.);     put newDate; /* prints '12/31/2016' to log */      %Global MV_EndDate;     %let MV_EndDate = newDate; run; %put &MV_EndDate; /* prints 'newDate' to log */      Header Code:    TITLE3 "End Date: &MV_EndDate";       ... View more