Date:         Mon, 14 May 2007 13:54:41 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: macro question.....maybe SYMPUT
Comments: To: peterflomconsulting@mindspring.com
In-Reply-To:  <12753026.1179150640376.JavaMail.root@mswamui-bichon.atl.sa.earthlink.net>
Content-Type: text/plain; format=flowed

Well I can go with that, simply create your macro passing the needed meta
data parameters.  Then use the Dictionary.columns or sashelp.vcolumns  as
yoru data set to get the variable names.  Should be pretty easy to cycle
through the entire data set.





Toby Dunn

On the other hand, you have different fingers. ~ LCG

The early bird may get the worm, but the second mouse gets the cheese in the
trap. ~ LCG

What happens if you get scared half to death, twice? ~ LCG





From: Peter Flom <peterflomconsulting@mindspring.com>
Reply-To: Peter Flom <peterflomconsulting@mindspring.com>
To: toby dunn <tobydunn@HOTMAIL.COM>, SAS-L@LISTSERV.UGA.EDU
Subject: Re: macro question.....maybe SYMPUT
Date: Mon, 14 May 2007 09:50:40 -0400 (GMT-04:00)

toby dunn <tobydunn@HOTMAIL.COM> wrote

 >Peter ,
 >
 >The fact that you have 900 variables should be enough room for concen to
 >stop ya and make you think.  First normalize your data, then add the group
 >min and max values, then simply use a where or subsetting if or if you
 >decide to use SQL use the having clause to cull down your data.
 >

Toby

Indeed, the 900 is of some concern.

The reason my boss wants what she wants is, in part, to try to see which of
the 900 are behaving in what way.  She's emphatically not a pointy haired
boss....and this is a field where she is a leading expert, and I am a total
neophyte, so, I am inclined to give her just what she asked for (also, I'm
new here, and have not yet established myself in a position to rock the
boat).

I do share your concern, but, this time, I gotta do what I was asked for.

Thanks

Peter

_________________________________________________________________
More photos, more messages, more storage—get 2GB with Windows Live Hotmail.
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_2G_0507