Date:         Fri, 18 Oct 2002 10:03:33 -0700
Reply-To:     Jeff Morison <jmt_mtf@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jeff Morison <jmt_mtf@YAHOO.COM>
Subject:      I need to automate this please
Content-Type: text/plain; charset=us-ascii

 I came up with this code to create a SAS view from a
MS SQL Server table, but there are tons of tables in
that server, I don't want to manually type each table
name and create a SAS View, is there an easy way to
get the list of all the tables in the SQL Server
database and macrotize this code to create a SAS view
for each table.

Your help will be highly appreciated.

TIA,
Jeff


proc sql;
  connect to sqlservr(server=phildcut83
database=racerep user=xxxxxx password=xxxxxx);
  create view raceview.t_History_change_log as
    select *
    from connection to sqlservr
    (select *
     from t_History_change_log );
  disconnect from sqlservr;
quit;

__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com