Date:         Fri, 10 Sep 2010 13:54:55 -0700
Reply-To:     mlhoward@avalon.net
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Proc Report out= question
Content-Type: text/plain; charset="UTF-8"

Hi- I'm trying to use Proc Report to generate statistics, since sometimes we have many columns and yet need to merge to other things- the report comes out just the way I want, but then when I save the output data set, I don't get the variable names that I was expecting- just _c1_, _c2_, and so forth.   Is there any way to get the variable names of the statistics?  I've had success using the label as the new variable name in the past, but it is not working in this case.

-Mary

data test;
infile cards missover;
informat brand_nm $40.;
input brand_nm 1-8 _200907 9-12 _200908 13-16;
CARDS;
COLGATE 345 444
CREST   333 235
;
run;

proc report data=test nowd out=test2 headline;
title;
column
brand_nm
_200907,(sum=_200907_n pctsum=_200907_pct)
_200908,(sum=_200908_n pctsum=_200908_pct);
define brand_nm / group ;
define _200907 /'';
define _200907_n/ '_200907_n';
define _200907_pct / '_200907_pct' format=7.3 width=8;
define _200908 / '';
define _200908_n/ '_200908_n';
define _200908_pct / '_200908_pct' format=7.3 width=8;
run;