topic Re: Integration Studio - Import SAS code: execution upon import? in SAS Data Management

Integration Studio - Import SAS code: execution upon import?

hulst — Mon, 07 Oct 2013 11:19:14 GMT

Why does importing sas code also need to execute it?

Can I skip the execution of the SAS code when importing the code?

If the SAS code takes 1 hour to run and I have n files to import it will take (n x 1) hours.:smileyshocked:

I already know the .sas code is perfect and will run. :smileylaugh:

Re: Integration Studio - Import SAS code: execution upon import?

LinusH — Mon, 07 Oct 2013 11:39:24 GMT

Yes, you could wish for a more syntax analyzing import rather than a full execution.

Consider to add a options obs= in your code, which you could remove after the import.

Re: Integration Studio - Import SAS code: execution upon import?

hulst — Mon, 07 Oct 2013 12:07:12 GMT

A good point. Execution with less observations will run faster.

However an EG file with somewhere "proc SQL; drop table; create table as select * from other table;" does a lot of "damage" if just imported in the wrong server environment.

Re: Integration Studio - Import SAS code: execution upon import?

LinusH — Tue, 08 Oct 2013 11:19:47 GMT

This is typically part of a development process, and should NOT be done in prod environment.