topic BASE SAS Code in SAS Enterprise Guide

BASE SAS Code

Tushh — Tue, 21 Jun 2016 06:57:17 GMT

Hi,

please help me to understande below piece of code.

1. proc datasets lib = out nolist;

delete &PgmPrefix._Table1_new;

delete &PgmPrefix._Table2_new;

Run;

2.create table &PassThroughTableName. AS

select * from CONNECTION to SQLServerDatabase

Thank You

Re: BASE SAS Code

Kurt_Bremser — Tue, 21 Jun 2016 07:07:47 GMT

The first segment deletes datasets from library "out". The macro variable "pgmprefix" holds the prefix for the dataset names.

The second is obviously part of a proc sql; it creates a SAS table from a connection to an external RDBMS (the necessary specifics for the remote table are missing).

Re: BASE SAS Code

Tushh — Tue, 21 Jun 2016 07:26:41 GMT

Thanks for quick reply its helpful..!!!

Re: BASE SAS Code

LinusH — Tue, 21 Jun 2016 16:20:14 GMT

#sasonlinedoc