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.
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.
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.
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.
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.
This seems to be a good solution. Thank you.
This is a good solution
this is a good sample
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.