Hi everyone, I am trying to create a new variable but am running into a problem where the new variable returns "." for all observations, even though I can see from my data that these should not be missing. I am using SAS9. Please see my code below to illustrate the problem I am having: data mergedtest;
set work.merged_all;
if completed="Y" then test1=1;
if experience= "1 to 5 years" then test2=1;
if stream= "General Labour" then test3=1;
run; The "completed", "experience", and "stream" variables are all string variables. SAS does not tell me that there are any errors when I run this data step. However, when I run the tables command on test1, test2, and test3 (to check to see if variables were created properly), test1 and test2 are fine, but test3 returns all missing values (even though i can see from the raw data that several observations have a value of "General Labour" for the "stream" variable). Has anyone had this issue before? Any thoughts on what might be causing this problem? Any suggestions would be very appreciated. Thank you for taking the time to help! Take care, Yuna
... View more