Help using Base SAS procedures

Filtering data in SAS

Reply
N/A
Posts: 0

Filtering data in SAS

Hi all

I am a SAS beginner.

I am working with financial time series data and need to filter out data for around 3000 firms from a huge data set. I have a unique ID by which I can identify these 3000 firms but I cant use standard statements such as 'if', 'where' in the SAS code because I dont think its practical to list 3000 objects in a SAS code.

Is there a way I can compare my ID variable in the main data set to the list of 3000 IDs i store as an external file? Or is there any other way of doing this? Do let me know.

Ronnie
SAS Employee
Posts: 160

Re: Filtering data in SAS

Hi ronmama

Your right about not writing 3000 if statements :-)

You can load your list of firms into SAS and then use i.e Data step merge or PROC SQL.

i.e have a look at this simple mock-up code
[pre]
data filtered;
merge timeseries(in=a)
firms(in=b);
by id;
if a and not b then delete;
run;
[/pre]
N/A
Posts: 0

Re: Filtering data in SAS

Hi geniz

thank you very much. it works.Smiley Happy

Ronnie
Ask a Question
Discussion stats
  • 2 replies
  • 110 views
  • 0 likes
  • 2 in conversation