Hi folks,
We are changing our SAS installation from Unix (HP-UX server) to Linux (RedHat) server. One quickly question: is it necessary to make any transformation on our .sas7bdat files to works in Linux server?
Regards,
Thanks!
Hi @MargaretC ,
So, as per your information, we'll need to recreate all indexes for our SAS tables. If we use a REPAIR sentence for PROC DATASETS on a Linux server, the index will be recreated? If not, there is any way to read (before migrate the data) the index definition to create a process to recreate them on Linux server?
I know the PROC CONTENTS show the index detail but in a report. There is any way to send this information to a table to create an automatic process?
Regards,
@MariaD - If you use SAS/CONNECT and PROC UPLOAD to migrate your data you can recreate your indexes automatically: https://documentation.sas.com/?docsetId=connref&docsetTarget=n12q8v8qgfbtw8n1kqlzm78mvaz8.htm&docset...
@MariaD - That is exactly what SAS/CONNECT can do, and it handles the automatic conversion of SAS files between operating systems, including SAS datasets and catalogs.
PROC MIGRATE can be used with SAS/CONNECT from one file system to another file system to avoid CEDA limitations. Indexes and integrity constraints are rebuilt on the member in the target library.
Here is the PROC MIGRATE documentation but a better example that uses a CONNECT spawner is below (the doc will be updated at next release). Run this in the target environment, using your values for the italic values in the example. Note that PROC MIGRATE can only migrate one library (directory) at a time. The CONNECT server must match the data representation of the source library, which in your case would be HP-UX.
options comamid=tcp; %let myserver=host.name.com; signon myserver.__1234 user=userid password='mypw'; libname source 'source-library-pathname' server=myserver.__1234; libname target 'target-library-pathname'; proc migrate in=source out=target <options>; run; signoff myserver.__1234;
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.