topic Formatting Help in SAS Programming

Formatting Help

buechler66 — Fri, 08 Apr 2016 15:08:56 GMT

Hi. In my proc print can I rename the column headers?

N = 'Count'

Rule_Order = 'Rule'

ad_dt_char = 'AD Date'

And for the Rule_Order column is there any way to format the values so that whole number don't have the .0 attached?

                                              The SAS System                          08:52 Friday, April 8, 2016 132

                                                      RULE_
                                               Obs    ORDER      N    ad_dt_char

                                                 1     1.0      80    TOTAL
                                                 2     1.0       5    03/14/2016
                                                 3     1.0       3    03/15/2016
                                                 4     1.0      14    03/16/2016
                                                 5     1.0      13    03/17/2016
                                                 6     1.0      20    03/18/2016
                                                 7     1.0      19    03/19/2016
                                                 8     1.0       4    03/22/2016
                                                 9     1.0       2    03/25/2016
                                                10     1.5     202    TOTAL
                                                11     1.5       1    03/15/2016
                                                12     1.5       1    03/17/2016
                                                13     1.5       2    03/18/2016
                                                14     1.5       6    03/19/2016
                                                15     1.5      12    03/21/2016
                                                16     1.5       4    03/22/2016

Re: Formatting Help

FreelanceReinh — Fri, 08 Apr 2016 15:18:57 GMT

Hi @buechler66,

Try this:

proc print data=yourdata label;
label N = 'Count'
      Rule_Order = 'Rule'
      ad_dt_char = 'AD Date';
format Rule_Order best6.; /* please adapt length 6 as appropriate */
run;

Re: Formatting Help

buechler66 — Fri, 08 Apr 2016 15:24:24 GMT

Awesome help. Ty.

Re: Formatting Help

FreelanceReinh — Fri, 08 Apr 2016 15:25:47 GMT

You're welcome.

Please note that the suggested code assigns the labels and format only temporarily to the respective variables, only for the duration of the PROC PRINT step. Alternatively, you can add the same LABEL and FORMAT statements to a data step creating the input dataset for PROC PRINT ("yourdata") in order to assign the labels and format permanently. Then you don't need these statements in future PROC PRINT steps, only the LABEL option in the PROC PRINT statement (first line of code).