Recent content by sarav1981

Hi Khfor2007, Try using the "Thousands_separator" option of the EXCEL XP Tagset. It would apply the separator specified after every thousand-th value for Numeric values. Your code should look similar to this: ODS TAGSETS.EXCELXP Options(sheetname='xxxx'...

Reg. the previous code, remove the extra semicolon in the PROC FORMAT statement (before the RUN statement). Sarav

Hi nobyrnes, You Macro should be written as %macro R061_Key_Summary_output_Subseg(Datain=, Dataout=, Seg=, Subseg=, Provider=&ProviderText, ReportDateText=); Data &Datain; Set &Datain; PROC FORMAT; VALUE picture p8r low - < 5 = '0009.99%' 5 - high = '0009%'; ; run...

Hi Sasshelp, I did not get your question completely, but I will have a jab at it anyway. If you want the week to be computed as the week of the year, try using the WEEK function in SAS. The syntax would be: week(<sas_date>,<modifier>). You can look up more on this function using SAS help and...

Hi Khfor2007, You can remove the display of a report item which has a missing or zero value using the NOZERO option in the define statement of the PROC REPORT. Alter your PROC REPORT statement by adding this option on the item PD as shown below. proc report data=p2005 nowindows missing...

Tomahawk, A small modification to the original macro code would also resolve your error. %global dt_end; %macro add_months(dt_ini, nr_months); %let orig_year = %sysevalf((&dt_ini)/100, int); %let orig_month = %sysfunc(mod(&dt_ini, 100)); %let add_years = %sysevalf(&nr_months/12...

Hi All, I am new to UNIX. I use IBM AIX 5.3 at work. I was wondering a way to send emails accross using UNIX. I am aware of the basic syntax using mailx -s <email addresses> to send emails. But, I would like to know if there is a way to control the recipients using TO, CC and BCC statements in...

Hi All, I am running SAS software on IBM AIX 5.3 platform. I am trying to send an email from SAS using the E-mail access device installed on AIX when I get the following error. ERROR: Unable to connect to SMTP server. ERROR: connect call failed, system error is 'A remote host refused an...

Hi Chris, Thanks for the post. Will try my luck with the UNIX grp. Sarav

Hi all, I am in the process of writing an UNIX shell script (korn and I use AIX) to run a SAS code on the admin account on an UNIX server. I want the code to do these set of actions: a. Look for the code to run in the specified directory. b. If the code is not present in that directory, it...

Hi Chris, Thanks for your response and valuable insights. I will certainly try to dig a bit reg. this issue and let you know. I have in the past seen the issue with EXCEL abt the leading zeros getting truncated in the O/P. Your fix worked great!!!. Thanks again for your help. Sarav

Hi, I was wondering if the EXCEL XP Tagset can be used to hide certain columns of a dataset akin to hiding certain columns in EXCEL. I appreciate any suggestions as to accomplish this. Thanks, Sarav

Hi Chris, I had encountered this problem before and I was wondering what the round about was. Thanks to you, you seem to be going great guns on the EXCEL Tagset. May be this time they wud name the tagset after you :) Sarav

Hi All, I have this huge text expression which when I try to read into SAS, i get an error saying that the expression exceeded the max allowable text expression length and has been truncated. ERROR: The text expression length (65540) exceeds maximum length (65534). The text expression has been...

Hi Chris, I have run into another problem in my EXCEL report generation. I am using EXCEL XP Tagset to generate multi-tabbed EXCEL workbooks. I was requested by my manager to explore the ability of SAS producing protection enabled EXCEL workbooks. Say, there are 10 tabs in the EXCEL workbook...