topic Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems in SAS Programming

How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

vineet7878_gmail_com — Thu, 24 May 2018 12:37:18 GMT

Hi,

I created a secure macro catalog on a 64 bit Windows OS. When the same catalog is used on a 32 bit Windows OS, it gives

ERROR: File xxxxxx was created on a different operating system.

How do we create a catalog that works across all operating systems. Or otherwise is it possible to create a 32bit version of the catalog on a 64 bit OS?

Thanks in advance.

Vineet

Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

Kurt_Bremser — Thu, 24 May 2018 12:44:52 GMT

No, and no. Catalogs are OS- and bitness-specific. Recreate from code in each environment.

Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

data_null__ — Thu, 24 May 2018 12:45:25 GMT

Are you sure hiding your code is a good idea. If you are willing to let others see your work then you can use good old auto-call and not have to worry about bitness.

Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

vineet7878_gmail_com — Thu, 24 May 2018 12:57:28 GMT

It is very important for us not to share the proprietary code with the client.

Whereas, CPORT doesn't work, it gives following message:

11 proc cport library=tmp1 file=trans;
12 run;

NOTE: PROC CPORT begins to transport catalog TMP1.SASMACR
NOTE: The catalog has 17 entries and its maximum logical record length is 3604.
WARNING: Entry type MACRO not supported by CPORT.
WARNING: Entry type MACRO not supported by CPORT.

Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

SuryaKiran — Thu, 24 May 2018 13:03:16 GMT

I'm sorry I miss understood you question. CPORT is for FORMAT catalogs migration. You may need to save the original source code and later compile it.

Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

vineet7878_gmail_com — Thu, 24 May 2018 13:20:26 GMT

I don't have access to 32 bit OS and my client only has 32 bit OS.

Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

vineet7878_gmail_com — Thu, 24 May 2018 13:22:02 GMT

I don't have access to 32 bit OS, my code is sitting in 64 bit OS. Whereas my client is using 32 bit OS.

Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

Kurt_Bremser — Thu, 24 May 2018 13:25:54 GMT

Then you need to set up a 32 bit environment for migrating the catalogs, or have the client migrate to 64 bit.

Or you have to re-examine the reasons for keeping your code secret.

Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

data_null__ — Thu, 24 May 2018 14:01:50 GMT

@vineet7878_gmail_com wrote:

It is very important for us not to share the proprietary code with the client.

Why don't trust your client?

Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

Tom — Thu, 24 May 2018 14:06:24 GMT

@data_null__ wrote:

@vineet7878_gmail_com wrote:

It is very important for us not to share the proprietary code with the client.

Why don't trust your client?

and therefor why should the client trust you?

Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

ballardw — Thu, 24 May 2018 14:24:15 GMT

@vineet7878_gmail_com wrote:

It is very important for us not to share the proprietary code with the client.

Whereas, CPORT doesn't work, it gives following message:

11 proc cport library=tmp1 file=trans;
12 run;

NOTE: PROC CPORT begins to transport catalog TMP1.SASMACR
NOTE: The catalog has 17 entries and its maximum logical record length is 3604.
WARNING: Entry type MACRO not supported by CPORT.
WARNING: Entry type MACRO not supported by CPORT.

If this issue is so important to your company then the proper approach would be to get a 32 bit system with their OS and run the code your new system and send that catalog.

However you might want to very carefully check that you have not used any features in your code that are not available in the other OS or version.

Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

vineet7878 — Fri, 25 May 2018 12:30:59 GMT

Thanks for all your help. I see there is no simple solution to this problem. Without the portability of macro catalogs across platforms, functionality of secured catalogs in SAS is pretty much useless.

Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

Kurt_Bremser — Fri, 25 May 2018 12:46:42 GMT

As an interpreting environment, the SAS world is basically open-source.

As a consultant's customer, handover of ALL code (at least after a project is finished) would be a strict requirement for me.

Re: How do I create a secure macro catalog that works across 32bit and 64 bit operating systems

vineet7878 — Fri, 25 May 2018 12:56:14 GMT

hi Kurt,

I strongly disagree. Do we have the code for Microsoft windows, microsoft excel or hundreds of other software tools that we use on daily basis in computer, phones etc, although a lot of code is open source.

Code custom built for a client is client's property, whereas propriety code used to execute specific tasks is usually not client's property.

Vineet