About vineet7878_gmail_com

vineet7878_gmail_com · ‎05-24-2018

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.

vineet7878_gmail_com · ‎05-24-2018

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

vineet7878_gmail_com · ‎05-24-2018

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.

vineet7878_gmail_com · ‎05-24-2018

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

vineet7878_gmail_com · ‎02-23-2018

SAS support has provided a workaround to fix this problem. It is provided below. Thanks for your prompt help. data x; format x $200.; x = 'Some text without special symbol'; output; output; x = "Some text with special symbol Greater than or equal to - ^S={font_face=Symbol}%sysfunc(byte(179))"; output; x = "Some text without special symbol Greater than or equal to"; output; x = 'Some text without special symbol'; output; output; run;

vineet7878_gmail_com · ‎02-21-2018

Thanks Cynthia. I have opened up a track with support.

vineet7878_gmail_com · ‎02-21-2018

Thanks Gina. This solution doesn't work when text is wrapping up in the cell, which is often the case. I am looking for a solution where I set the value once somewhere in proc report, template or any other place to fix the line height. Data driven use of these symbols, superscript, subscript etc shouldn't mess up my report layout, pagination etc.

vineet7878_gmail_com · ‎02-19-2018

Hi, I am struggling with ODS PDF where use of special symbols cause increase in height of row generated by proc report via ODS PDF. E.g. see the third row in attached file. The output is generated via following code. Is there a way to ensure the height of the rows wherever the symbols are used to be same as the height of the other rows. Thanks in advance. data x; format x $200.; x = 'Some text without special symbol'; output; output; x = "Some text with special symbol Greater than or equal to - ^{unicode 2265}"; output; x = 'Some text without special symbol'; output; output; run; ods escapechar="^"; options printerpath=pdf; ods pdf file="d:\text_test.pdf" title="text" uniform notoc nobookmarkgen; proc report data=x nowd; column x; define x/display 'text'; run; ods pdf close;

vineet7878_gmail_com · ‎10-09-2017

I like Ricks solution. The custom code is coming from SAS code entered as snippets within excel based data specifications file, from where it is exported to SAS to run. I guess, I need to build code testing module to test such code, before actually running it. I was hoping to not do such checking and just have some magic string at the end of code to catch the issues and continue without disruption.

vineet7878_gmail_com · ‎10-09-2017

Hi, I am stuck in a problem with unbalanced quotes and would greatly appreciate your help. I have a macro as shown below. Here I have an external piece of custom code pasted in via a macro variable (or %include statement). This custom code isn't tested upfront until it is used here. Sometimes this custom code has unbalanced quotes and causes my remaining code to fail. I have tried the strings such as *’; *”; */; or *); */; /*’*/ /*”*/; %mend; after the custom code, to catch such issues and continue with my remaining code normally. But nothing so far has been successful. Please help. Thanks Vineet %macro mymacro; -- my code --; &custom_code; * This macro variable inserts custom code and sometimes have unbalanced quotes ; -- my remaining code --; %mend mymacro; %mymacro;

vineet7878_gmail_com · ‎05-19-2017

Hi Cynthia, I tested the problem in simplified code and wasn't able to reproduce the issue. Probably the issue occurs due to conflic of options in proc report and proc template for ODS pdf. I will leave it here. Thanks, Vineet

vineet7878_gmail_com · ‎05-18-2017

Hi Cynthia, Thanks for answering all such questions over the years. I had been using ODS RTF for all my reports and graphs over the years. Now I am converting my macros to ODS PDF due to some advantages that ods pdf have over rtf. I am running into several challenges, but finding solutions after a lot of hit and trial and after a lot of googling. It is hard for me to copy code, since it is so much macrotized. I was hoping you are already aware of the issue and its fix. In this case I have already modified my code to use percentages rather than inches. There is no need to follow up in this question now. Regards, Vineet

vineet7878_gmail_com · ‎05-18-2017

I am using ODS pdf and trying to eliminate automatic margin of about .5 in created on the left and right of the table frame in addition to the margin defined for the body. This happens when the column width is specified in inches. Whereas when cellwidth is specified in percentage, such margins don't appear. Please help. Thanks in advance. Vineet

vineet7878_gmail_com · ‎05-18-2017

Thanks Cynthia, for quick reply. I wish ODS pdf & RTF were designed such that these options worked interchangeably in same way.

vineet7878_gmail_com · ‎05-18-2017

I am trying to replicate the functionality present in ods RTF for ODS PDF, where if style with width=100% is specified in proc template or in proc report statement, the columns spread to occupy 100% of space, without any gaps between the columns. I am unable to get the same functionality for pdf. E.g. for a landscape page, I am specifying 2 columns with widths 1 inch each along with width=100% in proc report statement. This creates big gap between two columns and after the end of last column. Can these gaps between the columns and after the last column be eliminated such that the columns widths automatically spreadout for ODF pdf. I am using SAS 9.3 Thanks. Vineet

Online Status	Offline
Date Last Visited	‎08-11-2018 07:08 AM

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

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

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

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

Re: Row height changes with use of symbols in ODS PDF

Re: Row height changes with use of symbols in ODS PDF

Re: Row height changes with use of symbols in ODS PDF

Row height changes with use of symbols in ODS PDF

Re: Catch unexpected quotes in external code and recover program

Catch unexpected quotes in external code and recover program

Import data from MS access/Excel while retaining special characters

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

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

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

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

Re: Row height changes with use of symbols in ODS PDF

Re: Row height changes with use of symbols in ODS PDF

Re: Row height changes with use of symbols in ODS PDF

Row height changes with use of symbols in ODS PDF

Re: Catch unexpected quotes in external code and recover program

Catch unexpected quotes in external code and recover program

Re: ODS PDF: suppress left and right margin around table frame

Re: ODS PDF: suppress left and right margin around table frame

ODS PDF: suppress left and right margin around table frame

Re: ODS PDF: dynamic column width

ODS PDF: dynamic column width