topic Re: NEED HELP !!! Proc format and proc means in SAS Procedures

NEED HELP !!! Proc format and proc means

chrissowden — Wed, 29 Aug 2018 02:39:10 GMT

Hey Everyone,

I am trying to add a format that would show all obs that have smoked at some time. The 1,2,3,9 should represent that value as a smoker as some point in the gestation. if I remove the 1,2,3,9 then I get everything else and it works great. But I want to add who has smoked at some point to my proc means.

proc format;
   value smk

       0 ='Non-Smoker'
       1= 'Smoker Currently'
       2='Smoker until current pregnancy'
       3='Stopped before current pregnancy'
       9='Unknown'
       1,2,3 ='Smoker at some point' **trying to add this format**

   ;
run;

proc means data=mysas.birthweight n mean median std nonobs;
   format smoke smk.;
   class smoke;
   var birth_wt gestation;
   label birth_wt ='Birth Weight (.oz)' gestation='Gestation Period (days)';
run;

Re: NEED HELP !!! Proc format and proc means

Astounding — Wed, 29 Aug 2018 03:54:43 GMT

You're trying to subset the observations? Do that within PROC MEANS. There, you can easily add:

where smoke in (1, 2, 3);

It's

Re: NEED HELP !!! Proc format and proc means

Kurt_Bremser — Wed, 29 Aug 2018 06:18:42 GMT

Look at the multilabel option, as described in https://blogs.sas.com/content/sgf/2016/12/16/creating-and-using-multilabel-formats/