Hi all,
I am using 9.4 Base. Since I have x86 Office and x64 SAS, I use DMBS = EXCELCS in PROC IMPORT to read excel files.
Some of the variables are like " X Y ", with 3 leading and 3 trailing spaces and one in between. I need to read these variables to "X_Y".
This is achievable effortlessly by my coworker's setup of x86 SAS, which does not have to enable PC Files Server, with simply DBMS = EXCEL.
I am not sure why this difference exists. And I wonder if there are fixes to remediate this while not deviating from the existing version?