topic Re: Migrating SAS Views in SAS Procedures

Migrating SAS Views

vijayanand — Fri, 26 Apr 2019 09:15:53 GMT

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.

Re: Migrating SAS Views

SASKiwi — Fri, 26 Apr 2019 09:20:55 GMT

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.

Re: Migrating SAS Views

vijayanand — Fri, 26 Apr 2019 09:51:47 GMT

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.

Re: Migrating SAS Views

Kurt_Bremser — Fri, 26 Apr 2019 12:19:50 GMT

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.