Converting .xlsx to .sas7bdat

[Dee3]

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!

[RW9]

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.

[Tom]

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.