topic Re: How do I Import Excel into SAS EG without creating a project in SAS Enterprise Guide

How do I Import Excel into SAS EG without creating a project

lrpitts64 — Fri, 13 Dec 2024 16:38:39 GMT

Hello,

Was not sure if this question should be "new users" or SAS EG and If this was asked previously, please supply the link, I couldn't locate an answer

I am trying to determine if you can import Excel without creating a project, when I click on "import data", it states a project must be created first

using SAS EG 8.4 Update 1 (8.4.1.15) (64-bit)

thanks for your assistance,

Lynnette

Re: How do I Import Excel into SAS EG without creating a project

ballardw — Fri, 13 Dec 2024 17:14:28 GMT

Projects generate program code.

If you open the program window and type Proc Import code you can run the code.

Or perhaps us a LIBNAME statement pointing at the file to have the sheets treated as data sets. This is often hit or miss because way too many excel workbooks aren't structured well.

Re: How do I Import Excel into SAS EG without creating a project

ChrisHemedinger — Fri, 13 Dec 2024 17:20:58 GMT

@lrpitts64, it's just as @ballardw says.

In EG v8 and later you can open, create, and run SAS program code without a project. Just about every other action (running any task including Import Data or Query Builder) will need the structure of a project, and it will capture that step in the process flow -- even if it's a one-off action that you don't need to save for reuse later.

Re: How do I Import Excel into SAS EG without creating a project

Tom — Sat, 14 Dec 2024 03:47:07 GMT

So if the file you want to IMPORT is available on the machine where SAS runs (which can be a different machine than the machine where the Enterprise Guide user interface runs) then you can import it by just writing and running a PROC IMPORT step in the program editor. Make sure to reference the file using the location where it exists on the SAS server, which could look totally different than where the file is visible on the PC that is running Enterprise Guide. Especially if SAS is running on Unix.

But if you want Enterprise Guide to upload the file from the machine it runs on to the machine where the SAS code EG submits for you runs then you will need to make project, even if you throw the project away later.

Re: How do I Import Excel into SAS EG without creating a project

lrpitts64 — Mon, 16 Dec 2024 16:20:48 GMT

Thank you for reply, appreciate your assistance

Re: How do I Import Excel into SAS EG without creating a project

lrpitts64 — Mon, 16 Dec 2024 16:21:42 GMT

Thank everyone for their quick responses, I really appreciate all your assistance.

Re: How do I Import Excel into SAS EG without creating a project

lrpitts64 — Mon, 16 Dec 2024 16:52:48 GMT

Thank you for reply, appreciate your assistance.