topic Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME in Administration and Deployment

Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

kmcnulty — Thu, 10 May 2018 15:31:56 GMT

I am trying to migrate a single data mart and use the %RMDMPKG macro to transfer my physical tables. I am working on an old Solaris server.

For some reason when I run it (in report mode just to try it out), it doesn't recognize my datamart. I am simply putting down DatamartName. I tried putting down the physical path, the folder path, ect. But nothing is working it doesn't recognize my other datamarts either. I am running %RMDMPKG in EG.

This is what I am supposed to do right?

Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

SASKiwi — Thu, 10 May 2018 20:12:42 GMT

%RMDMPKG is for migrating SAS metadata from one version of SAS to another, not physical tables. What OS and SAS version are you migrating from and going to? And what do you mean by "single data mart"? A SAS library containing a collection of SAS tables or something else?

Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

kmcnulty — Thu, 10 May 2018 22:15:29 GMT

So what is the most efficient way of transferring the physical data and creating folders then? Just one table at a time using sftp/ftp/nfs?

Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

kmcnulty — Thu, 10 May 2018 22:16:05 GMT

Are you a SAS ITRM user?

Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

kmcnulty — Thu, 10 May 2018 22:32:37 GMT

I didn't mean to mark my comment as the solution. I really hope that's NOT the solution.

Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

SASKiwi — Thu, 10 May 2018 22:34:37 GMT

No I'm not an ITRM user, but I have had lots of experience migrating data between SAS releases. One of the best ways in my experience, if your OS's are the same, is to set up shared folders between the SAS servers and use SAS tools like PROC DATASETS to copy whole SAS libraries in one go.

Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

kmcnulty — Thu, 10 May 2018 22:53:48 GMT

Interesting. It's Solaris to Linux but do you mean have a shared directory like NFS? And what would he syntax look like for proc datasets for two different servers? And it's 9.3 to 9.4.

Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

kmcnulty — Thu, 10 May 2018 22:55:20 GMT

Or maybe I should be asking how you set up a shared folder between servers if not using NFS and can you do it if the OS is not the same.

Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

SASKiwi — Fri, 11 May 2018 00:54:11 GMT

Check out the PROC DATASETS documentation:

http://documentation.sas.com/?docsetId=proc&docsetTarget=p1juxu16zautpxn1dikxecc3kn7w.htm&docsetVersion=9.4&locale=en

And I suggest you check out the Migration site to explore requirements regarding data as you may need to convert your SAS data:

http://support.sas.com/rnd/migration/planning/files/index.html

Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

kmcnulty — Fri, 11 May 2018 02:45:17 GMT

I was able to get some of our main reports running by just manually bringing over the tables. There's just sooo much to migrate. I got the datamart over but there so much physical stuff to bring over. Everything I can just export and import seemingly besides the actual reports and physical data. But to create all the same folder extents. I thought that's what those macros did in part as well.

Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

SASKiwi — Fri, 11 May 2018 04:57:52 GMT

If you read the documentation on the macros, their use should become clear. There's a heck of a lot of useful stuff in the Migration site worth checking out.

Also don't forget to test your SAS jobs in 9.4 as well to make sure they work correctly and give you the same answers as 9.3. We had to change quite a number of jobs when we did our SAS 9.3 to 9.4 migration to get identical results.

Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

ShelleySessoms — Fri, 11 May 2018 12:18:10 GMT

I will unmark that "solution" for you @kmcnulty.

Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

kmcnulty — Fri, 11 May 2018 19:42:16 GMT

As it turns out I was missing REPOS=Foundation. And IT does create a cport file with the physical data and creates all the folders. This makes sense for me because I am migrating from one operating system to another. I worked with SAS Support to arrive at that.

Re: Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

SASKiwi — Fri, 11 May 2018 22:36:05 GMT

Good to know. It appears that macro is specific to ITRM and it does move ITRM datamarts - thanks for the correction and good luck with the migration. If you are moving SAS data outside of ITRM datamarts as well then please check out the other options I mentioned.