I happen to agree with Howard. I have seen 3 questions from the same
person, about the same program....all have been BASIC SAS problems...
If you get
NOTE: Invalid numeric data, '14AUG97' , at line 528
then goto that line and SEE what is different about that data from the
other lines around it.
If you get
WARNING: The current word or quoted string has become more than 200
characters long. You may have unbalanced quotation marks.
NOTE: A double quote (") will terminate this quoted string.
then start at that location and GO UP until you find the unbalanced
If you get:
384 if (crn="A535959") then (crn="A535252")
ERROR 180-322: Statement is not valid or it is used out
of proper order.
It is pointing to the ( ...what else do you expect?
These are things that should be learned in SAS 101. I find it
disturbing that people who claim to be SAS programmers use this and
other SAS newgroups and lists to get through basic SAS programs. If
they did not have access to this group....they would never complete a
Take time to look at your work and your log files prior to posting. You
may surprise yourself in debugging your work yourself.
Well that is more than my 2 cents worth....
It takes time to be a success, but time is all it takes. - Anonymous
It is not enough to get things done; they must be done right. -Arthur T.
> -----Original Message-----
> From: Howard Schreier [SMTP:Howard_Schreier@ITA.DOC.GOV]
> Sent: Tuesday, October 26, 1999 1:09 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: invalid data and some problems
> Indeed the lack of the "d" in the intended date constant is
> the problem.
> It seems to me that somebody with no knowledge of SAS
> who took the time to read the NOTE and inspect the code
> might have guessed that.
> When I'm working with someone as a debug coach/consultant,
> I won't just give away an answer like this. I'll just keep
> answering questions with questions until the truth emerges.
> > You forgot the 'd' in line 528
> > > I am trying to edit some date-variables but SAS
> > > produces a Note whioi I am not sure what exactly measn
> > > and how i would remedy it. So, i am wondering if i
> > > would have your assistance on this matter, please.
> > >
> > > thank you ever so much for your help. Look forward to
> > > hearing from you.
> > >
> > >
> > > 526 if ce_disch='26JAN97'd then ce_disch='26FEB97'd ;
> > > 527
> > > 528 if ce_admit='14AUG97' then ce_admit='04AUG97'd ;
> > > 529
> > > 530 if ce_disch='14MAR97'd then ce_disch='14AUG97'd ;
> > > 531
> > > 532 if ce_admit='15OCT96'd then ce_admit='15NOV96'd ;
> > > 533
> > > 534 if ce_admit='09JUN97'd then ce_admit='01JUN97'd ;
> > > 535
> > >
> > > NOTE: Character values have been converted to numeric
> > > values at the places given by: (Line):(Column).
> > > 528:15
> > > NOTE: Invalid numeric data, '14AUG97' , at line 528
> > > column 15.
Sent via Deja.com http://www.deja.com/
Before you buy.