Hi, I have data for 2 different years - 2008 and 2016 - on whether people living in a particular community use different substances such as alcohol, tobacco etc (yes/no variable coded as 0=No, 1=Yes). Have (raw data):   data WORK.RAW_DATA(label='raw_data dataset written by Stat/Transfer Ver. 11.2.2106.0521 '); infile datalines dsd truncover; input Community_name:$1. Year:32. Alcohol_use:32. Tobacco_use:32. Marijuana_use:32.; datalines4; A,2008,1,1,0 A,2008,1,1,1 A,2008,1,0,1 A,2008,1,1,1 A,2008,1,1,1 A,2008,0,0,1 A,2008,0,0,1 A,2008,1,0,0 A,2008,0,1,0 A,2008,1,1,1 A,2008,0,0,1 A,2008,0,1,1 A,2008,0,1,1 A,2008,0,0,0 A,2008,1,1,1 A,2008,1,1,0 A,2008,1,1,1 A,2008,0,0,0 A,2008,0,1,1 A,2008,1,1,1 A,2016,1,0,0 A,2016,1,0,1 A,2016,0,0,0 A,2016,0,0,0 A,2016,1,1,0 A,2016,1,1,1 A,2016,1,1,1 A,2016,0,0,0 A,2016,0,0,0 A,2016,0,1,0 A,2016,0,0,1 A,2016,1,1,1 A,2016,0,1,1 A,2016,0,1,1 A,2016,0,0,0 A,2016,1,1,1 A,2016,0,0,0 A,2016,1,1,1 A,2016,0,0,0 A,2016,1,1,1 A,2016,1,0,1 A,2016,0,1,0 A,2016,0,0,0 A,2016,0,0,0 A,2016,0,1,0 ;;;;   I am using chi-square to analyze the data for each community using the following code in SAS 9.4: proc freq data=raw_data; table year * alcohol_use year*tobacco_use year*marijuana_use/ nopercent nocolumn chisq; run;   The results are attached. I am interested in the freq count and row percentages for the yes responses coded "1" in 2008 and 2016, and predicted probability of chi-square value (highlighted in the resutls). Is there a way to export just the highlighted results to an excel file instead of having to manually enter the numbers or copy/paste for all the outcomes?   Want (summary statistics): Outcome 2008count 2008percent 2016count 2016percent prob Alcohol_use 12 57.14 10 40.00 0.2463 Tobacco_use 14 66.67 12 48.00 0.2033 Marijuana_use 15 71.43 11 44.00 0.0616   Any suggestions? Thank you. ... View more

I have a dataset that contains policy violations by students. The type of violation is coded from 1 to 40. Some students have only one violation while others have up to 13 violations. I am trying to get a frequency count across variables for the different types of violations that have occurred. Dataset Have id violation1 violation2 violation3 violation4 violation5 A1 1 2 6 A2 5 3 1 1 3 A3 7 1 4 1 5 A4 2 8 1 2 A5 1 7 2 8 6 Output Want Violation_type frequency 1 7 2 4 3 2 4 1 5 2 6 2 7 2 8 2 Thanks in advance! ... View more

Hi, I have a dataset that lists various ways a student has been contacted by the school. I want to create a separate variable called “personal” which includes only those methods that have the word “personal” in them. I used a if find () then syntax to create separate columns for personal phone call and personal letter and then used catt function to combine then into one variable “personal.” Is there a more efficient way to get this done? Thank you. Data Have ID Method1 Method2 Method3 1 Text Email Personal phone call 2 Email Personal letter 3 Personal letter Personal phone call Text 4 Email Text Data Want ID Method1 Method2 Method3 Personal 1 Text Email Personal phone call Personal phone call 2 Email Personal letter Personal letter 3 Personal letter Personal phone call Text Personal letter Personal phone call 4 Email Text ... View more

Hi, I am working with a long dataset consisting of school policy violation by students, The variables of interest for this question are: id incident_number incident_type sanction. I need to modify the dataset to create a new variable consult_sanction that consists of sanctions related to CONSULT (for instance, 00 Education – CONSULT Alcohol 1, 00 Education – CONSULT Drugs1). Data Have id incident_number incident_type sanction 1 2221 Alcohol Parent Letter 1 2221 Alcohol 00 Education – CONSULT Alcohol 1 1 2346 Drugs 00 Education – CONSULT Drugs 1 2 2799 Academic Dishonesty 00 Education – Reflection paper 2 2811 Harassment Documentation only 3 2851 Marijuana Parent Letter 3 2851 Marijuana 00 Education – CONSULT Mari1 3 3214 Marijuana Parent Letter 3 3214 Marijuana 00 Education – CONSULT Mari2 3 3378 Reckless Endangerment Probation Data Want id incident_number incident_type sanction consult_Sanction 1 2221 Alcohol Parent Letter 1 2221 Alcohol 00 Education – CONSULT Alcohol 1 00 Education – CONSULT Alcohol 1 1 2346 Drugs 00 Education – CONSULT Drugs 1 00 Education – CONSULT Drugs 1 2 2799 Academic Dishonesty 00 Education – Reflection paper 2 2811 Harassment Documentation only 3 2851 Marijuana Parent Letter 3 2851 Marijuana 00 Education – CONSULT Mari1 00 Education – CONSULT Mari1 3 3214 Marijuana Parent Letter 3 3214 Marijuana 00 Education – CONSULT Mari2 00 Education – CONSULT Mari2 3 3378 Reckless Endangerment Probation Thank you for your help! ... View more

Hi, I have two datasets in long format that have variables “ID” and “incident_number” in common. Each person has a unique ID number but two or more people can have the same incident_number if they violate school policy together (for example, both of them engaged in underage drinking at the same party; so the underage drinking at the party would count as one incident). If DatasetB doesn’t have a matching ID and incident number with DatasetA, I want to delete unmatched cases in DatasetB. So, I want to select cases based on a combination of ID and incident number. Is there a way to modify DatasetB in this way? Have DatasetA: ID Incident_number VarA VarB 1 56789 Abcd 1232 1 56789 Erfsdjdgr 94847 2 64908 Fakjsdf;asie 5342 2 56789 Sajfldkjsa;ljf 54698734 3 78621 Kjdafjdh 0589576 4 78621 afsdfasdkljfa 1154 4 78721 Fsafd 987888 Have DatasetB: ID Incident_number VarX VarY 1 56789 56789 galdjfoia 1 56789 56789 sadjfakhd 1 56818 56818 weoiatlk 2 56789 124363 Abjdkafh 2 64826 5463 Giagaojdfl 3 78629 1545744654 Ajfu 3 78799 1265841 Fkajhdfajh 4 78621 9378464 Nadfaei 4 79725 5486513541 Lirueoi 9 79102 23756 Nann 12 80215 987543 Ueyrf Want new_DatasetB ID Incident VarX VarY 1 56789 56789 galdjfoia 1 56789 56789 sadjfakhd 2 56789 124363 Abjdkafh 4 78621 9378464 Nadfaei Thank you for your help. ... View more

Hi, I have two datasets in long format that have a variable “ID” in common. If DatasetB doesn’t have a matching ID with DatasetA, I want to delete unmatched cases in DatasetB. Is there any way to do this without merging the two datasets? Have DatasetA: ID VarA VarB 1 Abcd 1232 1 Erfsdjdgr 94847 2 Fakjsdf;asie 5342 3 Kjdafjdh 0589576 3 Hfajdhfdh 143 Have DatasetB: ID VarX VarY 2 124363 Abjdkafh 2 5463 Giagaojdfl 3 9378464 Nadfaei 5 23756 Nann 6 987543 Ueyrf 7 625364 Qodiafe Want new_DatasetB ID VarX VarY 2 124363 Abjdkafh 2 5463 Giagaojdfl 3 9378464 Nadfaei Thank you for your help! ... View more