SAS Support Communities

how about this code.   %do MM = 01 %to 12; %if &MM<10 %then %let MM=0&MM.; /* Add this line */ ... View more

submit %global before submit macro or first in macro.   %global fromdate; %Start_Date;   %MACRO Start_Date; %global fromdate; %if %sysfunc(exist(ttt)) %then %do; ...   ... View more

Thank you all very much. I have solved the problem and here is the sample code. The part where the layout is adjusted and output is PROC REPORT, and the subsequent fine tuning was handled by rewriting the RTF control code.   ods _all_ close; ods noresults; filename rtf_in "%sysfunc(pathname(work))\rtf_in.rtf"; filename rtf_out "%sysfunc(pathname(work))\rtf_out.rtf"; ods rtf file=rtf_in; title; options nodate nonumber nobyline; proc sort data=sashelp.class out=class; by name; run; proc report data=class nowd; column name NameLabel sex age height weight; by name; define NameLabel / '' computed style(header)=[just=l backgroundcolor=white BorderTopColor=White BorderLeftColor=White BorderRightColor=White BorderBottomColor=White]; define name / noprint; compute NameLabel / character length=40; call define(_col_,'style','style={just=l fontweight=bold fontsize=14pt cellwidth=15cm BorderTopColor=White BorderLeftColor=White BorderRightColor=White BorderBottomColor=White}'); NameLabel ='Name: '||name; endcomp; compute sex; call define(_col_,'style','style={just=l cellwidth=7.5cm}'); endcomp; compute age; call define(_col_,'style','style={just=l cellwidth=7.5cm}'); endcomp; compute height; call define(_col_,'style','style={just=l cellwidth=7.5cm}'); endcomp; compute weight; call define(_col_,'style','style={just=l cellwidth=7.5cm}'); endcomp; run; ods rtf close; data _null_; infile rtf_in; file rtf_out; input; if _infile_='\pard\par' then _infile_='\pard'; else if index(_infile_,'\sect') then delete; put _infile_; run;   Results:   ... View more

If Date is character variable, use anydtdtm informat for converting to date value. data _null_; Date='30AUG2022:11:15:00.000'; dt=input(Date,anydtdtm22.); da=datepart(dt); tm=timepart(dt); format da date9. tm time12.4; run; ... View more

Macro variables created by call symput cannot be accessed as macro variables until the DATA step is completed, so please do the following.   Data _null_; Call symputx('firstm_start_date1', put(intnx('qtr', today(), -1, 'B'), date11.)) ; run; Data _null_; Call symputx('thirdm_start_date1', put(intnx('month', "&firstm_start_date1."d, 2,'B'), date11.)) ; run; Also, the "D" indicating the date must appear immediately after the quotation marks, so remove the space ... View more