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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.