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