I apologize Ballardw, that is a mistake I will not make again. I was giving you a file that you could read in, the data is the same as what the datastep did before, but I think you will see what I am trying to do from this. If the data is already read, can you format a particular column from that data that is a character into a numeric and allow me to put it in a proc tabulate column. so, instead of formatting and then reading in the data, do it something like this: data try; input Market $ Number Type $; datalines; Eastern 17 Low South 25 Mid Midwest 92 High West 33 Mid ; run; Proc format library=work; invalue type 'Low' = 1 'Mid' = 2 'High' = 3 ; value type 1 = 'Low' 2 = 'Mid' 3 = 'High' ; run; data try2; set try; informat type type.; format type type.; run; proc tabulate data=try; class Market; var Number; var Type; table Market='', Number='Count'*sum='' Type*max=''*f=type.; run; this does not run for me when I try it like this, I know it is in what I am doing, but can you provide assistance? thank you again and have a great day! sam
... View more