topic Re: Percentages in New SAS User https://communities.sas.com/t5/New-SAS-User/Percentages/m-p/696904#M25306 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/355707">@Jonas3007</a>&nbsp;wrote:<BR /> <P>Hello,&nbsp;</P> <P>I have a few questions (Completely new to SAS) I have the following table.</P> <P>&nbsp;</P> <TABLE> <TBODY> <TR> <TD> <P>&nbsp;</P> </TD> <TD> <P>Outcome</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> <TR> <TD> <P>Treatment</P> </TD> <TD> <P>Recurring UTI</P> </TD> <TD> <P>No new UTI</P> </TD> <TD> <P>Total</P> </TD> </TR> <TR> <TD> <P>Cranberry Juice</P> </TD> <TD> <P>8</P> </TD> <TD> <P>42</P> </TD> <TD> <P>50</P> </TD> </TR> <TR> <TD> <P>Lactobacillus drink</P> </TD> <TD> <P>19</P> </TD> <TD> <P>30</P> </TD> <TD> <P>49</P> </TD> </TR> <TR> <TD> <P>Control</P> </TD> <TD> <P>18</P> </TD> <TD> <P>32</P> </TD> <TD> <P>50</P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>1. Question about percentages.&nbsp;I need to convert each value into their respective percentages and get the chi-square. what would be the steps to create this table in SAS (exactly as it shows) and then make the same table but showing the values in percentages? I tried using proc freq but it just shows me the percentage of the total column.</P> <P>2. from this table, how can I get the chi-square?</P> <P>3. Finally, how do I make a graph to compare these percents?</P> <P>&nbsp;</P> <P>Thank you!</P> <HR /></BLOCKQUOTE> <P>Whenever you discuss percentage you <STRONG>must</STRONG> define what the denominator and numerator are for the calculation. Which you don't do. So, what are the denominators and numerators.</P> <P>&nbsp;</P> <P>Without an actual data set it is hard to write code.</P> <P>Without seeing the code you attempted we have no idea what may or may not have been done.</P> <P>And many people new to SAS whose "training" came from working with spreadsheets often have separate variables (columns, rows) such as "recurring" and "new" instead of a single variable possibly named "outcome" with two levels of values.</P> <P>&nbsp;</P> <P>Can you provide an example of your data? Either in the form of a data step or at least proc print or similar output?</P> <P>&nbsp;</P> Thu, 05 Nov 2020 15:31:39 GMT ballardw 2020-11-05T15:31:39Z Percentages https://communities.sas.com/t5/New-SAS-User/Percentages/m-p/696891#M25304 <P>Hello,&nbsp;</P><P>I have a few questions (Completely new to SAS) I have the following table.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>&nbsp;</P></TD><TD><P>Outcome</P></TD><TD><P>&nbsp;</P></TD></TR><TR><TD><P>Treatment</P></TD><TD><P>Recurring UTI</P></TD><TD><P>No new UTI</P></TD><TD><P>Total</P></TD></TR><TR><TD><P>Cranberry Juice</P></TD><TD><P>8</P></TD><TD><P>42</P></TD><TD><P>50</P></TD></TR><TR><TD><P>Lactobacillus drink</P></TD><TD><P>19</P></TD><TD><P>30</P></TD><TD><P>49</P></TD></TR><TR><TD><P>Control</P></TD><TD><P>18</P></TD><TD><P>32</P></TD><TD><P>50</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>1. Question about percentages.&nbsp;I need to convert each value into their respective percentages and get the chi-square. what would be the steps to create this table in SAS (exactly as it shows) and then make the same table but showing the values in percentages? I tried using proc freq but it just shows me the percentage of the total column.</P><P>2. from this table, how can I get the chi-square?</P><P>3. Finally, how do I make a graph to compare these percents?</P><P>&nbsp;</P><P>Thank you!</P> Thu, 05 Nov 2020 14:49:33 GMT https://communities.sas.com/t5/New-SAS-User/Percentages/m-p/696891#M25304 Jonas3007 2020-11-05T14:49:33Z Re: Percentages https://communities.sas.com/t5/New-SAS-User/Percentages/m-p/696904#M25306 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/355707">@Jonas3007</a>&nbsp;wrote:<BR /> <P>Hello,&nbsp;</P> <P>I have a few questions (Completely new to SAS) I have the following table.</P> <P>&nbsp;</P> <TABLE> <TBODY> <TR> <TD> <P>&nbsp;</P> </TD> <TD> <P>Outcome</P> </TD> <TD> <P>&nbsp;</P> </TD> </TR> <TR> <TD> <P>Treatment</P> </TD> <TD> <P>Recurring UTI</P> </TD> <TD> <P>No new UTI</P> </TD> <TD> <P>Total</P> </TD> </TR> <TR> <TD> <P>Cranberry Juice</P> </TD> <TD> <P>8</P> </TD> <TD> <P>42</P> </TD> <TD> <P>50</P> </TD> </TR> <TR> <TD> <P>Lactobacillus drink</P> </TD> <TD> <P>19</P> </TD> <TD> <P>30</P> </TD> <TD> <P>49</P> </TD> </TR> <TR> <TD> <P>Control</P> </TD> <TD> <P>18</P> </TD> <TD> <P>32</P> </TD> <TD> <P>50</P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>1. Question about percentages.&nbsp;I need to convert each value into their respective percentages and get the chi-square. what would be the steps to create this table in SAS (exactly as it shows) and then make the same table but showing the values in percentages? I tried using proc freq but it just shows me the percentage of the total column.</P> <P>2. from this table, how can I get the chi-square?</P> <P>3. Finally, how do I make a graph to compare these percents?</P> <P>&nbsp;</P> <P>Thank you!</P> <HR /></BLOCKQUOTE> <P>Whenever you discuss percentage you <STRONG>must</STRONG> define what the denominator and numerator are for the calculation. Which you don't do. So, what are the denominators and numerators.</P> <P>&nbsp;</P> <P>Without an actual data set it is hard to write code.</P> <P>Without seeing the code you attempted we have no idea what may or may not have been done.</P> <P>And many people new to SAS whose "training" came from working with spreadsheets often have separate variables (columns, rows) such as "recurring" and "new" instead of a single variable possibly named "outcome" with two levels of values.</P> <P>&nbsp;</P> <P>Can you provide an example of your data? Either in the form of a data step or at least proc print or similar output?</P> <P>&nbsp;</P> Thu, 05 Nov 2020 15:31:39 GMT https://communities.sas.com/t5/New-SAS-User/Percentages/m-p/696904#M25306 ballardw 2020-11-05T15:31:39Z