Hello all, I am new to SAS. I am trying to export some data from WRDS to excel. I am using the following code:
PROC SQL; CREATE TABLE WORK.query AS SELECT 'Name'n FROM CISDM.ACTIVE_FUND_INFO; RUN; QUIT; PROC DATASETS NOLIST NODETAILS; CONTENTS DATA=WORK.query OUT=WORK.details; RUN; PROC PRINT DATA=WORK.details; RUN; PROC EXPORT DATA=WORK.query; outfile='/home/qmul/beir/sasuser.v94/Book1' dbms=xlsx run;
I have uploaded an empty Excel file to SAS. The error I get is: ERROR: FILE=OR TABLE= is required and must be satisfied. Could you please help me with this? Thank you very much.
... View more