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 (September 1998, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 > --------------------------------------


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