Hello, I have in a string value the date time in this format  "2018-09-04T14:11:58.000Z".      I've been trying the SAS ISO formats within an INPUT statement but can't identify the correct format from the support documentation  SAS ISO Support Documentation         ... View more

Hi I'm creating a master data table which will then be updated daily to add, update, and remove records.    Has anyone achieved slowly changing dimension type 2 load approach using Enterpise Guide?   Thanks! ... View more

Hello I'm using Enterprise Guide 7.1 (32bit) on a windows 10 PC.     The difficulty I have is controlling when a new worksheet is to be created, particularly when I want the worksheet to contain multiple procedures, so SHEET_INTERVAL='Proc' is no good for me. What I'm finding is the following: SHEET_INTERVAL='NOW' generates an error message and doesn't seem to be valid. SHEET_INTERVAL='none' doesn't seem to work if used for two successive worksheets.   All insights into this are welcome, I look forward to your input. RB1 ods listing close; ods results off; * Open the workbook and start the first worksheet. ; ods Excel file = "C:\.....\Test.xlsx" style=htmlblue options( sheet_name = "One Proc" ); proc print data=sashelp.cars; run; * Commence a second worksheet with multiple print procedures contained within it. ; ods Excel options( sheet_name = "Two Procs" sheet_interval='none' ); proc print data=sashelp.class; run; proc print data=sashelp.classfit; run; * A third worksheet with two printing procedures. NOW or NONE or omitted SHEET_INTERVAL do not work as I expected, resulting in the second worksheet containing 4 print outputs.; ods Excel options( sheet_name = "Two more Procs" /* sheet_interval='now'*/ sheet_interval='none' ); proc print data=sashelp.class; run; proc print data=sashelp.fish; run; ods excel close; ODS LISTING; ... View more