choosinig inputs

Daniel1027 — Tue, 26 Apr 2016 19:01:52 GMT

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.

Re: choosinig inputs

ballardw — Tue, 26 Apr 2016 19:25:39 GMT

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;