topic How to insert date in odstext in SAS Programming

How to insert date in odstext

bijayadhikar — Fri, 05 Jan 2024 13:28:12 GMT

Hi, is there a way to insert date after "Date Extraction:" below,

proc odstext;

p 'Source:'/ style=[color=blue fontsize=12pt fontfamily='Courier New' fontweight=bold];

list;

item 'Master Database, Date Extraction: ' / style=[fontsize=11pt fontfamily='Courier New'];

end;

run;

Re: How to insert date in odstext

yabwon — Fri, 05 Jan 2024 13:32:48 GMT

a macro variable for start?

%let date=%sysfunc(int('14mar2024'd),yymmdd10.);

proc odstext;
 p 'Source:'/ style=[color=blue fontsize=12pt fontfamily='Courier New' fontweight=bold];
  list;
item "Master Database, Date Extraction: &date." / style=[fontsize=11pt fontfamily='Courier New']; 
end;                     
run;

Bart

Re: How to insert date in odstext

Kurt_Bremser — Fri, 05 Jan 2024 13:38:27 GMT

Use a macro variable, and double quotes:

%let date = %sysfunc(today(),yymmdd10.);

proc odstext;
 p "Source:"/ style=[color=blue fontsize=12pt fontfamily='Courier New' fontweight=bold];
  list;
item "Master Database, Date Extraction: &date." / style=[fontsize=11pt fontfamily='Courier New']; 
end;                     
run;

Hint: use single quotes in SAS only where explicitly needed, or if you need to prevent the resolution of macro triggers.

Re: How to insert date in odstext

bijayadhikar — Fri, 05 Jan 2024 14:41:13 GMT

Thank you to @yabwon for quick response and solution. Appreciated.

Re: How to insert date in odstext

bijayadhikar — Fri, 05 Jan 2024 14:41:28 GMT

Thank you to @Kurt for quick response and solution. Appreciated.