BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Jagadeesh2907
Obsidian | Level 7

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

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.

View solution in original post

7 REPLIES 7
LinusH
Tourmaline | Level 20

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.

Data never sleeps
Kurt_Bremser
Super User

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
Obsidian | Level 7
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
Super User

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
Obsidian | Level 7

This seems to be a good solution. Thank you.

Jagadeesh2907
Obsidian | Level 7

This is a good solution

Jagadeesh2907
Obsidian | Level 7

this is a good sample

SAS Innovate 2025: Call for Content

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!

Submit your idea!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 1059 views
  • 2 likes
  • 3 in conversation