topic Re: Export data to Excel from WRDS in New SAS User

Export data to Excel from WRDS

beir — Tue, 11 Jan 2022 16:17:45 GMT

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.

Re: Export data to Excel from WRDS

andreas_lds — Tue, 11 Jan 2022 13:01:19 GMT

A semicolon is missing after "dbms=xlsx".

Re: Export data to Excel from WRDS

sbxkoenk — Tue, 11 Jan 2022 13:04:42 GMT

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

Re: Export data to Excel from WRDS

Reeza — Tue, 11 Jan 2022 16:21:20 GMT


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;

Remove semicolon after DATA= (too early)
Add extension to file name, Book1.xlsx
Add Replace to specify that it should write over any other Book1
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.

Re: Export data to Excel from WRDS

Reeza — Tue, 11 Jan 2022 16:22:47 GMT

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