Date:         Mon, 29 Aug 2005 13:57:55 -0400
Reply-To:     "Srna, Carol (C.)" <csrna@FORD.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Srna, Carol (C.)" <csrna@FORD.COM>
Subject:      Re: Convert Infile Date to SAS Date
Comments: To: Nathaniel_Wooding@dom.com
Content-Type: text/plain; charset="us-ascii"

I'm sorry.  I did get rid of the 'slash'. The error is:   NOTE: Invalid
argument to function INPUT at line 21 column 14.
 CRDATE=.


     CRDATE = INPUT(COMPRESS(CDATE,'/'),JULIAN7.);
 PUT CRDATE=;


-----Original Message-----
From: Nathaniel_Wooding@dom.com [mailto:Nathaniel_Wooding@dom.com]
Sent: Monday, August 29, 2005 1:21 PM
To: Srna, Carol (C.)
Cc: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Convert Infile Date to SAS Date


Carol

You julian date needs to have the '/' removed before SAS can work with
it
-- unless there is a new informat that I have not found. Try

data a;
input jdate $ 1-8;
cdate=input(compress(jdate,'/'),julian7.);
cards;
2004/237
proc print;format cdate mmddyy10.;
run;


Nat Wooding




                      "Srna, Carol

                      (C.)"                    To:
SAS-L@LISTSERV.UGA.EDU

                      <csrna@FORD.COM>         cc:

                      Sent by: "SAS(r)         Subject:  Convert Infile
Date to SAS Date
                      Discussion"

                      <SAS-L@LISTSERV.U

                      GA.EDU>





                      08/29/05 11:00 AM

                      Please respond to

                      "Srna, Carol

                      (C.)"










The Input file:
 CDATE
+----0----+

CC 96 - 103


 2004/237  This is how the date is in the input file

I input the date as CDATE DATE8. in my SAS file;

SAS tells me this is invalid data for the var. CDATE.
What am I missing here?
Thanks In Advance




-----------------------------------------
CONFIDENTIALITY NOTICE:  This electronic message contains information
which may be legally confidential and/or privileged and does not in any
case represent a firm ENERGY COMMODITY bid or offer relating thereto
which binds the sender without an additional express written
confirmation to that effect.  The information is intended solely for the
individual or entity named above and access by anyone else is
unauthorized.  If you are not the intended recipient, any disclosure,
copying, distribution, or use of the contents of this information is
prohibited and may be unlawful.  If you have received this electronic
transmission in error, please reply immediately to the sender that you
have received the message in error, and delete it.  Thank you.