The SAS Output Delivery System and reporting techniques

Format Library

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 126
Accepted Solution

Format Library


I have the following formats in a format library:

value $Credit_Grp

     '1' = '0-15'

     '2' = '16-30'

     '3' = '31+';


value $Credit_Grp2

     '1' = '0-15 Credit Hours'

     '2' = '16-30 Credit Hours'

     '3' = '31+ Credit Hours';

When I run the tabulate code below using the $Credit_Grp format it works as advertised. But when I use the $Credit_Grp2 format it only displays the first two characters (ie "0-", "16", "31") for each value. What am I doing wrong? Thanks.

tabulate data = AnnFiveYearCombined2;

     class ay2 acadplan Credit_Grp;

     var FTES;

     format acadplan $acadplandeg.;

     format Credit_Grp $Credit_Grp.;

     table Credit_Grp='Credit Hours' all='Total'*f=comma6., ay2=''*(N='HC' FTES='FTES'*sum=''*f=comma6.);

run;


Accepted Solutions
Solution
‎12-16-2013 04:59 PM
SAS Super FREQ
Posts: 708

Re: Format Library

Hi

Format names are not allowed to end in a number since this number is taken as the length of the formatted value call your format $Credit_Grp2X and it should work

View solution in original post


All Replies
Solution
‎12-16-2013 04:59 PM
SAS Super FREQ
Posts: 708

Re: Format Library

Hi

Format names are not allowed to end in a number since this number is taken as the length of the formatted value call your format $Credit_Grp2X and it should work

Frequent Contributor
Posts: 126

Re: Format Library

Posted in reply to Bruno_SAS

Thanks Bruno. I'm a newbie when it comes to format libraries.

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 414 views
  • 0 likes
  • 2 in conversation