Date: Fri, 12 Oct 2001 08:22:54 -0400
Reply-To: PBourdages@IAG.QC.CA
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: PBourdages@IAG.QC.CA
Subject: Re: Problem with PROC EXPORT to Excel 2000
Content-Type: multipart/alternative;
I ran the code over and over and over..... Always the same problem. I'm
running 8.2 with a few HotFix on a French Windows 2000 Professionnal Service
Pack 2.
I'm wondering if it is a problem with one or more parameters in the Regional
parameters in Windows 2000 that could cause the problem. I don't know the
inner of the proc export background code, but if it requires something
special of specific, then it might me the case... SI is looking into the
problem as well...
Temporarely, I'm exporting to either CSV or Delimited format, but I believe
that this should work Period....
Talk to you soon and a very nice day in China...!
Sincerely yours,
Patrice Bourdages
Information Systems Analyst
Industrielle Alliance, home and car insurance
Acturial Services
(418) 650-4600 ext.3216
-----Message d'origine-----
De : momo [mailto:momozeus@YAHOO.COM.CN]
Envoyé : 12 octobre, 2001 07:45
À : SAS-L@LISTSERV.UGA.EDU
Objet : Re: Problem with PROC EXPORT to Excel 2000
This is a multi-part message in MIME format.
------=_NextPart_000_0025_01C15356.5BBD4CB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Problem with PROC EXPORT to Excel 2000maybe you can check again,your =
program seems right while i run;
a b c d=20
1 1 1=20
2 1 1=20
3 2 1 1=20
4 4 =20
5 5=20
my sas version is 8.1 on win2000 profession.
<PBourdages@IAG.QC.CA> wrote in message =
news:5C57B5DD382CD5118E8F000629F639BE04493C49@smtp.que.inalco.com...
Consider the following code:=20
data x;=20
a =3D 1; b =3D 1; c =3D .; d =3D 1; output;=20
a =3D 2; b =3D .; c =3D 1; d =3D 1; output;=20
a =3D 3; b =3D 2; c =3D 1; d =3D 1; output;=20
a =3D .; b =3D 4; c =3D 4; d =3D .; output;=20
a =3D 5; b =3D .; c =3D .; d =3D 5; output;=20
run;=20
proc export data =3D work.x=20
outfile =3D "s:\test1.xls"=20
dbms =3D excel2000 replace;=20
run;=20
And the following results in Excel2000:=20
a b c d=20
1 1 1 =20
2 1 1=20
3 2 1 1=20
4 4 =20
5 5=20
Why is it that the first obs with the missing value in var C ends up =
with the value of 1 in Excel ?????=20
Is this a know bug with a fix that I didn't found or recognize?=20
TIA :-)=20
Patrice Bourdages=20
Information Systems Analyst=20
Industrielle Alliance, home and car insurance=20
Acturial Services=20
(418) 650-4600 ext.3216=20
=20
------=_NextPart_000_0025_01C15356.5BBD4CB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Problem with PROC EXPORT to Excel 2000</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3D宋体 size=3D2>maybe you can check =
again,your program seems right=20
while i run;</FONT></DIV>
<DIV> </DIV><FONT face=3D宋体 size=3D2>
<TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0=20
style=3D"BORDER-COLLAPSE: collapse; WIDTH: 192pt" width=3D256 x:str>
<COLGROUP>
<COL span=3D4 style=3D"WIDTH: 48pt" width=3D64>
<TBODY>
<TR height=3D16 style=3D"HEIGHT: 12pt">
<TD height=3D16 style=3D"HEIGHT: 12pt; WIDTH: 48pt" width=3D64 =
x:str=3D"'a"><FONT=20
face=3D宋体 =
size=3D2> </FONT><A=20
name=3DRANGE!A1:D6>a</A><FONT face=3D宋体 =
size=3D2> </FONT></TD>
<TD style=3D"WIDTH: 48pt" width=3D64=20
=
x:str=3D"'b"> =
=20
b </TD>
<TD style=3D"WIDTH: 48pt" width=3D64=20
=
x:str=3D"'c"> =
=20
c</TD>
<TD style=3D"WIDTH: 48pt" width=3D64=20
=
x:str=3D"'d"> =
=20
d</TD></TR>
<TR height=3D16 style=3D"HEIGHT: 12pt">
<TD align=3Dright height=3D16 style=3D"HEIGHT: 12pt" x:num>1</TD>
<TD align=3Dright x:num>1</TD>
<TD></TD>
<TD align=3Dright x:num>1</TD></TR>
<TR height=3D16 style=3D"HEIGHT: 12pt">
<TD align=3Dright height=3D16 style=3D"HEIGHT: 12pt" x:num>2</TD>
<TD></TD>
<TD align=3Dright x:num>1</TD>
<TD align=3Dright x:num>1</TD></TR>
<TR height=3D16 style=3D"HEIGHT: 12pt">
<TD align=3Dright height=3D16 style=3D"HEIGHT: 12pt" x:num>3</TD>
<TD align=3Dright x:num>2</TD>
<TD align=3Dright x:num>1</TD>
<TD align=3Dright x:num>1</TD></TR>
<TR height=3D16 style=3D"HEIGHT: 12pt">
<TD height=3D16 style=3D"HEIGHT: 12pt"></TD>
<TD align=3Dright x:num>4</TD>
<TD align=3Dright x:num>4</TD>
<TD></TD></TR>
<TR height=3D16 style=3D"HEIGHT: 12pt">
<TD align=3Dright height=3D16 style=3D"HEIGHT: 12pt" x:num>5</TD>
<TD></TD>
<TD></TD>
<TD align=3Dright x:num>5</TD></TR></TBODY></TABLE>
<DIV> </DIV>
<DIV>my sas version is 8.1 on win2000 profession.</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV><<A=20
href=3D"mailto:PBourdages@IA =
a =
b =
c =
d11121132114455G.QC.CA">PBourdages@IAG.QC.CA</A>>=20
wrote in message <A=20
=
href=3D"news:5C57B5DD382CD5118E8F000629F639BE04493C49@smtp.que.inalco.com=
">news:5C57B5DD382CD5118E8F000629F639BE04493C49@smtp.que.inalco.com</A>..=
.</DIV>
<P><FONT size=3D2>Consider the following code:</FONT> </P>
<P><FONT size=3D2>data x;</FONT> <BR><FONT size=3D2> =
a =3D=20
1; b =3D 1; c =3D .; d =3D 1; output;</FONT> =
<BR><FONT=20
size=3D2> a =3D 2; b =3D .; c =3D =
1; d =3D 1;=20
output;</FONT> <BR><FONT size=3D2> a =3D 3; b =
=3D 2; c=20
=3D 1; d =3D 1; output;</FONT> <BR><FONT =
size=3D2> a =3D=20
.; b =3D 4; c =3D 4; d =3D .; output;</FONT> =
<BR><FONT=20
size=3D2> a =3D 5; b =3D .; c =3D =
.; d =3D 5;=20
output;</FONT> <BR><FONT size=3D2>run;</FONT> </P>
<P><FONT size=3D2>proc export data =3D work.x =
</FONT><BR><FONT=20
=
size=3D2> &nbs=
p;=20
outfile =3D "s:\test1.xls" </FONT><BR><FONT=20
=
size=3D2> &nbs=
p;=20
dbms =3D excel2000 replace;</FONT> <BR><FONT=20
size=3D2>run;</FONT> </P>
<P><FONT size=3D2>And the following results in Excel2000:</FONT> </P>
<P><FONT size=3D2>a =20
b =
c =20
d</FONT> <BR><FONT size=3D2>1 =20
1 =
1 =20
</FONT><BR><FONT size=3D2>2 =20
=20
1 1</FONT> <BR><FONT=20
size=3D2>3 =20
2 =
1 =20
1</FONT> <BR> <FONT=20
size=3D2>4 =20
4 </FONT><BR><FONT=20
size=3D2>5 =20
=20
5</FONT> </P>
<P><FONT size=3D2>Why is it that the first obs with the missing value =
in var C=20
ends up with the value of 1 in Excel ?????</FONT> </P>
<P><FONT size=3D2>Is this a know bug with a fix that I didn't found or =
recognize?</FONT> </P>
<P><FONT size=3D2>TIA :-)</FONT> </P>
<P><FONT size=3D2>Patrice Bourdages</FONT> <BR><FONT =
size=3D2>Information Systems=20
Analyst</FONT> <BR><FONT size=3D2>Industrielle Alliance, home and car=20
insurance</FONT> <BR><FONT size=3D2>Acturial Services</FONT> <BR><FONT =
size=3D2>(418) 650-4600 ext.3216</FONT> <BR><FONT =
size=3D2> </FONT>=20
</P></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0025_01C15356.5BBD4CB0--
[text/html]
