SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mexes
Calcite | Level 5

Hi everybody

I have a little probleme with SAS in connection with WRDS. I need to download for a large number of firms some stock data. For all the firms I have the cusip. So far I downloaded the data using this code and it worked.

libname mylib "C:\Data";

rsubmit;

%let clist = '000361' '000957' '001031' '001055' '001204' '00163U';

data stockprice;

set crsp.dsf;

where cusip in (&clist);

keep prc cusip ret;

run;

.

.

.

. and so on

But now I have to do the same download for thousands of firms. Is there a possibility to save a txt or sas7bdat file which contains the cusip's and to tell SAS that it should use this file in order to download the data from the WRDS server? In this way I do not have to copy the cusips in the download code and it would be much more easy to make the download.

Many thanks for your help.

1 ACCEPTED SOLUTION

Accepted Solutions
Linlin
Lapis Lazuli | Level 10

/* find a way to put all the IDs in a dataset */

data have;

input cid $@@;

cards;

000361  000957   001031 001055 001204 00163U

;

/* create macro variable clist */

proc sql noprint;

select quote(cid) into :clist separated by ',' from have ;

quit;

/******************************/

libname mylib "C:\Data";

rsubmit;

data stockprice;

set crsp.dsf;

where cusip in (&clist);

keep prc cusip ret;

run;

.

.

.

. and so on

View solution in original post

2 REPLIES 2
Linlin
Lapis Lazuli | Level 10

/* find a way to put all the IDs in a dataset */

data have;

input cid $@@;

cards;

000361  000957   001031 001055 001204 00163U

;

/* create macro variable clist */

proc sql noprint;

select quote(cid) into :clist separated by ',' from have ;

quit;

/******************************/

libname mylib "C:\Data";

rsubmit;

data stockprice;

set crsp.dsf;

where cusip in (&clist);

keep prc cusip ret;

run;

.

.

.

. and so on

Ksharp
Super User

Using call execute() .

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 883 views
  • 3 likes
  • 3 in conversation