I used SAS Enterprise Miner to build a prediction model and now am applying it to score a new excel data where the numerical target variable is an empty column. I believe that the empty values cause the target variable to be recognized as categorical in the score data and I cannot select 'interval' as the role. How can I use the model to predict the numerical target variable in the score data? I already tried to change blanks to '.' in the excel file for SAS to take this column as numerical but it doesn't work.   ... View more

I have a variable that only takes 1,2,3 and 9 with meaningful labels ('strongly agree','agree', 'disagree', 'strongly disagree' but I don't know which is which). I need to recode it to a binary variable (e.g, 'agree' and 'disagree').   However, the variable is labeled as a numerical variable in SAS so I can not use 'Recode Values' task to complete recoding nor to recode to another num variable because I don't know how to match the value and the label. Thanks for any help.    ... View more