cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
EpiLinds
‎09-01-2015
  • 12 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Invalid numeric data

by Calcite | Level 5 in SAS Procedures
‎06-09-2012 06:26 PM
‎06-09-2012 06:26 PM
Hi everyone, Although I was not able to get rid of the error notes by trying the suggestions above, I got the same number of observations however I ran it so I am just going to ignore the notes and proceed. Thanks so much for your help! Linds ... View more

Re: Invalid numeric data

by Calcite | Level 5 in SAS Procedures
‎06-08-2012 07:08 PM
‎06-08-2012 07:08 PM
Hi Linlin, Thanks for the feedback.  I tried running this code and got a number of different error messages like this one:      NOTE: Invalid argument to function INPUT at line 1279 column 41. I think this issue is related to the mix of data points under this icd9 variable, some of which are non-numeric.  The good news is that when I ran it with your code, my output dataset had the same number of observations as when I ran it using the code above. Do you think it's likely that I'm missing some relevant data because of these errors or is this something I should just ignore? Thanks again! ... View more

Invalid numeric data

by Calcite | Level 5 in SAS Procedures
‎06-08-2012 06:02 PM
‎06-08-2012 06:02 PM
I would really appreciate any help with the following issue I'm having: I am working with administrative health data and am trying to identify all cancers (by their diagnosis codes).  I want to use a substring command to identify numbered diagnostic codes within a certain range within a variable in character format.  I can't just convert this variable to a numeric variable because there are various other data points (that i'm not interested in) that are nominal. Specifically, I want to identify all diagnosis codes ranging from 140 to 239, and ignore all other data.  When I run the data step, I get an error message that reads:           NOTE: Invalid numeric data, '01L' , at line 1276 column 36. (for several data points) Here is the relevant code:           data psneo_m9192; set ps_m9192; if substr(icd9,1,3) ge 140 and substr(icd9,1,3) le 239; run; Despite this, SAS still outputs a dataset with what appears to be the correct range of data.  However, I don't know if it is complete/accurate or what the error message means. Questions: 1) Is the problem that I am trying to identify a numeric range of data in a character variable? 2) How can I know if my output dataset is complete? Thanks very much! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Quick links