Subset based on column from another dataset.
Posted: 17 December 2014 11:25 AM   [ Ignore ]
Newbie
Rank
Total Posts:  10
Joined  2014-11-10

Hey,

I have a large dataset with firm specific data on a monthly basis.

If i wish to obtain a subsample of this dataset, based on a vector of tickers, how do i do that?

The large dataset contains a column of tickers, and i want to extract a subsample of this, based on a subsample of the tickers.

(I have the column with the subsample of the tickers in another sas file)

//Jamil.

Profile
 
 
Posted: 18 December 2014 08:22 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Jamil,

Did you look into proc sql? That is a straighforward way to match datasets.

best regards,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 19 December 2014 07:01 AM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  10
Joined  2014-11-10

Hey Joost,

Sorry, it was pretty basic i see.

Jamil.

Profile
 
 
Posted: 19 December 2014 08:42 AM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

no problem smile

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile