About Santoshrk

Santoshrk · ‎11-05-2022

I need the column headers look like in the screenshot above

Santoshrk · ‎11-05-2022

I tried both the ways but it is not working. Please let me know if I miss anything. screenshot fo the code attached

Santoshrk · ‎11-04-2022

Hi Team, I'm using the below code to get the label in 2 lines. But for some reason the the text is not splitting into next line. Any Help much appreciated. example: "Placebo" in first line and "n/N(Response rate)" in the second line sidebar / align = top; layout lattice / rows = 2 columns = 2 columnweights = preferred; entry halign = left "Placebo(*ESC*)/n/N(Response rate)"/ textattrs = (weight = bold); entry halign = left "DRUG_A(*ESC*)/n/N(Response rate)"/ textattrs = (weight = bold); endlayout; endsidebar;

Santoshrk · ‎05-12-2021

Hi, Is there any way in SAS to identify and remove blank pages in RTF with the SAS program? I have a file with more than 100 pages, So it is hard to check each page manually every time when I rerun the output. Any input is much appreciated! Thank You, Regards, Santhosh

Santoshrk · ‎02-17-2021

Thanks KurtBremser for your inputs on this.

Santoshrk · ‎02-17-2021

It is possible to Restrict Editing RTF files manually. Please provide some thoughts on doing it programmatically. Generally, when we develop a report using the tool, it is obvious that we need to add some protection to the output file to restrict editing by others. I'm sure there will be a way to do it, but couldn't able to find anything online. Thank you!

Santoshrk · ‎02-16-2021

Hi, How to set the editing restrictions for the Word document programmatically using SAS? The aim is to enable the Read-Only mode but set the password to restrict the editing. I'm using the below code to set the read-only attributes but would like to protect them with a password. x attrib -r ".\xyz.RTF" ; *Removes Read Only Attribute ; %report; x attrib +r ".\xyz.RTF" ; *Adds Read Only Attribute; Any inputs are much appreciated. Thanks and Regards, Santhosh

Santoshrk · ‎01-26-2021

Can we add any program to send an automatic notification (through the SAS system) to another user to "close" the dataset, when we are trying to refresh them from our end? Just curious to know about this possibility, instead of sending an email to the entire team and asking to close the dataset, if we can push some message to the target user/users, that would solve the issue more efficient way.

Santoshrk · ‎01-25-2021

x attrib -r "&filepath.\t-eg.rtf" ; *Removes Read Only attribute; %dorpt; *Proc Report macro; x attrib +r "&filepath.\t-eg.rtf" ; *Enables Read Only attribute; With the help of X command, I'm able to update the files(.rtf) in Windows environment when they are open as ReadOnly mode at another user.

Santoshrk · ‎01-25-2021

analyst

Santoshrk · ‎01-25-2021

@Kurt_Bremser Thanks for sharing this info, It's interesting to know. At my workplace, we have only Windows setup. Is it completely impossible on the Windows evnvironment? Because we have multiple teams at different locations. So, we have been requesting the teams to close the datasets several times a day before refreshing them. I'm okay to recreate the dataset and do some workaround if there is a way in Windows Environment.

Santoshrk · ‎01-25-2021

I'm using Windows SAS. Need solution on this same OS. 🙂

Santoshrk · ‎01-25-2021

Hi, I would like to rerun and update the dataset 'eg' when another user has it open. To achieve this task, I have created eg.SAS7BDAT dataset in the library called 'test' and set the password to the dataset with the proc datasets option as below. But, when I'm trying to refresh the dataset (when another user has it open), it is throwing lock is not available message as below. ERROR: A lock is not available for TEST.EG.DATA. is there any way to overcome this issue? Any help is much appreciated. (Sample code that I'm trying is below) proc datasets memtype = data library = test nolist; modify eg (write = dummy/ alter = dummy/); *Removes the password dummy; run; quit; data test.eg; set final; run; proc datasets memtype = data library = test pw = vrtx nolist; modify eg (write = dummy alter = dummy); *Set the password dummy; run; quit;

Santoshrk · ‎01-14-2021

Thanks, Cynthia,

Santoshrk · ‎01-14-2021

Hi Team, I have converted the RTF document to PDF format. I have encountered an issue with the PDF display. Line truncating as above while printing it. After enabling the Fit to window width option in pdf, the display changes as expected and below. Can you please suggest a way to fix this issue programmatically? Is there any option to “enable Fit to window width” programmatically or permanent fix? Thank you and looking forward to the solution. Regards, Santhosh Karra M: 6503389608

Online Status	Offline
Date Last Visited	‎08-24-2024 01:25 PM

Re: PROC TEMPLATE QUESTION to split the label into 2 lines

Re: PROC TEMPLATE QUESTION to split the label into 2 lines

PROC TEMPLATE QUESTION to split the label into 2 lines

Identify and Remove Blank Pages in RTF File

Re: How to set editing restrictions for the Word document programmatic...

Re: How to set editing restrictions for the Word document programmatic...

How to set editing restrictions for the Word document programmatically...

Re: Rerun and update the SAS dataset when another user has it open

Re: Rerun and update the SAS dataset when another user has it open

Re: Rerun and update the SAS dataset when another user has it open

Re: how to run VBA macro through SAS

Re: Rerun and update the SAS dataset when another user has it open

Re: Rerun and update the SAS dataset when another user has it open

Re: Rerun and update the SAS dataset when another user has it open

Re: Rerun and update the SAS dataset when another user has it open

Re: PROC TEMPLATE QUESTION to split the label into 2 lines

Re: PROC TEMPLATE QUESTION to split the label into 2 lines

PROC TEMPLATE QUESTION to split the label into 2 lines

Identify and Remove Blank Pages in RTF File

Re: How to set editing restrictions for the Word document programmatic...

Re: How to set editing restrictions for the Word document programmatic...

How to set editing restrictions for the Word document programmatically...

Re: Rerun and update the SAS dataset when another user has it open

Re: Rerun and update the SAS dataset when another user has it open

Re: Rerun and update the SAS dataset when another user has it open

Re: Rerun and update the SAS dataset when another user has it open

Re: Rerun and update the SAS dataset when another user has it open

Rerun and update the SAS dataset when another user has it open

Re: Headline truncation while converting RTF to PDF file

Headline truncation while converting RTF to PDF file