Format Library

BTAinRVA — Mon, 16 Dec 2013 21:47:11 GMT

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;

Re: Format Library

BrunoMueller — Mon, 16 Dec 2013 21:59:36 GMT

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

Re: Format Library

BTAinRVA — Mon, 16 Dec 2013 22:27:40 GMT

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

topic Format Library in ODS and Base Reporting

Format Library

Re: Format Library

Re: Format Library