Hi ,
We recently have migrated some SAS data sets from Unix server to Linux server. The data sets which were migrated already, are growing daily (some observations are being added,some are being updated and some are being deleted) on the source server (Unix).
How do we bring all these changes alone on to the target (Linux Server).
Some of the data sets are very hugs in size, so migrating the entire data set again from source to target is very time consuming and this has to happen daily , till the target server goes live.
Thanks,
Vijay.
There is no CDC for SAS tables. You would need to implement fully blown ETL delta processing which is nothing you can just do on-the-fly as an intermediary measure.
Best you can do is to compress/zip your data before transferring from source to target - but you will still need to transfer the whole file.
...or: Any chance to map the file system used by the old server also to the new server as an intermediary measure?
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!
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.