Date:         Tue, 3 Feb 2009 10:56:48 -0600
Reply-To:     Mary <mlhoward@avalon.net>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: Data Format
Comments: To: ali6058@GMAIL.COM
Content-Type: text/plain; charset="iso-8859-1"

It works correctly with tagsets as well.

data test;
informat id $10.;
infile cards missover;
input id;
cards;
10-63
100
101
102
103
;
run;


ods listing close;
ods tagsets.excelxp file="c:\temp\test.xml"
style=analysis
options(absolute_column_width='10'
sheet_label=' ');

ods tagsets.excelxp options(sheet_name="2009_01_29");
title 'test';
proc print data=test;
run;
ods tagsets.excelxp close;
ods listing;

-Mary
  ----- Original Message ----- 
  From: Arthur Tabachneck 
  To: SAS-L@LISTSERV.UGA.EDU 
  Sent: Tuesday, February 03, 2009 10:41 AM
  Subject: Re: Data Format


  Al,

  What code or method are you using to get the data into Excel?

  When I run the following it appears to export as desired:

  data have;
    input X $;
    cards;
  1
  2
  4
  56
  1-2
  2-6
  ;

  PROC EXPORT DATA= WORK.have
              OUTFILE= "c:\want.xls"
              DBMS=EXCEL2000 REPLACE;
  RUN;

  Art
  --------
  On Tue, 3 Feb 2009 07:36:26 -0800, Al <ali6058@GMAIL.COM> wrote:

  >   Hi :
  >i am trying to import a SAS dataset in to exceel spread sheet .. one
  >of the variable X has data values
  >
  >X
  >
  >1
  >2
  >4
  >56
  >1-2
  >2-6
  >
  >when i import it into spread sheet the values in the spread sheet are
  >showing up as
  >x
  >1
  >2
  >4
  >56
  >2-Jan
  >6-Feb
  >
  >any suggestions please
  >
  >Thanks in advance..