Search results for query: *

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...

Hi Chris, Yes...you will be famous and deserve to be :) I also forwarded your Formula suggestion to Chevell Parker at SAS Institute. I gave you credit (but only as Chris from Tek-Tips Forum :)) Looking forward to your experiments with the tagset and even more opportunities for you to be...

Hi Chris, Thanks a lot. The problem was I was using version 28 of the EXCEL XP Tagset and I was unable to find the syntax you were mentioning in your second post. I find that the Jan 2006 version 31 of the EXCEL XP Tagset bears this syntax that you are pointing to. Sarav

Hi Chris, I need your suggestion regarding EXCEL XP Tagsets again. I wud like to word wrap all rows in the EXCEL O/P, what changes if any shud I make to the Tagset definition to obtain that? Thanks in advance for your help. Sarav

Hi All, I think u guys may know this very well. If you need to control u r SAS statements based on the operating environment you are working on the SAS automatic variables, SYSSCP & SYSSCPL wud be the ones to use. Both, SYSSCP and SYSSCPL resolve to an abbreviation of the name of your...

Hi Chris, I am very much in US. To be more precise in NYC. Thanks a lot for your insights into the tagset problem and u r helpful suggestions. We have been using the EXCEL Tagset for abt 8 months now and we have seen some very interesting changes in them. I am glad to see that you are adding...