Copy SAS views from one server to another

[Jagadeesh2907]

Hi 

we have two servers like a PROD and UAT for production (Both Linux) and test purposes. when we copy datasets between these server it is working fine. however, when we copy SAS views, it is not working fine. hence i got the below queries to understand how it works. 

1. when we copy SAS views between servers, do we need to copy the underlying dataset as well ?

2. if we copy the dataset and view from one server to another, will it work ? or should we copy the dataset from the server and create a view explicitly in the destination server ?

please help clarify these queries for understanding. 

[LinusH]

1. YES! (given the data set is not already in place)

2. Most likely, but there can be environmental issues like autorizations etc than can come into play. Your architect should be able to guide you how this should work.

[Kurt_Bremser]

SQL views can easily be copied between most SAS environments and will work as long as the source datasets/tables are available.

Data step views, OTOH, are dependent on hardware, operating system, and (major) SAS version.

[Jagadeesh2907]

Hi Kurt,

Thank you. that is very informative. just one more follow up as part of this, For a Data step view (a.sas7bvew) file, when it is copied in a like for like environment, source dataset should also be copied and should be available. is my understanding right ?

[Kurt_Bremser · Accepted solution]

You always must move the source datasets along with the views (unless, as otherwhere mentioned, they are already present), as the data is only contained there. .sas7bvew files (the extension is the same for SQL and data step views) contain the view code only, data step views as a compiled data step program, SQL as text.

[Jagadeesh2907]

This seems to be a good solution. Thank you.

[Jagadeesh2907]

This is a good solution

[Jagadeesh2907]

this is a good sample