topic Re: delete column with condition in SAS Programming

delete column with condition

radha009 — Tue, 20 Mar 2018 11:40:45 GMT

i have data with columns Names (win ,unix,sas,sep..etc) and data with yes and no. i want to delete the column without giving the column name.(ex: if sas column has all 'No' data).'

Thank you

Re: delete column with condition

LinusH — Tue, 20 Mar 2018 05:32:45 GMT

This probably need that you first query the table, and based on that issue your drop column statement. Macro logic is what I see.

There have been a lot of similar question on the communities, especially when all column uses are missing. Do a search and youbwould be able to learn from those.

Re: delete column with condition

gamotte — Tue, 20 Mar 2018 08:58:45 GMT

Hello,

data have;
    input col1 $ col2 $ col3 $;
cards;
Yes No No
No No Yes
Yes No Yes
;
run;

data NULL_;
    set have end=eof;
    array cols(*) col:;
    array nos(3)_TEMPORARY_;

    do i=1 to dim(cols);
        if strip(cols(i))="No" then nos(i)+1;
    end;

    if eof then do;
        call execute('data want; set have;');
        if max(of nos(*))=_N_ then do;
            call execute('drop');
            do i=1 to dim(cols);
                if nos(i)=_N_ then do;
                    call execute(vname(cols(i)));
                end;
            end;
        end;
call execute('; run;');
    end;
run;

Re: delete column with condition

radha009 — Tue, 20 Mar 2018 14:37:05 GMT

Perfect. thanks a lot.