<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: proc glimmix for meta-analysis in Statistical Procedures</title>
    <link>https://communities.sas.com/t5/Statistical-Procedures/proc-glimmix-for-meta-analysis/m-p/514679#M26273</link>
    <description>&lt;P&gt;Looks like you might want:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;proc sql;
create table counts as
select 
    id, 
    shortIPI, 
    sum(case when PTB="yes" then count else . end) as PTB_yes,
    sum(count) as PTB_all
from meta
group by id, shortIPI;
quit;

proc glimmix data=counts;
class id shortIPI;
model PTB_yes/PTB_all = shortIPI / solution;
random intercept / subject=id;
run;&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;or maybe&amp;nbsp;exchange the roles of&amp;nbsp; &lt;EM&gt;PTB&lt;/EM&gt; and &lt;EM&gt;shortIPI&lt;/EM&gt;.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 20 Nov 2018 06:06:07 GMT</pubDate>
    <dc:creator>PGStats</dc:creator>
    <dc:date>2018-11-20T06:06:07Z</dc:date>
    <item>
      <title>proc glimmix for meta-analysis</title>
      <link>https://communities.sas.com/t5/Statistical-Procedures/proc-glimmix-for-meta-analysis/m-p/514664#M26272</link>
      <description>&lt;P&gt;I am trying to conduct a meta-analysis and I have binary variables, so I am attempting to use proc glimmix to accomplish this. When I try, it keeps giving me errors about the variables.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Here is my code and dataset:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;data meta;&lt;BR /&gt;input ID $ shortIPI $ PTB $ Count @@;&lt;BR /&gt;datalines;&lt;BR /&gt;study1 yes yes 815&amp;nbsp; study1 yes no 20998&lt;BR /&gt;study1 no yes 899&amp;nbsp; study1 no no 23972&lt;BR /&gt;study2 yes yes 6395&amp;nbsp; study2 yes no 48072&lt;BR /&gt;study2 no yes 2338 &amp;nbsp;study2 no no 22276&lt;BR /&gt;study3 yes yes 416&amp;nbsp; study3 yes no 2893&lt;BR /&gt;study3 no yes 1291&amp;nbsp; study3 no no 12434&lt;BR /&gt;;&lt;BR /&gt;proc print data=meta;&lt;BR /&gt;run;&lt;BR /&gt;proc freq data=meta;&lt;BR /&gt;tables shortIPI*PTB / chisq;&lt;BR /&gt;weight count;&lt;BR /&gt;run;&lt;BR /&gt;proc freq data=meta;&lt;BR /&gt;table ID*shortIPI*PTB /cmh;&lt;BR /&gt;weight count;&lt;BR /&gt;run;&lt;BR /&gt;proc means data=meta mean q1 median q3 var stddev;&lt;BR /&gt;run;&lt;BR /&gt;&lt;STRONG&gt;proc glimmix data=meta;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;class ID shortIPI PTB;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;model shortIPI/count = count / solution;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;random intercept / subject=ID;&lt;/STRONG&gt;&lt;BR /&gt;&lt;STRONG&gt;run;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Here is the error code I keep seeing:&lt;/P&gt;&lt;P&gt;Error: A character response variable is not possible for the chosen distribution. Only for BINARY and&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; MULTINOMIAL distributions are character response variables permitted.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;which I am guessing means I have to merge the binary variable with my count somehow?&lt;/P&gt;</description>
      <pubDate>Tue, 20 Nov 2018 17:21:54 GMT</pubDate>
      <guid>https://communities.sas.com/t5/Statistical-Procedures/proc-glimmix-for-meta-analysis/m-p/514664#M26272</guid>
      <dc:creator>taylor_metz1</dc:creator>
      <dc:date>2018-11-20T17:21:54Z</dc:date>
    </item>
    <item>
      <title>Re: proc glimmix for meta-analysis</title>
      <link>https://communities.sas.com/t5/Statistical-Procedures/proc-glimmix-for-meta-analysis/m-p/514679#M26273</link>
      <description>&lt;P&gt;Looks like you might want:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;proc sql;
create table counts as
select 
    id, 
    shortIPI, 
    sum(case when PTB="yes" then count else . end) as PTB_yes,
    sum(count) as PTB_all
from meta
group by id, shortIPI;
quit;

proc glimmix data=counts;
class id shortIPI;
model PTB_yes/PTB_all = shortIPI / solution;
random intercept / subject=id;
run;&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;or maybe&amp;nbsp;exchange the roles of&amp;nbsp; &lt;EM&gt;PTB&lt;/EM&gt; and &lt;EM&gt;shortIPI&lt;/EM&gt;.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 20 Nov 2018 06:06:07 GMT</pubDate>
      <guid>https://communities.sas.com/t5/Statistical-Procedures/proc-glimmix-for-meta-analysis/m-p/514679#M26273</guid>
      <dc:creator>PGStats</dc:creator>
      <dc:date>2018-11-20T06:06:07Z</dc:date>
    </item>
  </channel>
</rss>

