Dear all,
I tried to import xlsx to sas 9.2 , tried the following :
PROC IMPORT DATAFILE= "/path/Drug_codes.xlsx"
OUT= FILES_CONSOLIDATED
DBMS=XLSX
REPLACE;
SHEET="anticancerall";
GETNAMES=YES;
DATAROW= 2;
RUN;
ERROR: DBMS type EXCEL not valid for import.
and
PROC IMPORT DATAFILE= "/path/Drug_codes.xlsx"
OUT= FILES_CONSOLIDATED
DBMS=XLSX
REPLACE;
SHEET="anticancerall";
GETNAMES=YES;
DATAROW= 2;
RUN;
ERROR: DBMS type XLSX not valid for import.
I am wondering how I can correct it.
Thank you,
Ivy
You need at least maintenance 2 of 9.2 and ACCESS to PC Files licensed.
Correction: make that SAS 9.4. Upgrade to the current version, or save your Excel data to a sensible text-based format and import that.
SAS 9.2 was released in 2008 and SAS 9.2 TS1M2 in 2010. You're on quite an old version at this point.
Thank you, all.
I am copying the data to different sheet to be imported.
Have a great weekend,
Ivy
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.