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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.