Date:         Mon, 29 Jul 2002 10:57:00 +0400
Reply-To:     jassimrahma@HSBC.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jassim Rahma <jassimrahma@HSBC.COM>
Subject:      Memo:  Re: Date Field
Content-type: text/plain; charset="us-ascii"

I'm going crazy with Microsoft Query criteria because of this problem....


-------- Forwarded by Jassim RAHMA on 07/29/2002 --------

29Jul2002
Memo



To:   SAS-L@LISTSERV.UGA.EDU
cc:   karlstudboy@HOTMAIL.COm
bcc:

From:        Jassim RAHMA     Tel:

 Our Ref:               Your Ref:



Subject:  Re: Date Field


Karl,

this worked fine but when I export the dataset to Excel worksheet it
consider it as a general format. I need to have it as a date format.


Many Thanks,
Jassim Rahma


-------- Forwarded by Jassim RAHMA on 07/29/2002 --------


"Karl K." <karlstudboy@HOTMAIL.COM>@LISTSERV.UGA.EDU> on 28 Jul2002
Please respond to "Karl K." <karlstudboy@HOTMAIL.COM>
Sent by:  "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>

To:   SAS-L@LISTSERV.UGA.EDU
cc:
bcc:

From:        "Karl K." <karlstudboy@HOTMAIL.COM>@LISTSERV.UGA.EDU>     Tel:

 Our Ref:               Your Ref:



Subject:  Re: Date Field


******************************************************************
 This message originated from the Internet. Its originator may or
 may not be who they claim to be and the information contained in
 the message and any attachments may or may not be accurate.
******************************************************************

Is "000605" June 5, 2000?  Your message wasn't clear on that.  If so, your
own parentheses tell you what to do: input it with the yymmdd. format.

Ah, I actually thought for a sec before hitting "send".  Since it's
numeric,
you probably have to code it as:

   yourdate = input(put(yourfield,z6.),yymmdd6.);

I didn't test this, but you get the idea.

"Jassim Rahma" <jassimrahma@HSBC.COM> wrote in message
news:OF7EB3C78E.8545BA09-ON44256C03.002A7B06@systems.uk.hsbc...
> I have an AS400 numeric field contains the date but I need to have it as
a
> proper date (yymmdd).
>
> Examples of dates after importing from AS400 to SAS dataset :
>
> 000605 will be 605 (zeros will be trimmed)
> 010727 will be 10727
> 981105 will be 981105
>
> Can anyone help please?
>
>
>
> ** HSBC's website is at www.hsbc.com **
>
> ********************************************************************
>  This message and any attachments are confidential to the ordinary
>  user of the e-mail address to which it was addressed and may also
>  be privileged. If you are not the addressee you may not copy,
>  forward, disclose or use any part of the message or its
>  attachments and if you have received this message in error, please
>  notify the sender immediately by return e-mail and delete it from
>  your system.
>
>  Internet communications cannot be guaranteed to be secure or
>  error-free as information could be intercepted, corrupted, lost,
>  arrive late or contain viruses. The sender therefore does not
>  accept liability for any errors or omissions in the context of
>  this message which arise as a result of Internet transmission.
>
>  Any opinions contained in this message are those of the author and
>  are not given or endorsed by the HSBC Group company or office
>  through which this message is sent unless otherwise clearly
>  indicated in this message and the authority of the author to so
>  bind the HSBC entity referred to is duly verified.
>
> ********************************************************************






** HSBC's website is at www.hsbc.com **

********************************************************************
 This message and any attachments are confidential to the ordinary
 user of the e-mail address to which it was addressed and may also
 be privileged. If you are not the addressee you may not copy,
 forward, disclose or use any part of the message or its
 attachments and if you have received this message in error, please
 notify the sender immediately by return e-mail and delete it from
 your system.

 Internet communications cannot be guaranteed to be secure or
 error-free as information could be intercepted, corrupted, lost,
 arrive late or contain viruses. The sender therefore does not
 accept liability for any errors or omissions in the context of
 this message which arise as a result of Internet transmission.

 Any opinions contained in this message are those of the author and
 are not given or endorsed by the HSBC Group company or office
 through which this message is sent unless otherwise clearly
 indicated in this message and the authority of the author to so
 bind the HSBC entity referred to is duly verified.

********************************************************************