Desktop productivity for business analysts and programmers

BASE SAS Code

Reply
Contributor
Posts: 33

BASE SAS Code

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

 

Super User
Posts: 7,386

Re: BASE SAS Code

[ Edited ]

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).

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 33

Re: BASE SAS Code

Thanks for quick reply its helpful..!!!
Super User
Posts: 5,380

Re: BASE SAS Code

#sasonlinedoc
Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 232 views
  • 0 likes
  • 3 in conversation