How to create formate from dataset?

[qiali]

Hello, everything,

Is it possible to create a format from the dataset? 

Here is my data: 2 variables, 1st one "symptom" is a character variable, 2nd one "category" is numerical.

I want to format category by the value of symptom.

Instead of creating by hand using proc format, is there any easy way to do it? since I have many datasets, like this one. 

Symptom category
Anorexia      1
Cachexia     2
Dizziness      3
Fever/Pyrexia 4
Malaise 5
Obesity 6
Orthostatic hypotension 7
Syncope 8
Underweight 9

Thanks a lot!

[data_null__]

Yes. Everything you need to know is in the online documentation for PROC FORMAT. See CNTLIN proc statement option.

[novinosrin]

Please refer to the doc http://www2.sas.com/proceedings/forum2007/068-2007.pdf

[bobpep212 · Accepted solution]

You add a column to the dataset that will be your format name. Then, you rename the value to LABEL and symptom to START (or vice versa, whichever way you are going). Then proc format with cntlin=ds_name option.

http://www2.sas.com/proceedings/forum2007/068-2007.pdf

[qiali]

Thank you so much for your quick reply!!!