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 (June 2006, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 20 Jun 2006 08:09:40 -0400
Reply-To:     Ankur Arora <ankur.arora@NAGARRO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ankur Arora <ankur.arora@NAGARRO.COM>
Subject:      sas date time problem

Hi,

I have a question of data in which we are importing the data with proc imports.Now in one of the variables i have is 2005-03-09T01:54:25 which gets truncated to 2005-03-09.Can anybody help on this since i want to use proc import for importing the dataset with time formatted in the above format.

can it be done such that all the variables are changed to character format without using the names of variables.

this is the sample data tab separated data

STUDYID USUBJID DOMAIN BWSEQ BWGRPID BWTESTCD BWTEST BWORRES BWORRESU BWSTRESC BWSTRESN BWSTRESU BWBLFL BWSTDTC BWENDTC BWSTAT BWREASND DP1111 13 BW 34 BW Body Weight 266.4 g 266.4 266.4 g Y 2005-03-09T01:54:25

now the variables name changes with changes in the dataset the next data set will have "ss" instead of "bw".so what statement should i use in proc import so as to get the correct value of 2005-03-09T01:54:25.

can anybody help on the meathod to solve this

Thanks Ankur


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