Hi! I'm very new with SAS and one thing that I can't recall that we have already done during class was uploading xlsx file and converting it to become a .sas7bdat or SAS table. Can you please give me reference a link or a step by step refresher for this? Thanks in advance!
Here are the free SAS guidance videos:
https://video.sas.com/category/videos/how-to-tutorials
Specifically:
https://video.sas.com/category/videos/sas-studio#category/videos/sas-studio/1
At least one of them is on importing data.
The simplest way to convert an XLSX file to SAS dataset(s) is to use the XLSX libname engine and PROC COPY.
libname in xlsx 'mysheets.xlsx';
proc copy inlib=in outlib=work;
run;
The question of "uploading" depends a lot on your setup. The SAS code above needs to be able to see the XLSX file to work. So if you have the file on your PC but you are running SAS on some other machine (or in a virtual machine) then you need to move the file to a place where SAS can see it.
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.