topic Re: Using two Formats in One Variable in SAS Procedures

Using two Formats in One Variable

Mgarret — Tue, 25 Feb 2014 19:37:39 GMT

Hi all--

I have a data set which looks like this:

KPI	Control	Test
Response Rate	0.0037	0.0032
Conversion Rate	0.3401	0.3406
Yield	0.0012	0.0011
Online Response Rate	0.0015	0.0012
Total Response Rate	0.0051	0.0044
Total Yield	0.0014	0.0012
CPR	68.1	65.5
CPS	251.69	237.99

I have to have the CPR and CPS values formatted dollar10.2 and the rest of the KPIs formatted Percent10.2. So, the data set should look like this:

KPI	Control	Test
Response Rate	0.37%	0.32%
Conversion Rate	34.01%	34.06%
Yield	0.12%	0.11%
Online Response Rate	0.15%	0.12%
Total Response Rate	0.51%	0.44%
Total Yield	0.14%	0.12%
CPR	$68.10	$65.50
CPS	$251.69	$237.99

Is there a way to apply two formats to one variable?

Thanks!

Re: Using two Formats in One Variable

Reeza — Tue, 25 Feb 2014 19:51:45 GMT

You can nest the formats, if you can assume the percentages will be between 0-1 and all others will be higher.

proc format;

value mixed_fmt

0 -1 = [percent10.2]

1-high = [dollar10.2];

run;

data want;

set have;

format control test mixed_fmt.;

run;

Re: Using two Formats in One Variable

LinusH — Tue, 25 Feb 2014 20:03:46 GMT

This sounds like a reporting requirement, surely not a must for storage. If one is to store different kind of values in the same variable in permanent storage, I would have some helper variable specifying the nature of the measures.

Reezas suggestion will probably work for many situations, but results kind be weird if you have a $0 result, or want to introduce other kind of measures, like diff last month etc.

Perhaps you could accomplish this in the presentation layer instead?