topic Re: Converting .xlsx to .sas7bdat in SAS Studio

Converting .xlsx to .sas7bdat

Dee3 — Thu, 06 Sep 2018 13:04:53 GMT

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!

Re: Converting .xlsx to .sas7bdat

RW9 — Thu, 06 Sep 2018 13:14:51 GMT

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.

Re: Converting .xlsx to .sas7bdat

Tom — Thu, 06 Sep 2018 14:11:54 GMT

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.