@Silver77 You should always try and formulate if/then/else constructs exhaustive and exclusive. Exhaustive: Covers all cases. There is always one condition that gets True. Exclusive: No overlaps. Exactly one condition gets True.   The syntax you shared is not exhaustive. You don't cover cases where Excercise is 3.25, missing or below zero. ... View more

Thank you this was very helpful  ... View more

So the variable either is not in that dataset.  Or perhaps you have used the wrong name. Age_Adjusted_Rate is a different variable than 'Age adjusted rate'n or 'age-adjusted data'n.   Perhaps you have accidentally set the VALIDVARNAME option to ANY? Try changing it to V7 before running the PROC IMPORT.  That way PROC IMPORT should make a variable named Age_Adjusted_Rate from a column in the CSV file that has Age Adjusted Rate as the column header instead of making a variable name that has spaces in it so that it requires using name literals in the SAS code. ... View more