LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2007, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page