About TG_WPAFB

TG_WPAFB · ‎02-21-2012

You could increment the current date by one in a data step, that would always put you to the previous month end. %LET TIMESTAMP=29NOV2011; DATA _NULL_; SASDate=INPUT("&TIMESTAMP",date9.)+1; SASDate1=INTNX('MONTH',SASDate,-1,'END'); CALL SYMPUT("usage_timestamp",PUT(SASDate1, date9.)); RUN; DATA FILE_&usage_timestamp; PreviousMonthEnd="&usage_timestamp"; RUN;

TG_WPAFB · ‎02-08-2012

Can you use ODS HTML TEXT / or a tagset? Also could you use a preHTML function on a proc report? What is the desired output format? ODS HTML TEXT="<DIV align=Left style='position:absolute; top:1px;'><IMG Src='Filename.jpg'></DIV> "; PROC REPORT DATA=FINAL LS=256 STYLE(report)={prehtml="<DIV align=Left style='position:absolute; top:1px;'><IMG Src='Filename.jpg'></DIV> " rules=none}; -Tony

TG_WPAFB · ‎02-06-2012

Another way to keep the leading zeros is to create a tagset based on the CSVALL tagset. Below is an example of one I created based on an example from Chevell Parker (http://www2.sas.com/proceedings/sugi28/012-28.pdf). PROC TEMPLATE; DEFINE tagset Tagsets.CSVDownload; parent=tagsets.CSVALL; DEFINE event data; PUT "," / if !cmp(COLSTART , "1"); PUT '=' """" / if cmp( TYPE ,"string"); PUT VALUE; PUT """" / if cmp( TYPE , "string"); END; END; RUN; %LET RV=%SYSFUNC(APPSRV_HEADER(CONTENT-TYPE,TEXT/CSV)); ODS markup BODY=_webout tagset=Tagsets.CSVDownload; %LET RV=%SYSFUNC(APPSRV_HEADER(CONTENT-DISPOSITION,%STR(ATTACHMENT;FILENAME="DownLoad.csv"))); proc print data=one; RUN; ODS markup close;

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

setting macro dates

Re: titles with escapechar and ODS

Re: Export SAS Numeric Characters to CSV

setting macro dates

Re: titles with escapechar and ODS

Re: Export SAS Numeric Characters to CSV