topic Re: YRBS DATA in New SAS User

topic Re: YRBS DATA in New SAS User https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606851#M17455 <P>use variable <STRONG>race</STRONG> instead <STRONG>r</STRONG><STRONG>aceet </STRONG> in proc corr.</P> Sun, 24 Nov 2019 23:11:59 GMT Shmuel 2019-11-24T23:11:59Z YRBS DATA https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606836#M17450 <P>1229 proc corr data = yrbs2017;</P><P>1230 var age raceeth sex grade cigarette vaping;</P><P>ERROR: Variable RACEETH in list does not match type prescribed for this list.</P><P>1231 run;</P><P> </P><P>Getting this error message when using<BR />YRBS Data trying to code for Race/Ethnicity</P> Sun, 24 Nov 2019 20:44:37 GMT https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606836#M17450 dfamu1989 2019-11-24T20:44:37Z Re: YRBS DATA https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606847#M17453 <P>Variable RACEETH must be character. You will need to convert it to a number, otherwise it can't be involved in correlation calculations.</P> Sun, 24 Nov 2019 22:26:24 GMT https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606847#M17453 PGStats 2019-11-24T22:26:24Z Re: YRBS DATA https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606849#M17454 <P><FONT face="Courier New" size="2">race=</FONT><FONT color="#800080" face="Courier New" size="2">" "</FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> raceeth = </FONT><FONT color="#800080" face="Courier New" size="2">"Am Indian/ Alaska Native"</FONT><FONT face="Courier New" size="2"> and raceeth =</FONT><FONT color="#800080" face="Courier New" size="2">"Asian"</FONT><FONT face="Courier New" size="2"> and raceeth</FONT></P><P><FONT face="Courier New" size="2">=</FONT><FONT color="#800080" face="Courier New" size="2">"Native Hawaiian/other Pl"</FONT><FONT face="Courier New" size="2"> and raceeth =</FONT><FONT color="#800080" face="Courier New" size="2">"Multiple-Non-Hispanic"</FONT></P><P><FONT face="Courier New" size="2">and raceeth= </FONT><FONT color="#800080" face="Courier New" size="2">" Multiple - Hispanic"</FONT> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> race = </FONT><FONT color="#800080" face="Courier New" size="2">"1"</FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Raceeth = </FONT><FONT color="#800080" face="Courier New" size="2">"White"</FONT> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> race = </FONT><FONT color="#800080" face="Courier New" size="2">"2"</FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Raceeth= </FONT><FONT color="#800080" face="Courier New" size="2">"Black"</FONT> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> race= </FONT><FONT color="#800080" face="Courier New" size="2">"3"</FONT><FONT face="Courier New" size="2">;</FONT></P><P> </P><P>/* 1= other, 2=White, 3=black*/</P><P> </P><P> </P><P>(This is how I Have it coded)</P> Sun, 24 Nov 2019 22:45:27 GMT https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606849#M17454 dfamu1989 2019-11-24T22:45:27Z Re: YRBS DATA https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606851#M17455 <P>use variable <STRONG>race</STRONG> instead <STRONG>r</STRONG><STRONG>aceet </STRONG> in proc corr.</P> Sun, 24 Nov 2019 23:11:59 GMT https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606851#M17455 Shmuel 2019-11-24T23:11:59Z Re: YRBS DATA https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606853#M17456 <P>When I replace it race I still got a error message.</P><P>603 proc corr data = yrbs2017;</P><P>604 var age race sex grade cigarette vaping;</P><P>ERROR: Variable race in list does not match type prescribed for this list.</P><P>605 run;</P> Sun, 24 Nov 2019 23:22:53 GMT https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606853#M17456 dfamu1989 2019-11-24T23:22:53Z Re: YRBS DATA https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606854#M17457 How do you convert a character to a number Sun, 24 Nov 2019 23:24:12 GMT https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606854#M17457 dfamu1989 2019-11-24T23:24:12Z Re: YRBS DATA https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606855#M17458 <P><FONT color="#000080" face="Courier New" size="2"><STRONG>data</STRONG></FONT><FONT face="Courier New" size="2"> yrbs2017;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">set</FONT><FONT face="Courier New" size="2"> DATAOUT.YRBS2017;</FONT></P><P><FONT face="Courier New" size="2">Sex=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">.</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q2=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">1</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> sex=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">1</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q2=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">2</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> sex=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">0</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P> </P><P>/* 1=female, 2=male*/</P><P><FONT face="Courier New" size="2">race=</FONT><FONT color="#800080" face="Courier New" size="2">" "</FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> raceeth = </FONT><FONT color="#800080" face="Courier New" size="2">"Am Indian/ Alaska Native"</FONT><FONT face="Courier New" size="2"> and raceeth =</FONT><FONT color="#800080" face="Courier New" size="2">"Asian"</FONT><FONT face="Courier New" size="2"> and raceeth</FONT></P><P><FONT face="Courier New" size="2">=</FONT><FONT color="#800080" face="Courier New" size="2">"Native Hawaiian/other Pl"</FONT><FONT face="Courier New" size="2"> and raceeth =</FONT><FONT color="#800080" face="Courier New" size="2">"Multiple-Non-Hispanic"</FONT></P><P><FONT face="Courier New" size="2">and raceeth= </FONT><FONT color="#800080" face="Courier New" size="2">" Multiple - Hispanic"</FONT> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> race = </FONT><FONT color="#800080" face="Courier New" size="2">"1"</FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Raceeth = </FONT><FONT color="#800080" face="Courier New" size="2">"White"</FONT> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> race = </FONT><FONT color="#800080" face="Courier New" size="2">"2"</FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Raceeth= </FONT><FONT color="#800080" face="Courier New" size="2">"Black"</FONT> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> race= </FONT><FONT color="#800080" face="Courier New" size="2">"3"</FONT><FONT face="Courier New" size="2">;</FONT></P><P> </P><P>/* 1= other, 2=White, 3=black*/</P><P><FONT face="Courier New" size="2">age=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">.</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q1=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">1</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> age=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">1</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q1=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">2</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> age=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">2</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q1=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">3</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> age=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">3</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q1=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">4</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> age=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">4</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q1=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">5</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> age=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">5</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q1=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">6</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> age=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">6</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q1=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">7</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> age=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">7</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT face="Courier New" size="2">grade=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">.</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q3=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">1</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> grade=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">1</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q3=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">2</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> grade=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">2</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q3=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">3</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> grade=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">3</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q3=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">4</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> grade=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">4</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT face="Courier New" size="2">cigarette=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">.</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q30=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">1</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> cigarette=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">0</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q30=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">2</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> cigarette=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">1</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P> </P><P>/* 0=cigarette use, 1=no cigarette use*/</P><P><FONT face="Courier New" size="2">vaping=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">.</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q34=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">1</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> vaping=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">0</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Q34=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">2</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> vaping=</FONT><STRONG><FONT color="#008080" face="Courier New" size="2">1</FONT></STRONG><FONT face="Courier New" size="2">;</FONT><STRONG><FONT color="#000080" face="Courier New" size="2">run</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P> </P><P>/* 0=vaping, 1=no vaping*/</P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>proc</STRONG></FONT> <STRONG><FONT color="#000080" face="Courier New" size="2">freq</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">data</FONT><FONT face="Courier New" size="2">=yrbs2017;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">tables</FONT><FONT face="Courier New" size="2"> age raceeth sex grade cigarette vaping;</FONT></P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>run</STRONG></FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>proc</STRONG></FONT> <STRONG><FONT color="#000080" face="Courier New" size="2">freq</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">data</FONT><FONT face="Courier New" size="2">=yrbs2017;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">tables</FONT><FONT face="Courier New" size="2"> vaping* age/ </FONT><FONT color="#0000ff" face="Courier New" size="2">chisq</FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>run</STRONG></FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>proc</STRONG></FONT> <STRONG><FONT color="#000080" face="Courier New" size="2">freq</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">data</FONT><FONT face="Courier New" size="2">=yrbs2017;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">tables</FONT><FONT face="Courier New" size="2"> vaping* raceeth/ </FONT><FONT color="#0000ff" face="Courier New" size="2">chisq</FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>run</STRONG></FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>proc</STRONG></FONT> <STRONG><FONT color="#000080" face="Courier New" size="2">freq</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">data</FONT><FONT face="Courier New" size="2">=yrbs2017;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">tables</FONT><FONT face="Courier New" size="2"> vaping* cigarette/ </FONT><FONT color="#0000ff" face="Courier New" size="2">chisq</FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>run</STRONG></FONT><FONT face="Courier New" size="2">;</FONT></P><P> </P><P>　</P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>proc</STRONG></FONT> <STRONG><FONT color="#000080" face="Courier New" size="2">freq</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">data</FONT><FONT face="Courier New" size="2">=yrbs2017;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">tables</FONT><FONT face="Courier New" size="2"> cigarette* vaping/ </FONT><FONT color="#0000ff" face="Courier New" size="2">chisq</FONT><FONT face="Courier New" size="2">;</FONT></P><P><FONT color="#000080" face="Courier New" size="2"><STRONG>run</STRONG></FONT><FONT face="Courier New" size="2">;</FONT></P><P><STRONG><FONT color="#000080" face="Courier New" size="2">proc</FONT></STRONG> <STRONG><FONT color="#000080" face="Courier New" size="2">corr</FONT></STRONG> <FONT color="#0000ff" face="Courier New" size="2">data</FONT><FONT face="Courier New" size="2"> = yrbs2017;</FONT></P><P><FONT color="#0000ff" face="Courier New" size="2">var</FONT><FONT face="Courier New" size="2"> age race sex grade cigarette vaping;</FONT></P><P><STRONG><FONT color="#000080" face="Courier New" size="2">run</FONT></STRONG><FONT face="Courier New" size="2">;</FONT></P><P> </P> Sun, 24 Nov 2019 23:26:51 GMT https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606855#M17458 dfamu1989 2019-11-24T23:26:51Z Re: YRBS DATA https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606862#M17459 <P>dfamu,</P> <P>Taking an excerpt from your code...</P> <P> </P> <P>Change the resulting coding from character to numeric i.e. change "1", "2", "3" to 1, 2, 3</P> <PRE><CODE class=" language-sas">*...; if raceeth = "Am Indian/ Alaska Native" and raceeth ="Asian" and raceeth ="Native Hawaiian/other Pl" and raceeth ="Multiple-Non-Hispanic" and raceeth= " Multiple - Hispanic" then race = 1; if Raceeth = "White" then race = 2; if Raceeth= "Black" then race= 3; *...;</CODE></PRE> <P>-unison</P> Mon, 25 Nov 2019 01:37:45 GMT https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606862#M17459 unison 2019-11-25T01:37:45Z Re: YRBS DATA https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606874#M17460 <P>It's a straightforward programming task to convert a character variable race to a numeric variable.  But it is not quite as simple an analysis task.  In your case, you have 3 levels, not 2, which will not provide the information you want to get in proc corr.  Should you convert white/black/multiple-Hispanic to 0/1/2 or to  1/2/0, or …… or to 2/1/0 (6 possible combinations)?  Each would give a different value in the correlation matrix.  You would get three different positive values and their 3 negatives. The problem is how to interpret a correlation coefficient intended for linear variables (of which binary is a subset here) to a 3-category variable.</P> <P> </P> <P>I presume you could make two dummy variables  (white/black  and white/multiple,  or black/while and black/multiple …).  Then you would have two directly interpretable correlation coefficients.   However, I leave it to more authoritative respondents to better explain my observation.  </P> Mon, 25 Nov 2019 04:32:47 GMT https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/606874#M17460 mkeintz 2019-11-25T04:32:47Z Re: YRBS DATA https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/607030#M17487 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/301012">@dfamu1989</a> wrote:<BR /> <P> </P> <P>/* 1=female, 2=male*/</P> <P><FONT face="Courier New" size="2">race=</FONT><FONT color="#800080" face="Courier New" size="2">" "</FONT><FONT face="Courier New" size="2">;</FONT></P> <P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> raceeth = </FONT><FONT color="#800080" face="Courier New" size="2">"Am Indian/ Alaska Native"</FONT><FONT face="Courier New" size="2"> and raceeth =</FONT><FONT color="#800080" face="Courier New" size="2">"Asian"</FONT><FONT face="Courier New" size="2"> and raceeth</FONT></P> <P><FONT face="Courier New" size="2">=</FONT><FONT color="#800080" face="Courier New" size="2">"Native Hawaiian/other Pl"</FONT><FONT face="Courier New" size="2"> and raceeth =</FONT><FONT color="#800080" face="Courier New" size="2">"Multiple-Non-Hispanic"</FONT></P> <P><FONT face="Courier New" size="2">and raceeth= </FONT><FONT color="#800080" face="Courier New" size="2">" Multiple - Hispanic"</FONT> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> race = </FONT><FONT color="#800080" face="Courier New" size="2">"1"</FONT><FONT face="Courier New" size="2">;</FONT></P> <P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Raceeth = </FONT><FONT color="#800080" face="Courier New" size="2">"White"</FONT> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> race = </FONT><FONT color="#800080" face="Courier New" size="2">"2"</FONT><FONT face="Courier New" size="2">;</FONT></P> <P><FONT color="#0000ff" face="Courier New" size="2">if</FONT><FONT face="Courier New" size="2"> Raceeth= </FONT><FONT color="#800080" face="Courier New" size="2">"Black"</FONT> <FONT color="#0000ff" face="Courier New" size="2">then</FONT><FONT face="Courier New" size="2"> race= </FONT><FONT color="#800080" face="Courier New" size="2">"3"</FONT><FONT face="Courier New" size="2">;</FONT></P> <P> </P> <P> </P> </BLOCKQUOTE> <P>First to have a variable to use in Proc Corr it must be numeric. The statement race=" "; means that you just created a CHARACTER variable. So get rid of:<FONT face="Courier New" size="2">race=</FONT><FONT color="#800080" face="Courier New" size="2">" "</FONT><FONT face="Courier New" size="2">;</FONT></P> <P><FONT face="Courier New" size="2">Second you explicitly assign character values "1" "2" and "3", which again are not what you want.</FONT></P> <P> </P> <P>And then third the logic in</P> <PRE>if raceeth = "Am Indian/ Alaska Native" and raceeth ="Asian" and raceeth ="Native Hawaiian/other Pl" and raceeth ="Multiple-Non-Hispanic" and raceeth= " Multiple - Hispanic" then race = 1; </PRE> <P>Is NEVER going to be true. One person from your data cannot have any multiple values of Raceth. So instead of AND you would want OR</P> <PRE>if raceeth = "Am Indian/ Alaska Native" or raceeth ="Asian" or raceeth ="Native Hawaiian/other Pl" or raceeth ="Multiple-Non-Hispanic" or raceeth= " Multiple - Hispanic" then race = 1; </PRE> <P>SAS has a comparison operator called IN to compare a single variable to a list of values to use instead of a stack of OR statements:</P> <PRE>if raceeth in( "Am Indian/ Alaska Native" "Asian" "Native Hawaiian/other Pl" "Multiple-Non-Hispanic" " Multiple - Hispanic" )then race = 1; </PRE> <P>I am not sure but I believe that you may also have a typo in <FONT color="#800080" face="Courier New" size="2">"Native Hawaiian/other Pl" </FONT><FONT color="#000000">I suspect that instead of a lower case L that you should have an upper case I at the end:  <FONT color="#800080" face="Courier New" size="2">"Native Hawaiian/other PI"</FONT></FONT></P> <P> </P> Mon, 25 Nov 2019 16:13:14 GMT https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/607030#M17487 ballardw 2019-11-25T16:13:14Z Re: YRBS DATA https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/607147#M17509 <P>IT WORKED!!!!! THANKS SO MUCHHHHH</P> Mon, 25 Nov 2019 23:41:22 GMT https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/607147#M17509 dfamu1989 2019-11-25T23:41:22Z Re: YRBS DATA https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/607150#M17510 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/301012">@dfamu1989</a> wrote:<BR /> <P>IT WORKED!!!!! THANKS SO MUCHHHHH</P> <HR /></BLOCKQUOTE> <P>Nice.</P> <P> </P> <P>Now for some possibly less than good news: You may want to talk with someone about the structure of the YRBS data sets and weighting. The YRBS typically is a complex sample design and if you use Proc Corr with the weights you are not correctly applying the sample design information and can get misleading results from Proc Corr..</P> Tue, 26 Nov 2019 00:01:13 GMT https://communities.sas.com/t5/New-SAS-User/YRBS-DATA/m-p/607150#M17510 ballardw 2019-11-26T00:01:13Z