topic Importing XLSX to WORK in New SAS User

Importing XLSX to WORK

polpel — Fri, 11 Oct 2019 08:08:59 GMT

Hello,

I want to import an XLSX file. I'm currently doing it like this:

libname MYLIB XLSX "my_file.xlsx" access=readonly;

The problem with this is that I need to rename the variables and send them to the WORk lib.

Is there a way I could import directly to WORK?

I tried chaging the libname parameter but it didn't work...

Regards

Re: Importing XLSX to WORK

polpel — Fri, 11 Oct 2019 08:11:11 GMT

Note that there are two sheets in my excel file

Re: Importing XLSX to WORK

andreas_lds — Fri, 11 Oct 2019 08:54:42 GMT

You could switch to proc import, but you need one for each sheet, so keeping libname-statement seems to be easier. You can copy datasets using proc copy:

proc copy in=mylib out=work;
run;

This step copies all sheets/datasets from mylib to work.

For renaming variable proc datasets with modify seem to be the best tool.

Re: Importing XLSX to WORK

Patrick — Fri, 11 Oct 2019 10:58:17 GMT

@polpel

As you anyway have to copy the data just use a data step where you can also rename the variables and do whatever other transformations you need.

Using a SAS data step makes it also really simple to combine the two source sheets into a single table in Work.