A little SAS 101.
You normally reference datasets with either one or two level names.
When you use a two level name like A.B then A is the LIBREF and B is the member name. When you use a one level name normally the LIBREF part is assumed to be WORK.
A libref is a nickname you create that allows you to reference datasets in various "libraries". You will always have a WORK library defined for temporary datasets that disappear when the SAS session ends. You can define other librefs using a LIBNAME statement. Typically a libref statement is in the form:
libname mylib 'location of folder';
Your current code most likely already has a libname statement to define a libref that points to the folder where it wrote those SAS datasets. So use that libref instead of the MYLIB name that I used in my example code to show you the syntax.
When you write a proc step in SAS you should include the PROC statement, any other statements the procedure needs to do what you want and then a RUN and/or QUIT statement to signal the end of the step. Most PROCs , like PROC EXPORT, need a RUN statement. Some, like PROC SQL, need a QUIT. Some , like PROC GLM or PROC DATASET, allow both. The RUN statement indicates that the PROC should do the statements up that point immediately and the QUIT statement marks the end of the whole PROC step.
So if you want to run muliple PROC EXPORT steps you need multiple PROC EXPORT statements.
proc export dbms=xlsx data=mylib.paxraw
file='/home/u64122702/Output/paxraw.xlsx' replace
;
run;
proc export dbms=xlsx data=mylib.perday
file='/home/u64122702/Output/perday.xlsx' replace
;
run;
Not sure what the pictures show. One of them I can tell is a WORK dataset name PERDAY. Remember that WORK datasets disappear when your current SAS sessions ends. So to reference the dataset in your picture you could use either WORK.PERDAY or just PERDAY.
proc export dbms=xlsx data=WORK.perday
file='/home/u64122702/Output/perday.xlsx' replace
;
run;
... View more
