Hi,
I am using SAS University Edition and I am taking SAS essentials course from the SAS website. However, in the tutorials PCfiles engine is used to access MS Excel files, which I cannot use in University edition. Can anyone suggest an alternate way to access Excel files in SAS University Edition? Also want to know if I can still continue with the same tutorial using the University Edition without using PCfiles engine.
Thanks,
Swati
You can't use libname methods, but you can use standard proc import methods.
I don't think it makes an impact on the learning besides how to read the data. Once the data is in, it doesn't matter much how you got it there, the steps afterward would be the same.
Thanks for your quick reply Reeza. I entered the following code:
/** Import an XLSX file. **/
PROC IMPORT DATAFILE="/folders/myshortcuts/Myfolder/Sales.xlsx"
OUT=WORK.MYEXCEL
DBMS=XLSX
REPLACE;
RUN;
Proc contents data=sales._all_;
run;
data work.salesnew;
run;
PROC PRINT DATA=WORK.salesnew label;
RUN;
However I am getting the error that Libref Sales is not assigned
Thanks,
Swati
The first SAS e-course is free, you may want to take that for a step by step walk through of getting started with SAS. It is also designed for SAS UE, so that will help avoid technical difficulties.
Proc import -> imports data. The specifics actually vary depending on the type of data, so its worth reading the documentation on the procdure.
One good thing to learn, is how to navigate the documentation, because a lot of the questions you're going to have will have the answers there.
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.