Date: Mon, 29 Aug 2005 15:17:38 -0400
Reply-To: Arthur Tabachneck <art297@NETSCAPE.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Arthur Tabachneck <art297@NETSCAPE.NET>
Subject: Re: Convert Infile Date to SAS Date
Carol,
Your problem might simply be that you begin with initializing CRDATE, but
you didn't end the statement with a semicolon.
Art
-------
On Mon, 29 Aug 2005 13:57:55 -0400, Srna, Carol (C.) <csrna@FORD.COM>
wrote:
>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.
|