Date:         Fri, 15 Apr 2005 10:06:01 -0700
Reply-To:     "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Subject:      Re: dates and timestamps in CSV export
Comments: To: Roel Oomen <roel.oomen@WBS.AC.UK>

Roel -

You neglect to state how your variables are stored in your dataset - are
they SAS dates, times, datetimes, or character strings?

Paul Choate
DDS Data Extraction
(916) 654-2160

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Roel
Oomen
Sent: Friday, April 15, 2005 4:40 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: dates and timestamps in CSV export

Hi folks,
I have a dataset which looks as follows:

02JAN1997     9:35:33     154.000
02JAN1997     9:35:40     154.000
02JAN1997     9:36:39     154.125
02JAN1997     9:36:39     154.125
02JAN1997     9:37:33     154.250

and I would like to export it to a csv file with the dates and times
formatted as follows:

Date          Time
19970102      093533
etc...

So YYYYMMDD and HHMMSS without any symbols in between.

Any help very welcome.
Thanks in advance,
Roel