topic Re: Procedures that support multilabel formats? in SAS Procedures

Procedures that support multilabel formats?

Davanden — Fri, 24 Jan 2020 13:56:52 GMT

Is there a complete list of SAS procedures that support multilabel formats? Today I'm interested in SURVEYMEANS, but tomorrow it could be another one.

Re: Procedures that support multilabel formats?

Norman21 — Fri, 24 Jan 2020 14:36:58 GMT

"Multilabel formats are available for use only in the MEANS, SUMMARY, TABULATE, and REPORT procedures. "

https://blogs.sas.com/content/sgf/2016/12/16/creating-and-using-multilabel-formats/

Re: Procedures that support multilabel formats?

data_null__ — Fri, 24 Jan 2020 15:07:45 GMT

You can use a procedure like PROC SUMMARY to expand your data using a MLF and output a data set used as input to another procedure.

/*Expand data using MULTILABEL formats*/
proc format;
   value $sex(multilabel notsorted)
      'M'     = 'Male'
      'F'     = 'Female'
      'X'     = 'Unk'
      'M','F' = 'Both'
      'X','F','M' = 'Total'
      ;
   quit;
data class;
   _obs_ + 1;
   set sashelp.class(keep=sex);
   if _n_ eq 5 then sex='X';
   retain _sentinal1 ' ';
   set sashelp.class(drop=sex);
   retain _sentinal2 ' ';
   run;
proc print;
   run;
proc summary data=class nway completetypes missing;
   by _obs_;
   class sex / order=data mlf preloadfmt;
   format sex $Sex.;
   output out=expand(drop=_type_ _SENT: where=(_freq_ gt 0)) idgroup(out(_sentinal1--_sentinal2)=) / levels;
   run;
proc print;
   run;

Re: Procedures that support multilabel formats?

ballardw — Fri, 24 Jan 2020 16:17:46 GMT

I think that you might try creating CLASS or DOMAIN variables for each level of your multilabel format for use with Survey procs. This is likely to involve sending the output to datasets and filtering/merging data sets to get desired result.

Re: Procedures that support multilabel formats?

Davanden — Fri, 24 Jan 2020 18:41:49 GMT

Yes, I can do that. I was hoping to avoid that extra step.