Running this code and coming up with the error above. Any suggestions on how to successfully run?
proc sql ; create table max_line_apc as
select legacy_claim_id
,line_id
,apc_fee
,max_apc_fee
from OPSURG6
where apc_fee not in (0, .)
order by legacy_claim_id, apc_fee desc
;
quit ;
This indicates that when you are doing some sort of comparison, one of the variables is numeric and one of the variables is character/text, and so these cannot be compared. In your code, this is the comparison where this happens:
where apc_fee not in (0, .)
To fix this, you might want to change apc_fee to numeric (if possible), or try this
where input(apc_fee,32.) not in (0,.)
The Input function will turn a character variable into a numeric variable
This indicates that when you are doing some sort of comparison, one of the variables is numeric and one of the variables is character/text, and so these cannot be compared. In your code, this is the comparison where this happens:
where apc_fee not in (0, .)
To fix this, you might want to change apc_fee to numeric (if possible), or try this
where input(apc_fee,32.) not in (0,.)
The Input function will turn a character variable into a numeric variable
Thank you
See screenshot:
When things are not working, we need to see the LOG (we need to see the entire log for this PROC SQL)
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.