Hi, Can we calculate minimum detectable effect size for a cluster randomise trial(cRCT)? I have the following situation. A two arm cRCT with 20 clusters in each arm, average cluster size is 30 (SD=20). Power=80%, Alpha=0.05. Proportion of outcome in the control group is 65%. What difference in the outcome between the 2 arms I can estimate from this study? Bayzid ... View more

I'm creating my own cas actions, and the result is as expected except that the loc function sometimes returns -1 despite the stripped value should be found in the stripped lookup table. I've created a simplified version of my challenge leaving only the cas actions result part with the loc functionality.     Here is the link to the documentation. https://documentation.sas.com/doc/en/pgmsascdc/v_062/proccas/p01s21os7idn2ln1aaefthmtjqru.htm    %let namer=ts; %let namer2=a123456789b123456789c123456789; %let namer3=a123456789b123456789c123456789d1; data casuser.cars; set sashelp.cars; format &namer &namer2 datetime20. ; &namer=intnx('dtminutes', datetime(), rand('integer', -1000, 0)); &namer2=&namer; &namer3=put(rand('uniform', 0, 1), best12.); run; %let casy=cars; %let liby=casuser; cas mySession sessopts=(caslib="&liby"); ods escapechar='^'; proc cas; table.columninfo result=r /table="&casy"; columns = ''; search_cols=''; do i = 1 to r.columninfo.nrows; if index(UPCASE(r['columninfo'][i,7]), 'DATETIME') THEN do; symput('col', ifc(prxmatch('m/\s/i',r[1,i].column), '''||r[1,i].column||''n', r[1,i].column)); columns = columns||' '||symget('col'); search_cols = strip(search_cols||'|'||symget('col')); end; end; symput('ok_list', substrn(search_cols,2,length(search_cols)-1)); symput('varlist', substrn(columns,2,length(columns)-1)); print "&ok_list."; run; simple.summary result=sumres / subset={'min', 'max'}, table="&casy"; sumlist=findtable(sumres); do k=1 to dim(sumres.summary); print quote(sumres.summary[k, 1]); end; simple.distinct result=dist / table="&casy"; do l=1 to dim(dist.distinct); print quote(dist.distinct[l, 1]); end; run; do i=1 to dim(dist.distinct); if prxmatch(cats('m/\b', symget('ok_list'), '\b/i'), strip(dist.distinct[i, 1])) then do; help=strip(dist.distinct[i, 1]); print quote(help); j=loc(sumlist, 'column', help); if j<1 then do; help=dist.distinct[i, 1]; print quote(help); j=loc(sumlist, 'column', help); end; print j; end; end; run; And the log shows the problem:     The loc function does not return a value for the variable 'ts'n because the distinct action returns a wider width for the column name than the summary action.    @BrunoMueller to the rescue 🙂       ... View more

Using the SAS Deployment Manager to manage your SAS 9.4 deployment is relatively straightforward. The documentation is comprehensive and the prompts in the application are self-explanatory. Still, there’s always something new to learn in the unlikeliest of places. In this post I’ll be going through some of the SAS Deployment Manager functions I used in the creation of the Implementing Grid Manager on SAS 9.4M8 workshop. We’ll cover the basics of these functions, then I’ll throw in some tips, tricks, or different ways you could use them to accomplish your SAS deployment goals. ... View more

Hello! I have a string values in a dataset that I would like to cleanup so there's only one space between each word.   There are some cases where there's two spaces so it's creating a separate value. Here's an example: The first one has multiple spaces between "IT" and  "INC", whereas the second one just has one space (desired). I've researched trim, strip, compress - having trouble finding the solution. Thanks! P.S I'm using Enterprise Guide ... View more