Hello all,
I use the following program to export a SAS dataset to an XLSX template workbook:
proc export
data=work.dataset
file="/directory/Workbook Template"
dbms=XLSX
replace
label;
sheet='Data';
However, the next step I would like is for the the workbook to be copied (so I keep the original template) and rename the workbook just created with something like "Workbook &SYSDATE.xslx"
I have tried the solution to this post with no success and also tried the following code:
data _null_;
infile "/directory/Workbook Template.xlsx" lrecl=32767;
file "/directory/Workbook &RPT_DT_CHAR..xlsx";
input;
put _infile_;
run;
Yet this corrupts the workbook and renders it unopenable.
Does anyone have a solution to this problem that they could share with me please?
Regards,
Ed
An XLSX file is actually a ZIP file with lots of contents. Hence reading/writing it as character will result in a corrupt file. You need to read/write as byte per Chris's post here:
To use datastep method.
As @Reeza has said you could use OS commands via X if that is enabled. Alternatively just export the file twice.
Try an X command statement
x 'copy "path to file1" "path to new file"';
An XLSX file is actually a ZIP file with lots of contents. Hence reading/writing it as character will result in a corrupt file. You need to read/write as byte per Chris's post here:
To use datastep method.
As @Reeza has said you could use OS commands via X if that is enabled. Alternatively just export the file twice.
Cheers to you both, though Chris's method in RW9's post worked the best for me.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.