| Date: | Mon, 6 Mar 2006 14:02:56 -0600 |
|---|
| Reply-To: | Yu Zhang <zhangyu05@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Yu Zhang <zhangyu05@GMAIL.COM> |
|---|
| Subject: | Re: date in SAS to date in EXCEL |
|---|
|
| In-Reply-To: | <05ea01c64152$473de440$1d9e5f86@simurechner> |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
Stefan,
Sorry, After I did my homework, We do have Eurdfddw. format. Please discard
the previous post, here is the the full code to answer your question.
options dflang=spanish;
data test;date1=put('04APR96'd,EURDFDD8.);
put date1=;
run;
proc export data=test
outfile='c:\test.xls'
dbms=excel
replace;
run;
On 3/6/06, Stefan Pohl <stefan.pohl@wiso.uni-koeln.de> wrote:
>
> Hi,
>
> I want to export from SAS to excel a date, for example 04.04.96 (format
> eurdfdd8. in SAS) to 04.04.96 in EXCEL.
>
> How can I do this,
>
> thank you
>
> Stefan
>
|
