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?
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.
"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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.