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!     ... View more

data dataset_b; set dataset_a; if year = 1995 then cost = charge*ccr1995; if year = 1996 then cost = charge*ccr1996; if year = 1997 then cost = charge*ccr1997; if year = 1998 then cost = charge*ccr1998; if year = 1999 then cost = charge*ccr1999; if year = 2000 then cost = charge*ccr2000; if year = 2001 then cost = charge*ccr2001; if year = 2002 then cost = charge*ccr2002; if year = 2003 then cost = charge*ccr2003; if year = 2004 then cost = charge*ccr2004; if year = 2005 then cost = charge*ccr2005; if year = 2006 then cost = charge*ccr2006; if year = 2007 then cost = charge*ccr2007; if year = 2008 then cost = charge*ccr2008; if year = 2009 then cost = charge*ccr2009; if year = 2010 then cost = charge*ccr2010; if year = 2011 then cost = charge*ccr2011; if year = 2012 then cost = charge*ccr2012; if year = 2013 then cost = charge*ccr2013; if year = 2014 then cost = charge*ccr2014; run; Hi All，   I think it is a very basic and easy question about macro and do loop.  Could anyone help to simplify it?   I have tried some different ways to code. None of them works....   Thanks a lot!   Qian ... View more