Date: Fri, 19 Sep 2008 08:26:12 -0700
Reply-To: "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Subject: Re: Printing exact number of variables
Content-Type: text/plain; charset="us-ascii"
Somebody who has had their morning coffee
may have a fancier solution but here is
* sample data ;
bidder1=1; bidder2=.; bidder3=1;
bidder4=.; bidder5=1; bidder6=1;
bidder1=2; bidder2=.; bidder3=2;
bidder4=.; bidder5=2; bidder6=2;
proc transpose data=a out=b;
if col1 eq . then delete;
proc transpose data=c out=d;
proc print data=d;
Hope this is helpful.
Senior Programmer Analyst
Investment Management & Research
Global Leaders in Multi-Manager Investing
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Friday, September 19, 2008 7:54 AM
Subject: Printing exact number of variables
I have data set a that can have up to 10 vars called bidder1, bidder2 .
When any of these variables have value for one observation they have
values for all observations.
This data set is produced on the fly, i.e I do not know how many bidders
exist ahead of time.
proc print data=a;
Prints 10 even if some of them are completely blank.
Now, is there a way to determine and print only those that have