Essentially a view is not data itself, but rather the SQL code that defines
how to pull the data from the table. Thus no, you can't take a SAS data
set and push it to SQL server as a view. What you can do is to create a
view from a SQL Server table. If you want to do that from SAS, use
pass-through SQL with an Execute( ) statement, and the SQL server code to
create the view would need to be inside the execute statement.
If you know MS Access, a View in SQL Server is like a stored query in
----- Original Message -----
From: "Sophia Tong" <sophiDT@HOTMAIL.COM>
Sent: Wednesday, April 29, 2009 12:35 PM
Subject: Can SAS view be loaded to SQL server?
> Dear listers,
> We are trying to create view in SQL server, since we have already had SAS
> view created by SAS SQL, so we try to upload SAS view to SQL server
> of re-create one. We only had experience to upload SAS table to SQL
> but never upload a view. We tried the code for uploading SAS table, and
> turns out SQL server took it as table instead of view. My questions are:
> Can SAS view be uploaded to SQL server?
> If yes, can anyone kindly provide the correct code for it?
> Thanks in advance,