Export data to Excel from WRDS

[beir]

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.

[andreas_lds]

A semicolon is missing after "dbms=xlsx".

[sbxkoenk]

Hello,

What is WRDS? Wharton Research Data Services?

To start with, I think your

outfile='/home/qmul/beir/sasuser.v94/Book1'

should be

outfile='/home/qmul/beir/sasuser.v94/Book1.xlsx'

Koen

[Reeza · Accepted solution]

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.xlsx'
dbms=xlsx replace;
run;

1. Remove semicolon after DATA= (too early)
2. Add extension to file name, Book1.xlsx
3. Add Replace to specify that it should write over any other Book1
4. Add Semicolon after Replace

---

@beir wrote:

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.

---

[Reeza]

Exporting to the sasuser folder is a weird location to export files.