Date:         Tue, 20 Jun 2006 12:45:23 -0400
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: sas date time problem

On Tue, 20 Jun 2006 08:09:40 -0400, Ankur Arora <ankur.arora@NAGARRO.COM> wrote:

>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.

PROC IMPORT is fine for consistently structured data which follow the rules.
 Your data-time values do not conform to the SAS datetime informat, which
would represent the sample value as

   09mar2005 01:54:25

A DATA step can probably do a better job.

Do you receive any kind of dictionary (metadata) with these files? Is there
 a naming convention? Is the date-time always in the same field position?

>
>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