NEED HELP !!! Proc format and proc means

[chrissowden]

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;

[Astounding]

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 

[Kurt_Bremser]

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