topic Re: SAS Prompt display formatted value on report in ODS and Base Reporting

SAS Prompt display formatted value on report

metallon — Mon, 27 Jul 2015 14:04:57 GMT

Hi SAS Experts,

Is there a way to display the formatted value of my prompt macro variable on the report?

I got a unformatted value of 12 and a formatted value of "December" I dont want that the user sees "12" but "December".

If I use the following I only get the 12 displayed.

proc report data=crazydata;

TITLE JUSTIFY=L &Prompt_Year ;

...

Re: SAS Prompt display formatted value on report

RW9 — Mon, 27 Jul 2015 14:19:26 GMT

At a guess:

title justify=l "%sysfunc(put(&prompt_year.,your_format.))";

Although why have a macro variable called year which has a month?

Re: SAS Prompt display formatted value on report

metallon — Tue, 28 Jul 2015 07:17:10 GMT

Hi,

Thanks for the reply. I dont really have a specific format. I just want that the formatted value is shown.

"Although why have a macro variable called year which has a month?" -> because the year has 12 months

Re: SAS Prompt display formatted value on report

RW9 — Tue, 28 Jul 2015 07:52:27 GMT

Yes, but the first question I would ask is which year then? Anyways, your choice. Good Programming Practice would indicate that giving variable names clearly identifiable names helps programming and maintaining.

As for format, you can use monname.:

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

Re: SAS Prompt display formatted value on report

metallon — Tue, 28 Jul 2015 14:42:45 GMT

OK. I think my example of picking a date/year/month prompt does not really hit the mark.

Let me draw a different picture. If I have a prompt like the following:

formatted value / unformatted value

big car______________01

small car____________002

medium car__________300

fat car_______________04

How do I now get the formatted value in my title?

proc report data=crazydata;

TITLE JUSTIFY=L &Prompt_bigCar ;

Does not work.

Re: SAS Prompt display formatted value on report

RW9 — Tue, 28 Jul 2015 15:06:25 GMT

Sorry, what software are we using here when we talk about "prompt"? What is contained in the macro variable &Prompt_bigCar. If it is just the number 1 or text 01, then you should have a format somewhere that is used to reference it. E.g.

%let Prompt_bigCar=01;

proc format;

value car $

'01'='big car';

run;

title "%sysfunc(put(&Prompt_bigCar.,$car.))";

Re: SAS Prompt display formatted value on report

metallon — Wed, 29 Jul 2015 10:57:39 GMT

Hi RW9,

I am using Enterprise Guide 6.1.

I was afraid that I had to build a second mapping table in the code to map formatted to unformatted values again to just put the prompt formatted value on the report title....that is really lame.

the prompt is defined in EG like this:

formatted value / unformatted value

big car______________01

small car____________002

medium car__________300

fat car_______________04

Re: SAS Prompt display formatted value on report

RW9 — Wed, 29 Jul 2015 11:49:36 GMT

I will let others comment on the functionality of EG, haven't used it for many years. Might help if you post the topic under the specific EG forum.