Hello,    I am using a csv to generate variable lists in macros so I can run code through the rows of the csv.    When I run the code below I get a syntax error on all the references to &&event_num_&i.. It's weird because the macro seems to be resolving correctly. The log shows the correct values (in the screenshot the event_num = 5), but there is this extra space which causes the syntax error (see screenshot).      %macro dashboard;  %do i=1 %to &max.; proc sql noprint;  create table &&event_type_&i.._&&event_num_&i.._complete as  select "Completed RCQI" as cat, count(*) as N_&&event_num_&i.. from input&&event_type_&i...&&event_type_&i.._&&event_num_&i.;  quit; %end;  %mend dashboard;  %dashboard;        ... View more

Hello,   I'm encountering inconsistencies in results between Type 3 Tests of Fixed Effects and pairwise comparisons when using proc mixed.   My dataset consists of 5 subjects, each measured at 3 different time points. There are 15 observations in total.   I'm fitting a linear mixed-effects model to examine mean value differences among three groups. The Type 3 Test indicates a significant difference among at least one pair of groups (P-value = 0.0028), but none of the pairwise comparisons show significance (their p-values are 0.2096, 0.7895, and 0.8126). This discrepancy is puzzling to me.   For the variance-covariance structure, I've chosen the UN over CS and TOEP based on assumptions and AIC, but this inconsistency is specific to UN only and not observed with CS or TOEP.   Below is my SAS code. Any insights into this issue would be greatly appreciated!   proc mixed data=data plots=residualpanel; class id group; model outcome = group / s cl residual; repeated group / subject=id type=UN r rcorr; lsmeans group / cl diff; run;   Thank you!! ... View more

Hi.  I'm trying to configure the email options to send email through sendgrid.  It uses and API key.  Below are the options I have set, but I can only get SAS to respond with "ERROR: Login Failure" and "ERROR: Email server did not respond" What do I need to tweak in the settings to get it to connect? options emailsys=SMTP emailhost=("smtp.sendgrid.net" STARTTLS) emailport=25 emailid="YXBpa2V5 <notices@bcservicescommercialcollections.com>" EMAILAUTHPROTOCOL=login EMAILPW='U0cuOHl0RlZVRHJRWXU2QTVSeUczelppUS4xFaRlZ2dXBpd3dZZG5J'; ... View more

In today’s post, we'll take a look at how to interpret the results of a logistic regression model built in SAS Viya. In my third post of this series, I showed you just how easy it was to build a logistic model in SAS Visual Statistics. I also discussed the origins of regression models along with the details of logistic regression. Moving forward we will continue to focus on the part of the AI and Analytics lifecycle that involves developing and interpreting robust models. Specifically, let’s examine the various pieces of output from the logistic regression model that was built using variable annuity (insurance product) data.   Remember, the business challenge is trying to identify customers who are likely to respond to a variable annuity marketing campaign and make a purchase. The develop_final table that was introduced previously contains just over 32,000 banking customers. The input variables reflect both demographic information as well as product usage captured over a three-month period. The target variable is named Ins which is a binary variable. ... View more

In the output method for the hash package, how do I specify overwrite? (is it even possible?). For example, the following code runs fine the first time:   proc ds2; data _null_; dcl char(20) USUBJID; dcl char(8) VSTESTCD; dcl char(20) VISIT; dcl char(30) VSTPT; dcl double rc; dcl package hash hw(); method init(); hw.ordered('a'); hw.keys([USUBJID VSTESTCD VISIT VSTPT]); hw.dataset(%tslit({select * from sdtm.vs where VSTESTCD in ('HEIGHT','WEIGHT')})); hw.definedone(); end; method term(); rc = hw.output('testtest5'); end; enddata; run; quit; However if I run again the dataset that hw.output tries to use produces an error since it already exists.   Thanks ... View more