Creating SAS macro variable using Dataset

[Mani1]

thank you for your support... I was trying both the approach and learning.

[Mani1]

I tried it  yesterday, and it worked well.

Thanks for your support.

[ballardw]

I think adding macro variables is just going to make things harder to maintain or understand.

If I understand your goal then something more like

proc sql;
    create table want as
    select <variable list>
    from dataset
    where dn in ('CH' 'HY' 'WH')
       and FC in ('ABC1' 'ABC2' '123ABC' '456ABC' 'ABCXYZ' 'ABCQWE')
       and SFC in ('ABC1234' 'ABC4567' )
       and PN  in ('ch1234' 'ch5678')
   ;
quit;

I didn't put your full list of values for SFC and PN but the pattern should be clear. ( and they appear to be dummy values as well)