You check if event=. which means that you expect EVENT to be numeric,
while it seems to be char type like (see log) Event='Business Inventories' .
Did you mean to check if event is missing/blank/empty ?Then check by if missing(event) then...
Or maybe you want to check another variable?
You check if event=. which means that you expect EVENT to be numeric,
while it seems to be char type like (see log) Event='Business Inventories' .
Did you mean to check if event is missing/blank/empty ?Then check by if missing(event) then...
Or maybe you want to check another variable?
That's correct.
Every time you see this:
NOTE: Character values have been converted to numeric values at the places given by:
it has to ring an alarm bell. Find the cause and remove it by implementing an explicit conversion, or make up your code so that it accomodates the variable types (what you are already doing).
Also see Maxim 25.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.