Hello everybody
I have existing dataset covid which has space in variables name like below:
numero expediente del paciente
I tried renaming them assuming SAS would turn spaces into underscores but when I run the program it sends a warning that the variable does not exist in the dataset. I have run PROC CONTENTS and the variables are there, but the variable name appears without underscores. The original data came from an excel file but I changed it into SAS data.
Here's the code:
libname COVIDBD '/home/mercedesaguilars0/sasuser.v94/SASMer';
data base;
set covidbd.covid;
run;
NOTE: There were 398 observations read from the data set COVIDBD.COVID.
NOTE: The data set WORK.BASE has 398 observations and 199 variables.
data base2;
set base
(rename=(numero_expediente_del_paciente=numexp));
run;
Variable numero_expediente_del_paciente is not on file WORK.BASE2
Thank you