Migrating SAS Views

[vijayanand]

Hi ,

We are migrting SAS  Data from AIX to Linux machine.  For this we are using different SAS procewdures like PROC CPORT , CIMPORT , PROD DOWNLOAD etc...

These procedures are able to migrated SAS datasets, index files  and catalogs but not views.

PROC DOWNLOAD can migrate the views created using PROC SQL.  

How to migrate the views created using data step. 

Proc migrate can migrate the views but it has some limitations that it can not handle the views created on  AIX 64 bit OS.

Thanks,

Vijayanand.

[SASKiwi]

It would be better to re-run the source code creating the views on the target system. This will also test whether all of the correct libraries, tables and columns are present to recreate the views successfully.

[vijayanand]

Thanks for the quick response.

Yes, running the source code is an option here. Unfortunately, I do not have access to the source code to run.

What other alternative can I choose to accomplish this.

[Kurt_Bremser]

With data step views , you can retrieve the code with this:

data view=viewname;
describe;
run; 

With SQL views, use this code:

proc sql;
describe view viewname;
quit;

---

@vijayanand wrote:
Unfortunately, I do not have access to the source code to run.

---

Somebody needs to be hung, drawn and quartered. Let this be an object lesson for the importance of proper documentation and sane coding processes.