About kmcnulty

kmcnulty · ‎07-26-2018

　 It's my understanding that this type of macro is recreated when you deploy or run your code. But what is happening is that my 9.4 installation is just taking the 9.3 reference literally, not replacing or regenerating the macro as it's supposed to. But it doesn't do this for my other datamarts. I'm being told that it's because the automatic code of my job is all mixed in with the user written code and it's basically all messed up and there's no way of fixing it. This just doesn't seem right to me. /* Invoke the stored macro　 */ 781　　　　　　　 782　　　　　　　 783　　　　　　　 options mstored sasmstore=MYSTAGINGLIB; 784　　　　　　　 %A5QN9SRM_BE0000BO_1070881485; 785　　　　　　　

kmcnulty · ‎07-25-2018

I am migrating datamarts from 9.3 to 9.4. Most of them have been successfully migrated but there are a few that won't resolve the macros in 9.4 even though migrating the metadata and the physical data seems to go just fine. Instead of recreating the code in 9.4 it just stays exactly the same as it was in 9.3 with the same macro references which of course can't be resolved. I am being told I may have to recreate the datamarts in the new environment. This seems unreasonable. I hope someone has some insight.

kmcnulty · ‎05-11-2018

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.

kmcnulty · ‎05-10-2018

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.

kmcnulty · ‎05-10-2018

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.

kmcnulty · ‎05-10-2018

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.

kmcnulty · ‎05-10-2018

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

kmcnulty · ‎05-10-2018

Are you a SAS ITRM user?

kmcnulty · ‎05-10-2018

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?

kmcnulty · ‎05-10-2018

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?

kmcnulty · ‎02-06-2018

I am inquiring but I don't think so. If I am, however, do I not need Adobe Flash Player or is there an alternative?

kmcnulty · ‎02-05-2018

But my question is still relevant to BI studio.

kmcnulty · ‎02-05-2018

I think I didn't actually need Flash Player for WRS... I just needed it for BI studio.

kmcnulty · ‎02-05-2018

My organization often makes Adobe Flash Player unavailable. When this happens nobody can access any web reports or BI Studio. This is a major inconvenience. I was wondering if there is an alternative or a way of making another flash player the default. I don't see anything posted on this topic anywhere so I think it's unlikely but I am hopeful.

kmcnulty · ‎11-03-2017

I am trying to write a macro that contains the following line to get the last 90 days from my temporary data set. Do I need to use %eval and %sysfunc in the macro for it to work or can I just use today()-90? t1.DAYDATE > %eval(%sysfunc(today())-90)

Online Status	Offline
Date Last Visited	‎01-17-2022 04:44 PM

Re: Migrating to 9.4 and My Macro Won't Resolve

Migrating to 9.4 and My Macro Won't Resolve

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

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

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

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

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

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

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

Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

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

Re: Alternatives to Adobe Flash Player

Re: Alternatives to Adobe Flash Player

Migrating to 9.4 and My Macro Won't Resolve

Re: Migrating to 9.4 and My Macro Won't Resolve

Migrating to 9.4 and My Macro Won't Resolve

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

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

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

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

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

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

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

Migration to 9.4 %RMDMPKG ISN'T WORKING FOR ME

Re: Alternatives to Adobe Flash Player

Re: Alternatives to Adobe Flash Player

Re: Alternatives to Adobe Flash Player

Alternatives to Adobe Flash Player

Macro to get last 90 days

SAS Analytics Explorers