Help using Base SAS procedures

proc format

Reply
Contributor
Posts: 45

proc format

jobfmt.pngpayrolljobcode.pngpayrollprint.pnglogerror.png

 

I tried to create a character format and when I use the format in the print statement, the log window displays the following error. I defined the format type to be a character type format. But the error message tells me that I'm using a numerical format type on a character variable. What can be the solution? how can JobCode's - mixed values (character and numeric type) be displayed using a proc format? Is it possible? If no, is there any other solution for this? 

Super User
Posts: 6,927

Re: proc format

When you create the format $JOBF with proc format, you also must use the format $JOBF (note the dollar sign) in the format statement that assigns the format to a variable. A format without the dollar sign is always indicating a numeric format.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 45

Re: proc format

Done that, but of no use. My variable has mixed values. So I need to figure how to create a format for the jobcode values like 'ME2' and 'SE3'. Is there any way?
Super User
Posts: 6,927

Re: proc format

"Mixed values" does not mean mixed type. If your variable can contain alphanumeric values, then your variable is of type character, period.

So you must create and use a character format.

If you have numeric values in your string that need to be displayed with a generic number format, you will have to do a character-to-numeric conversion before applying a numeric format.

 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 3 replies
  • 255 views
  • 0 likes
  • 2 in conversation