CODEWITHSUNDEEP
sassas-studio
zsad512
zsad512

Reputation: 881

SAS Studio import error

I am trying to use SAS Studio in VirtualBox, when I run certain scripts though- I get numerous errors. Namely, when I run the following code:

proc import datafile = "UTDCASESTUDYDATA1.xlsx" 
            out = ti 
            dbms = excel;
run;

I get the error:

ERROR: DBMS type EXCEL not valid for import. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds

I am wondering, what is the functionality of SAS Studio compared to the normal desktop version of the program? For example, when I try to run PROC ASSOC or certain plotting functions, I get an error that the function is "unavailable" so Im wondering if these procedures are simply limited from SAS Studio or if I have syntax errors.

Any help is appreciated.

Upvotes: 0

Views: 271

Answers (1)

Tom
Tom

Reputation: 51566

You can use the XLSX engine instead of the EXCEL engine to directly read XLSX files without having access to Microsoft products.

Sounds like you are using SAS University Edition. PROC ASSOC is not available in that because it requires a license for Enterprise Miner.

See this thread on SAS Communities https://communities.sas.com/t5/SAS-Procedures/Association-analysis-proc-assoc-and-proc-rulegen/td-p/122287

Upvotes: 2

Related Questions