topic Re: Subsetting a data set based on proc freq output in New SAS User

Subsetting a data set based on proc freq output

NewUsrStat — Fri, 07 Oct 2022 11:40:16 GMT

Hi guys,

suppose to run a proc freq with an output that looks like this:

ID Freq Perc ..

0001 ..... .....

0002 ..... .....

0008 ..... .....

0005 ..... .....

....... ..... .....

Suppose also to have a data set that looks like this:

ID Value1 Value2 ..

0001 ..... .....

0002 ..... .....

0003 ..... .....

0004 ..... .....

....... ..... .....

Is there a way to remove from the data set the IDs that appear in proc freq output?

Desired output:

ID Value1 Value2 ..

0003 ..... .....

0004 ..... .....

....... ..... .....

Thank you in advance

PaigeMiller — Fri, 07 Oct 2022 11:43:54 GMT

UNTESTED CODE (because you haven't given us actual data to work with)

This assumes both data sets are sorted by ID

data want;
    merge dataset2(in=in2) dataset1(in=in1);
    by id;
    if in2 and not in1;
    drop freq perc;
run;

NewUsrStat — Fri, 07 Oct 2022 12:02:10 GMT

Thank you very much!
It works perfectly.