Email Configuration in CI360 Part 1. Email Opt-Outs
Recent Library Articles
Recently in the SAS Community Library: This post by @ADAMPOLLACCHI is the first in a two part series that covers some recent changes to email configuration in SAS Customer Intelligence 360. This post addresses amendments to the email opt-out options.
Hi there,
I am exploring encrypt=true option in JDBC URL in SAS JVM's for example SASServer1_1.
I am using below option in server.xml file but it fails to start.
url="jdbc:oracle:thin:@server:port/servicename" encrypt="true" user="EVMSID" .
we are not licensed to SAS ACCESS interface to JDBC, so, question here is , is JDBC connections are secure apart from relying on drivers?
How to set other security properties in JDBC URL's in SAS server.xml files?
Thanks in Advance,
Sandeep
... View more
We need to extract data from z/os mainframe. We are able to download the datasets. However, data looks unreadable.
Here is the code we are using
%let PROD_UX=ram189prd.gwd.grpinf.net 5668; %let MF=PROD_UX; signon &MF. user="abcd" password="welcome2sas"; libname rwork slibref=work server=PROD_UX; rsubmit &MF.; data test2x /*view=test2x*/;
infile "PZLN.VMO00.POL1501" dsd; input @1 KEY $8. @9 STATUS1 $1. @10 STATUS2 $1. @19 RECTIME $8. @27 CKEY $13. @40 RECADTE $8. @48 RECATME $8. @56 CERTRTRN $1. @57 MEDDIABC $1. ; run; endrsubmit;
Dataset is generated , however it looks like this
����
R
�
��� ���
M240N24021201
�N������
������
�
� ����
Q
A
13:08:17
M240N24021201
Y
� ����
A
M
13:08:17
M240N24021201
N
� ����
Q
A
13:08:17
M240N24021201
��*D50
00000000
0
� ����
R
�
��� ���
K620S36102402
�N������
������
�
� ����
P
A
09:14:34
K620S36102402
N
� ����
A
M
09:14:34
K620S36102402
N
� ����
A
M
09:14:34
K620S36102402
N
Here is Proc contents output
Data Set Name
RWORK.TEST2X
Observations
304317
Member Type
DATA
Variables
9
Engine
REMOTE9
Indexes
0
Created
02/04/2025 04:57:48
Observation Length
49
Last Modified
02/04/2025 04:57:48
Deleted Observations
0
Protection
Compressed
NO
Data Set Type
Sorted
NO
Label
Data Representation
MVS_32
Encoding
open_ed-1146 United Kingdom (OpenEdition)
I am running the code on SAS Studio. How do i encode this dataset in readable format. Any help is appreciated
... View more
I have data on the severity of weed pressure for an agricultural study with a factorial, RCBD. The weed pressure variable is the area in square footage within a plot where weeds were measured to be above a certain height. It is an atypical metric for weediness, and I have not been able to find anything in the literature like it, so I'm unsure of how to analyze this data.
The raw, untransformed variable "Area_Weed", in units of square feet, exhibits right-skewness. A few of the observations are zero. The histogram is shown below:
One approach that I've tried is to convert the response variable "Area_Weed", in square feet, to a proportion of weed area divided by total plot area, the apply an arcsine transformation. The residuals plot exhibits non-constant variance. The code and residuals are shown below:
proc glimmix data=df plots=studentpanel method=rspl;
class Trt_Amend_App Trt_CC Block;
model Area_Weed_PROP_ANG = Trt_Amend_App | Trt_CC / ddfm=kr2;
random Block;
run;
Considering an alternative distribution for the untransformed response variable "Area_Weed", which is positive and right-skewed, the gamma distribution seems promising, aside from the fact that it can't accommodate zeros in the data. If I apply a transformation of adding a small constant (+1) then I can get the model to run using PROC GENMOD, with the caveat that I can't include the variable "Block" as a random effect.
proc genmod data=df plots=all;
class Trt_Amend_App Trt_CC Block;
model Area_Weed_PLUS = Trt_Amend_App | Trt_CC / dist=gamma link=log;
ods output ParameterEstimates=pe;
output out=outmean pred=mu;
run;
My questions amount to the following:
Based on what I've presented here, is the gamma distribution appropriate for my response variable, which is positive, right-skewed, and includes a few zeros?
If I use PROC GENMOD and a gamma distribution to model, how might I go about evaluating the residual plots? What might be a good option for the parameter plots aside from "all"?
If I attempt to incorporate Block as a random effect using PROC GLIMMIX, the model does not converge. How can I address this issue?
Thank you for reading. Please let me know if I can provide any other information.
... View more
I have a user who wants to suppress the automatic 'idx' bookmarks created by proc report when writing to a document using ODS RTF. Is this possible?
... View more
I am using this code within ods rtf. I want my chart/image on the left with no header and my table on the right of the chart. Tried a few things but I either get a massive header or my column is too small for the image. data summary; length Average $10 Maximum $10; Average="&avg"; Maximum="&max."; run; data x; set summary; x=' ';output; run; title; proc report data=x nowd style={outputwidth=100% cellspacing=0 cellpadding=1}; column x Average Maximum; define x/display "" style={cellwidth=3in cellheight=3in}; define Average/display "Average amount" style={cellwidth=1in cellheight=0.5in} style(header)={cellwidth=1in cellheight=0.5in foreground=white background=CX002B49}; define Maximum/display "Maximum amount" style={cellwidth=1in cellheight=0.5in} style(header)={cellwidth=1in cellheight=0.5in foreground=white background=CX002B49}; compute x; call define('x','style','style={ preimage="&report_loc.\max.png" bordertopcolor=white borderbottomcolor=white borderrightcolor=white borderleftcolor=white}'); endcomp; run;
... View more
Four days of inspiring keynotes, product reveals, hands-on learning opportunities, deep-dive demos, and peer-led breakouts. Don't miss out, May 6-9, in Orlando, Florida.
Nominations are in, and the SAS Customer Recognition Awards voting is complete! Winners get a full trip to SAS Innovate (May 6-9) in Orlando, FL! See the 60+ inspiring entries from SAS users! Winners will be announced at SAS Innovate!