topic proc format - to - sas if else conditional code in SAS Procedures

proc format - to - sas if else conditional code

jonam — Thu, 08 Sep 2011 20:37:00 GMT

My objective is to create if/else code from the proc format. 1. Does anyone know if sas stores the way it stores the metadata(i mean like sashelp.columns). I just want to know if there is an easy way to do this instead of parsing the code? Have anyone experienced similar requirement? Any help on this will be really appreciated.

proc format - to - sas if else conditional code

data_null__ — Thu, 08 Sep 2011 21:07:00 GMT

The PROC FORMAT CNTLOUT= data set contains all the info you will need to code gen IF/THEN or SELECT/WHEN statements for any value label format.

proc format - to - sas if else conditional code

art297 — Thu, 08 Sep 2011 21:25:42 GMT

Data_null has already provided your answer, but I have to ask a question: what are you trying to accomplish? One can usually to format related tasks a lot easier by simply making use of the formats.

proc format - to - sas if else conditional code

LinusH — Fri, 09 Sep 2011 06:30:57 GMT

agree with Art. Given the small piece of information, I would guess this is job for macros, not formats.

/Linus

proc format - to - sas if else conditional code

jonam — Fri, 09 Sep 2011 19:31:59 GMT

Good question!

I need to send a specification based on sas code to a person who doesn't work in sas. I mean i need to provide more generic way to the person who programs this in different language.

Also i need to more explicity mention "missing". The other implicitly gives the values in my case.