topic Re: question about reporting formatted andf unformatted values in same report in ODS and Base Reporting

question about reporting formatted andf unformatted values in same report

frisco — Wed, 29 Jul 2009 12:56:18 GMT

Hi, I have a reporting requirement to print BOTH the formatted and unformatted values side by side in a report.

For example:

Gender FEMALE 2

Is there a straightforward way to accomplish this? TIA.

Re: question about reporting formatted andf unformatted values in same report

sbb — Wed, 29 Jul 2009 13:10:14 GMT

The answer will depend on how you expect to generate the report, that being with PROC PRINT, PROC REPORT, PROC SQL (or another procedure) or a DATA step?

Scott Barry
SBBWorks, Inc.

Re: question about reporting formatted andf unformatted values in same report

frisco — Wed, 29 Jul 2009 13:29:58 GMT

Most likely REPORT or PRINT.

Re: question about reporting formatted andf unformatted values in same report

Cynthia_sas — Wed, 29 Jul 2009 14:45:08 GMT

Hi:
PROC REPORT would probably be your best bet. You can use a variable to create a second report item with an "alias" for referencing on the report:
[pre]
column name gender gender=ugend age;
[/pre]

and then in your DEFINE statements, you can have:
[pre]
define gender / display f=gfmt. 'Formatted value';
define ugend / display 'Unformatted';
[/pre]

This is a neat feature of PROC REPORT because the format is applied on the DEFINE statement instead of in a FORMAT statement. In this example, the variable GENDER is used once on the report with a format and then the alias, UGEND, is GENDER used a second time on the report, but WITHOUT a format.

cynthia