Hello,
I have data on excel. There are two (#1 and #2) students answering few questions (1, 2 and 3). I am trying to read these data into SAS. I have written the following code. But it does not work.
proc import out=Report.student;
datafile= '/......./ ......./......./Report.xlsx';
dbms=execl replace;
run;
There are blank spaces in the sheet too. How can I write "Missing" in those blank spaces?
... View more