topic Proc Format / Tabulate Multiple formats question in SAS Programming

Proc Format / Tabulate Multiple formats question

dsbihill — Thu, 15 May 2014 14:10:03 GMT

I have working format and proc tabulate outputting the information i want. I would like to add trafic lighting to this. Is there a way that i can add Red and Green formatting to the below proc format statement? I need to maintain the number formats and have the trafic lighting affect. I have seen many options to do either of these alone, but how can i get both formats.

Thank you all very much.

proc format;

picture thousands (round)

0-High = '000,000,009 K' (mult=.001 prefix='$')

LOW-0 = '000,000,009) K' (mult=.001 prefix='($');

Run;

proc tabulate data=temp_YTD_Cost_V

out=test;

var costv;

class customer gd apg1 usage_type;

table gd* apg1,

customer='' * (usage_type='' all) * costv=''*f=thousands. * sum='';

run;

Re: Proc Format / Tabulate Multiple formats question

ballardw — Thu, 15 May 2014 16:20:14 GMT

I'm too lazy to build much of a data set without actual examples but this should get you started:

proc format library=work;

picture thousands (round)

0-High = '000,000,009 K' (mult=.001 prefix='$')

LOW-0 = '000,000,009) K' (mult=.001 prefix='($');

value traffic

0-High = 'Green'

LOW-0 = 'Red';

Run;

data temp_YTD_Cost_V;

input customer $ costv;

datalines;

A 10000000

A 3000000

B -500000

;

run;

proc tabulate data=temp_YTD_Cost_V

;

var costv;

class customer ;

table customer,

costv*{style=[backgroundcolor=traffic. ]}* sum=''*f=thousands. ;

run;

Re: Proc Format / Tabulate Multiple formats question

dsbihill — Thu, 15 May 2014 16:38:06 GMT

Works great, thank you so much for the help