topic Re: Using SAS Function to Create SAS Format in SAS Programming

Using SAS Function to Create SAS Format

jimbobob — Wed, 23 Sep 2020 22:19:40 GMT

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#n1eyyzaux0ze5ln1k03gl338avbj.htm

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

Re: Using SAS Function to Create SAS Format

CurtisMackWSIPP — Wed, 23 Sep 2020 22:26:37 GMT

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

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

Re: Using SAS Function to Create SAS Format

jimbobob — Wed, 23 Sep 2020 22:30:46 GMT

Thanks been staring at this for hours. Apprecaite it.