I have a same issue, I am reading my file with proc import as follow. Some of my variables have just missing values and they are getting converted into character, how could I stop it. I used dbsastype, it did not work out. PROC IMPORT DATAFILE="/folders/myshortcuts/Myfolder/&var3/TissueTests (&var1).xlsx" OUT=WORK.file&var1 DBMS=XLSX REPLACE; sheet="TissueTests (&var2)"; getnames=yes; RUN;
... View more