topic Re: How to create formate from dataset? in SAS Programming

How to create formate from dataset?

qiali — Fri, 14 Sep 2018 23:13:25 GMT

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!

Re: How to create formate from dataset?

data_null__ — Fri, 14 Sep 2018 23:15:56 GMT

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

Re: How to create formate from dataset?

novinosrin — Fri, 14 Sep 2018 23:16:11 GMT

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

Re: How to create formate from dataset?

bobpep212 — Fri, 14 Sep 2018 23:18:58 GMT

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

Re: How to create formate from dataset?

qiali — Fri, 14 Sep 2018 23:39:39 GMT

Thank you so much for your quick reply!!!