DATA Step, Macro, Functions and more

choosinig inputs

Accepted Solution Solved
Reply
Contributor
Posts: 21
Accepted Solution

choosinig inputs

hi guys,

 

i would like to choose only if share code(shrcd=10 or 11) and exchange code (exchcd=1,2,3).

 

dataset looks like:

permno  namedt   shrcd  exchcd    ncusip 

13391    5/4/2012    71      13    68391610   (not needed)

12120     6/7/1993    11        2    04543330   (needed)

12121     9/24/1990   10      4      04890160   (not needed)

12120      8/2/1993     11     3      04543330    (needed)

 

any feedback is appreicated. 


Accepted Solutions
Solution
‎04-26-2016 03:32 PM
Super User
Posts: 11,343

Re: choosinig inputs

Posted in reply to Daniel1027

Is this to create a new dataset that is a subset or to feed into a procedure?

A new dataset cold be

Data want;

   set have;

   if shrcd in (10,11) and exchcd in (1,2,3);

run;

if the variables are character then the values should be in quotes : in ('10','11')

 

You can use a data seth option where to feed records with selected values

 

proc print data=have (where=(shrcd in (10,11) and exchcd in (1,2,3)));

run;

View solution in original post


All Replies
Solution
‎04-26-2016 03:32 PM
Super User
Posts: 11,343

Re: choosinig inputs

Posted in reply to Daniel1027

Is this to create a new dataset that is a subset or to feed into a procedure?

A new dataset cold be

Data want;

   set have;

   if shrcd in (10,11) and exchcd in (1,2,3);

run;

if the variables are character then the values should be in quotes : in ('10','11')

 

You can use a data seth option where to feed records with selected values

 

proc print data=have (where=(shrcd in (10,11) and exchcd in (1,2,3)));

run;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 177 views
  • 0 likes
  • 2 in conversation