06-21-2016 02:57 AM
please help me to understande below piece of code.
1. proc datasets lib = out nolist;
2.create table &PassThroughTableName. AS
select * from CONNECTION to SQLServerDatabase
06-21-2016 03:07 AM - edited 06-21-2016 03:07 AM
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).