- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.