LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2012, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page