Date: Wed, 28 Mar 2012 15:32:22 -0400
Reply-To: Ross Clark <rosscharlesclark@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Ross Clark <rosscharlesclark@GMAIL.COM>
Subject: PL/SQL to SAS Date Conversion
Greetings SAS-Lers!
I would like to ask for help on an issue involving Dates in PL/SQL.
Right now I extract data from a PeopleSoft database nightly and store it in
a Csv file which I later upload into SAS.
The date column I import looks like this:
"03/21/2012 9:12:48PM"
"03/22/2012 9:15:48PM"
"03/23/2012 10:12:48AM"
...
I would like to eventually obtain a SAS date-time value with which I could
use to rank-order the Cases within each subject.
I have tried playing with PeopleSoft's default settings for outputting the
date in this form, to little avail.
Please help.
Ross Clark