choosinig inputs

[Daniel1027]

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. 

[ballardw · Accepted solution]

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;