Date:         Tue, 6 Jun 2000 15:20:29 +0200
Reply-To:     robert.nemeth@FOCUS-CDD.DE
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Robert Nemeth <robert.nemeth@FOCUS-CDD.DE>
Subject:      Re: datetime21. to date7.
Comments: To: Deepak.Mathur@ORANGE.CO.IN
Content-type: text/plain; charset=us-ascii

Hi Deepak,

try

select id,input(put(datepart(join_date),date7.),date7.) as join_date

it should work

put does not specify the format of the new variable and I think by default
it will be set to character

Regards
Robert

--------------------------------------------------
Focus Clinical Drug Development GmbH, Neuss