Dyamic proc format

[saspgmr]

Has any body used dynamic proc format? I have used it long time back and trying to recollect it.It basically has key words like start ,label, fmtname etc.Could any body help me on this.

Thanks,
Zaheer

 

[klaz2002]

Sure I use it all the time. I wrote a macro to generate the format.
First you need a dataset that is set up for the 'cntlin' option on the Proc Format to be used. (This is what my macro does.)

%macro fmt_setup(fds_nm  = ,
                 out_nm  = ,
                 fm_name = ,
                 f_label = ,
                 f_type  = ,
                 f_value = );

   *** SET THE DATA SET FOR THE PROC FORMAT STEP   ***;
   data &out_nm(keep=label start type fmtname );
     set &fds_nm  end = last;
     length
       label   $40
       start   $40
       type    $4
       fmtname $10
       ;
   
       label   = "&f_label";
       start   = &f_value;
       type    = "&f_type";
       fmtname = "&fm_name";

   
       if last then do;
         output;
         label   = 'NO';
         start   = 'other';
         type    = "&f_type";
         fmtname = "&fm_name";
         output;
       end;
       else
        output;
   run;

   proc format 
     cntlin = &out_nm;
   run;

   quit; *** USED FOR FORMAT ERROR ***;
%mend fmt_setup;

Please note that this code is for numeric value substitution and not character formats. But you can figure out how to modify the code to suit your needs should you need this for character formats too.

Klaz

 

[saspgmr]

Thank you so much Klaz,
Its really helpful and wonderful.
You have been doing a great job for the Forum.

I appreciate your solutions.

Thanks,
Zaheer