Date:         Fri, 25 Sep 1998 10:37:16 -0400
Reply-To:     "Brucken, Nancy" <Nancy.Brucken@WL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Brucken, Nancy" <Nancy.Brucken@WL.COM>
Subject:      Re: Tabulate var is character
Comments: To: "Boylan, Dave" <dboylan@UTILICORP.COM>
Content-Type: text/plain

Hi Dave,
     Delete your VAR statement, and add CUST to your CLASS variables, so
that your PROC TABULATE looks like:
 
        Proc tabulate missing data=folder.png;
            where yrmo ge 9605 and yrmo le 9607;
            class yrmo state CUST;
            Table state, yrmo*cust*f=comma12.;
        run;
 
Hope this helps,
       Nancy
 
Nancy Brucken
Parke-Davis, QIP
(734) 622-5767
Internet address:  Nancy.Brucken@wl.com
 
 
 
 
> -----Original Message-----
> From: Boylan, Dave [SMTP:dboylan@UTILICORP.COM]
> Sent: Friday, September 25, 1998 9:45 AM
> To:   SAS-L@UGA.CC.UGA.EDU
> Subject:      Tabulate var is character
>
> I'm trying to summarize a data set using Tabulate.  I'm running into
> trouble
> because my 'cust' variable is character.  I want to count the number
> of
> customers by state and year.  The error is:
>
> 'ERROR: Variable CUST in list does not match type prescribed for this
> list.'
>
> Is there a simple way to get the job done, other than a data step to
> change
> the cust var from character to numeric?
>
> The code is:
>
> Proc tabulate missing data=folder.png;
>     where yrmo ge 9605 and yrmo le 9607;
>     class yrmo state;
>     var cust;
>     Table state, yrmo*cust*f=comma12.;
> run;
>
> Thanks
> --------------------------------------
> David Boylan
> Corporate Forecasting
> UtiliCorp United, Inc.
> 816.467.3062
> --------------------------------------