DATA Step, Macro, Functions and more

Formatting Help

Accepted Solution Solved
Reply
Regular Contributor
Posts: 212
Accepted Solution

Formatting Help

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

 


Accepted Solutions
Solution
‎04-08-2016 11:24 AM
Trusted Advisor
Posts: 1,115

Re: Formatting Help

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;

View solution in original post


All Replies
Solution
‎04-08-2016 11:24 AM
Trusted Advisor
Posts: 1,115

Re: Formatting Help

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;
Regular Contributor
Posts: 212

Re: Formatting Help

Awesome help. Ty.
Trusted Advisor
Posts: 1,115

Re: Formatting Help

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).

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 177 views
  • 0 likes
  • 2 in conversation