| Date: | Thu, 15 Dec 2011 07:11:50 -0500 |
|---|
| Reply-To: | Tom Abernathy <tom.abernathy@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Tom Abernathy <tom.abernathy@GMAIL.COM> |
|---|
| Subject: | Re: unable to got variable name in excel |
|---|
What is the problem? I suspect that excel is doing the usual issue of
converting text that looks like math into numbers? Does you column header
look like a number, probably around 396 (365+31) ?
Try adding a style option to the PROC REPORT statement.
Something like
style(header)={tagattr='format:text'}
On Thu, 15 Dec 2011 03:31:12 -0500, SAS Analyst <analystprasad@YAHOO.CO.IN>
wrote:
>Hi,
>when i ran below code,i have unable to got variable name
>'10/10/2010-11/11/2011' in excel.pls do needful.
>
>ods tagsets.excelxp file='C:\Users\testexcel.xls'
>options(style_sheet='test'
>orientation='landscape');
>proc report data=sashelp.class nowd;
>column name age height weight;
>define name/'name';
>define age/'10/10/2010-11/11/2011';
>define height/'height';
>define weight/'weight';
>run;
>ods tagsets.excelxp close;
>
>Regards,
>Prasad
| 
