Hi folks,
We have 9.4 M6 installed on Linux server. We use a horizontal web cluster for the middle tier. We need to disable/remove two of the clusters. The main web cluster remains.
There is an easy way to disable or remove a web cluster?
Regards,
... View more
Hi, I wish to send email to multiple people from the dataset. Dataset contains Name and email address. I should send each of them with Hi Name, with message body. In actual data around 100 email is present and sample data sharing below I have tried below method but getting an error data Employee;
input Name $ Email :$30.;
datalines;
John John@xyz.com
david david@xyz.com
Joe joe@xyz.com
;
%macro sendreports(name,email);
filename outbox email;
data _null_;
file outbox
to= ("&email")
subject="Test subject"
file outbox;
put "Dear &name.,";
put "Thank you";
run;
%mend Sendreports;
data _null_;
Set Employee;
call execute(cats('%sendreports(',email,',',name,')'));
run; Please guide me to do it. @Kurt_Bremser @Ksharp @Tom @yabwon @PaigeMiller
... View more
Hello! Here's my problem: I tried to upgrade from SAS M7 to SAS M8 but somehow SAS/CONNECT did not install even tough it was included in the License file. I really don't know what the problem is and hoped I could find some help here among you. This is the SAS products listed in the License file: *PRODNUM000 = BASE Base SAS; *PRODNUM001 = STAT SAS/STAT; *PRODNUM002 = GRAPH SAS/GRAPH; *PRODNUM007 = IML SAS/IML; *PRODNUM015 = CONNECT SAS/CONNECT; *PRODNUM075 = INTTECHSRV SAS Integration Technologies; Also after the installation we tried to install SAS/CONNECT manually be starting SAS Deployment Wizard and choosing the option to add components. But it's not listed among components that we can add. The only one remotely resembling SAS CONNECT is SAS CONNECT Driver for Java. For any other information that could help anyone reading this please respond and I will provide whatever is necessary. Thank you!
... View more
Hi, I'm trying to add a contents table in a rtf file. As I saw in other discussions and examples, the code is something like: "ods rtf file="myfolder\Table_X.rtf" style=Journalvs CONTENTS toc_data;" Everything fine, and in the rtf output, the table of contents is created and when I update the field, the contents appear. The problem is about the headers and footnotes. I have defined this headers and footnotes for the entire document, and I change it in each report, but, the TOC seems to be in a separated section of the document, and these titles are not populated. How can I add them? Also, and this is minnor at this time, I would like to know how to change the font size of the TOC elements, I tryied with proc template, but with any change.. The code: options orientation=landscape replace center nodate nonumber ;
ODS LISTING CLOSE;
ods ESCAPECHAR='^';
Title1 J=l "Study 1" J=R "Page ^{thispage} of ^{lastpage}";
Footnote1 J=L " myself";
ods rtf file="myfolder\Table_X.rtf" style=Journalvs CONTENTS toc_data;
title2 J=l "Table 1. Baseline and disease categorical characteristics.";
Footnote1 j=l "P-values obtained from Fisher exact test(*) or simulated MC Fisher test (#).; NA: Not apply.";
Footnote2 J=L " myself";
ODS PROCLABEL=' ';
proc report data=tmp.cats contents='Table 1' center style(report)={just=center} style(header)=[background=white bordercolor=black borderbottomwidth=0.1pt vjust=center] nowd split="@" style(column)=[bordercolor=white];
column order_1 order_2 order_3 col1 col2;
column order_1 order_2 order_3 col1 col2;
define order_1 / order noprint;
define order_2 / order noprint;
define order_3 / order noprint;
define col1 / display "Group" left style(column)=[cellwidth=10% asis=on];
define col2 / display "Parameter" left style(column)=[cellwidth=15% asis=on] style(header)=[bordertopwidth=0pt];
compute before order_2 / style=[just=l font_face=Courier font_size=8pt font_weight=bold foreground=black background=white];
line j=l " ";
endcomp;
compute before order_2 / style=[just=l font_face=Courier font_size=8pt font_weight=bold foreground=black background=white];
line j=l " ";
endcomp;
break after order_1 / page contents=' ';
break before order_1 / page contents=' ';
run;
title2 J=l "Table 2.";
Footnote1 j=l "P-values obtained from t-test of equal or unequal (**) variances.; NA: Not apply.";
Footnote2 J=L "myself";
ODS PROCLABEL=' ';
proc report data=tmp.conts contents='Table 2' center style(report)={just=center} style(header)=[background=white bordercolor=black borderbottomwidth=0.1pt vjust=center] nowd split="@" style(column)=[bordercolor=white];
column order_1 order_2 order_3 col1 col2;
define order_1 / order noprint;
define order_2 / order noprint;
define order_3 / order noprint;
define col1 / display "Group" left style(column)=[cellwidth=10% asis=on];
define col2 / display "Parameter" left style(column)=[cellwidth=15% asis=on] style(header)=[bordertopwidth=0pt];
compute before order_2 / style=[just=l font_face=Courier font_size=8pt font_weight=bold foreground=black background=white];
line j=l " ";
endcomp;
break after order_1 / page contents=' ';
break before order_1 / page contents=' ';
run;
ods rtf close;
ods html close;
ods listing;
... View more
I have got the SAS re-installed in my personal laptop. Earlier when I used to open a new file whether it is a SAS data file or a SAS code, they used to open in separate windows. However, now when I open any kind of SAS files, all the files get clubbed under one window and within the process flow as shown in the attached screenshot. This makes it quite difficult to see these different files separately or at the same time. Could anyone please help me resolve this issue? Thanks
... View more