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 2008, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 17 Jan 2008 11:34:52 -0500
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: How to check what variable of dataset has a particular value

On Thu, 17 Jan 2008 08:11:50 -0800, Pardee, Roy <pardee.r@GHC.ORG> wrote:

>Did you try Ron's suggestion?

Ron was inspecting variable "labels" (metadata), not variable values.

>I think that does what you want--it >should return info from every member (dataset, view etc.) in libname >'LIBRARY'. You'll no doubt want to change that library to match the >libname you're interested in (and don't forget to specify that in >all-caps). > >HTH, > >-Roy > >-----Original Message----- >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of >SAS_learner >Sent: Wednesday, January 16, 2008 6:50 AM >To: SAS-L@LISTSERV.UGA.EDU >Subject: Re: How to check what variable of dataset has a particular >value > >Hello Ronald, > >I think I was not clear enough in my question Okay if I have if for >example in a Library where there more than say 30 to 50 datasets and in >one of dataset there is observation value "INFORMED CONSENT DATE" and I >do not know which dataset has that . Is there a way to find out which >Variable has a value equal to "INFORMED CONSENT DATE" > > Please let me know if I am clear enough otherwise I can write back with >an example in that way I might be clear enough > >thanks for your help > > > >On Jan 15, 2008 4:13 PM, Fehd, Ronald J. (CDC/CCHIS/NCPHI) ><> >wrote: > >> > From: SAS_learner >> > Subject: How to check what variable of dataset has a particular >> > value >> > >> > hello _all_, >> > >> > I am using following .SAS program to Check if there a Variable exits > >> > in the whole Library >> > >> > Proc Contents Varnum data = Raw._all_ >> > Out = co(Keep = memname Name ) Noprint ; >> > run; >> > ***Check if a variable with a Required name exits in whole >> > Library**; Proc Sql Noprint ; >> > create table test1 as >> > Select memname, name >> > from co >> > where upcase(name) like ('%CDTC%') ; Quit ; >> > >> > In the Above example I am checking if there is a variable CDTC in >> > the Name, but If sometimes I need to check the value of a variable >> > for example I was looking If what variable in the library has a >> > value "INFORMED CONSENT DATE " then I can use corresponding Date >> > as INFCDTC. >> > >> > I need check different domains to see where it is collected instead > >> > I want a SAS program to tell me what variables has value close to >> > Query String in this case "INFORMED CONSENT DATE". >> > >> > Is it Possible to check in Whole Library. >> >> you want Dictionary.Columns which >> >> PROC SQL; select MemName, Name, Type, Length, Label >> from Dictionary.Columns >> where LibName eq 'LIBRARY' >> and ( upcase(name) like ('%CDTC%') >> or upcase(Label) contains ('INFORMED') >> or upcase(Label) contains ('CONSENT') >> or upcase(Label) contains ('DATE') >> ); >> quit; >> >> You could use this >> or upcase(Label) contains ('INFORMED CONSENT DATE') >> >> but the above will give you more hits to ponder >> >> Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov >>

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