Using SAS Function to Create SAS Format

[jimbobob]

I'm trying use proc fcmp to create a function that in turn creates a format, I've tried using the SAS sample code: https://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#n1eyyzaux0ze5ln1k03g...

I know the sample given is formatting a numeric field, in my code my data in character and I want the format to come out as a character. in the attached code you can see the NAICS_CD column in the proc print comes out blank, but I want it to match the INDUSTRY_CD column. Attached is my code. thanks

[CurtisMackWSIPP · Accepted solution]

You need to use a character format.  Notice the $.

proc format;
   value $FINDUSTRY_CD 
         other=[FINDUSTRY_CD()]; 
run;

[jimbobob]

Thanks been staring at this for hours. Apprecaite it.