Date:         Wed, 30 May 2012 17:56:13 +0000
Reply-To:     Chris Hemedinger <Chris.Hemedinger@SAS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Chris Hemedinger <Chris.Hemedinger@SAS.COM>
Subject:      Re: one pdf report is missing
In-Reply-To:  <CAM+YpE_UDP-+Px0-RVWAph7tSjiQh724Rf+kuPMQZvaXrBFExw@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"

The COUNTW approach of counting the distinct values might not be reliable.

See this blog post for some alternative techniques to accomplish the same thing.

http://blogs.sas.com/content/sasdummy/2012/03/20/sas-program-by-processing/

Short: http://bit.ly/GAI8lc

And for some new 9.3 approaches:
http://blogs.sas.com/content/sasdummy/2012/03/23/improving-on-a-sas-programming-pattern/

Short: http://bit.ly/LTMJlo

Chris

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Joe Matise
Sent: Wednesday, May 30, 2012 1:43 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: one pdf report is missing

You should probably look at your data, we certainly can't do that without said data... perhaps one of those values is missing or space?

-Joe

On Wed, May 30, 2012 at 12:39 PM, SAS Analyst <analystprasad@yahoo.co.in>wrote:

> Hi ,
>
> I ran below code i have got 37 reports,but distinct values of MAKE
> variable is 38.one report is missing.pls do needful.
>
> options symbolgen;
> proc sql noprint;
> select distinct(make) into:empvar separated by ' ' from sashelp.cars;
> quit; %put &empvar;
>
> %macro x;
> %let n=%sysfunc(countw(&empvar));
> %do i=1 %to &n;
> %let evar=%scan(&empvar,&i,%str(  ));
> data x;
> set sashelp.cars;
> where make="&evar";
> run;
> ods pdf file="C:\Users\home\Desktop\loop\testcars_&evar..pdf";
> proc report data=x nowd;
> run;
> ods pdf close;
>
> %end; %mend;
>
> %x
> regards,
> prasad
>