Date:         Mon, 8 Jan 2007 14:04:25 -0800
Reply-To:     "Mogens A. Krogh" <MKROGH@DSR.KVL.DK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Mogens A. Krogh" <MKROGH@DSR.KVL.DK>
Organization: http://groups.google.com
Subject:      Re: Specific variable list within a database
Comments: To: sas-l@uga.edu
In-Reply-To:  <382121.53383.qm@web58618.mail.re3.yahoo.com>
Content-Type: text/plain; charset="us-ascii"

Dear Fushun,
You can try to do something like this. But if large is realy 'large'
then it will not work very well.

data WANT (keep=varname);
set sashelp.class;
if _n_ in (3,4) then sex = ' ';
if _n_ = 9 then age =   .;
array num(*) _numeric_;
array cha(*) _character_;
do i=1 to dim(cha);
        IF CHA(i)=' ' THEN do;
        VARNAME=Vname(CHA(i));
        output;
        end;
end;
do ii=1 to dim(num);
        IF num(ii)=. THEN do;
        VARNAME=Vname(num(ii));
        output;
        end;
end;
run;
proc sort data=want nodupkey;
by varname;
run;


Regards,
Mogens A. Krogh
Phd-student, DVM
www.life.ku.dk


fushun zhang skrev:
> Hi,
>
>   I want to figure out a variable list for those contain all missing value within a large database. Does anyone know how to do this? Any help & suggestion are appreciated.
>
>   Thanks,
>
>   Zhang
>
>  __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com