cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
stjsmith
‎01-22-2025
  • 4 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Help interpreting Proc Mixed output with three way interaction term

by Fluorite | Level 6 in Statistical Procedures
‎01-22-2025 01:24 PM
‎01-22-2025 01:24 PM
Hello, I am having trouble interpreting the estimates and slopes from proc mixed output with a three way interaction term. I have a treatment variable indicator (treatment = 1, comparison = 0), Time indicator variable (0,1,2). Respondents are categorized into one of four regions (North Central, Pacific, Southern, and Southwest) Picture of output: Output in table format: Solution for Fixed Effects Effect Campus Treatment Estimate Standard DF t Value Pr > |t| Error Intercept     3.8495 0.1521 1129 25.3 <.0001 Treatment   0 0.123 0.03584 1129 3.43 0.0006 Treatment   1 0 . . . . Time     0.04476 0.02467 1129 1.81 0.0699 Campus North Central   -0.03694 0.051 1129 -0.72 0.469 Campus Pacific   0.01366 0.05097 1129 0.27 0.7887 Campus Southern   -0.01249 0.05062 1129 -0.25 0.8052 Campus Southwest   0 . . . . Time*Treatment*Campus North Central 0 -0.06649 0.03482 1129 -1.91 0.0564 Time*Treatment*Campus Pacific 0 -0.08515 0.03452 1129 -2.47 0.0138 Time*Treatment*Campus Southern 0 -0.05736 0.03452 1129 -1.66 0.0969 Time*Treatment*Campus Southwest 0 -0.04947 0.037 1129 -1.34 0.1814 Time*Treatment*Campus North Central 1 -0.06978 0.03345 1129 -2.09 0.0372 Time*Treatment*Campus Pacific 1 -0.01768 0.03392 1129 -0.52 0.6023 Time*Treatment*Campus Southern 1 -0.01683 0.03286 1129 -0.51 0.6086 Time*Treatment*Campus Southwest 1 0 . . . .   This is my interpretation, is this correct: The estimate for the NORTH CENTRAL treatment group's intercept is 3.813 (3.8495 + (-0.03694)) The estimate for the PACIFIC treatment group's intercept is 3.863 (3.8495 + 0.01366) The estimate for the SOUTHERN treatment group's intercept is 3.837 (3.8495 + (-0.01249)) The estimate for the SOUTHWEST treatment group's intercept is 3.850 (simply the intercept)   The estimate for the NORTH CENTRAL comparison group's intercept is 3.936 (3.8495 + (-0.03694) +0.123) The estimate for the PACIFIC comparison group's intercept is 3.986 (3.8495 + 0.01366 + 0.123) The estimate for the SOUTHERN comparison group's intercept is 3.960 (3.8495 + (-0.01249) + 0.123) The estimate for the SOUTHWEST comparison group's intercept is 3.973 (3.8495 + 0.123)   The estimate for the NORTH CENTRAL treatment group's slope is -0.02502 (0.04476 + (-0.06978)) The estimate for the PACIFIC treatment group's slope is 0.02708 (0.04476 + (-0.01768)) The estimate for the SOUTHERN treatment group's slope is 0.02793 (0.04476 + (-0.01683)) The estimate for the SOUTHWEST treatment group's slope is 0.04476 (simply the time variable)   The estimate for the NORTH CENTRAL comparison group's slope is -0.02173 (0.04476 + (-0.06649)) The estimate for the PACIFIC comparison group's slope is -0.04039 (0.04476 + (-0.08515)) The estimate for the SOUTHERN comparison group's slope is -0.0126 (0.04476 + (-0.05736)) The estimate for the SOUTHWEST comparison group's slope is -0.00471 (0.04476 +-0.04947)   My interpretation was based of this SAS resource: https://support.sas.com/documentation/cdl/en/statug/66103/HTML/default/viewer.htm#statug_mixed_examples02.htm   Thank you! ... View more

Re: How to use loops/array to create a indicator variable by group?

by Fluorite | Level 6 in SAS Programming
‎06-13-2023 06:07 PM
‎06-13-2023 06:07 PM
Thank you Tom, this was very helpful. ... View more

Re: How to use loops/array to create a indicator variable by group?

by Fluorite | Level 6 in SAS Programming
‎06-12-2023 07:49 PM
‎06-12-2023 07:49 PM
Hi, Thanks for your response.  Just to clarify the team variable is not based only on Round_project variable. The 'team' variable is meant to group people that had the same project ID for that specific round. In the original message of what I would like the team variable to look like, Participant 1387 and Participant 1406 were in the same project (2020-01-2102) for Round 1A and they were in the same project (2020-01-2133) for Round 1B. Thus they are a team. Two other participants (#1371 and 1389) were both in a different project (2020-01-2103) in Round 1A and then their next project was in Round 3A, thus they are on a different team then participants #1387 and #1406. I apologize if this is confusing.  ... View more

How to use loops/array to create a indicator variable by group?

by Fluorite | Level 6 in SAS Programming
‎06-12-2023 07:10 PM
‎06-12-2023 07:10 PM
Hi all, I have a data set which contains information on participants that were a part of projects for multiple rounds. The variables include: ParticipantID - Participant ID, because participants are in multiple rounds, there are multiple rows for each participant. Round_Project - Indicates the round the project was in (i.e. Round_1A_Project_ID indicates Round 1 Project 1, Round_1B_Project_ID  indicates Round 1 Project 2, Round_2A_Project_ID  indicates Round 2 Project 1) There are a total of 4 rounds, with up to three different projects per round. Project_ID - gives the specific project ID   I would like to construct a new variable (I would name it 'Team') that groups the participants based on the same ProjectID and Round. For example I would want to know the best way to construct the 'Team' variable such as this: ParticipantID Round_Project Project_ID Team 1387 Round_1A_Project_ID 2020-01-2102 1 1406 Round_1A_Project_ID 2020-01-2102 1 1387 Round_1B_Project_ID 2020-01-2133 1 1406 Round_1B_Project_ID 2020-01-2133 1 1387 Round_1C_Project_ID 2020-01-2136 1 1406 Round_1C_Project_ID 2020-01-2136 1 1387 Round_3A_Project_ID 2020-01-2310 1 1406 Round_3A_Project_ID 2020-01-2310 1 1371 Round_1A_Project_ID 2020-01-2103 2 1389 Round_1A_Project_ID 2020-01-2103 2 1371 Round_3A_Project_ID 2020-01-2311 2 1389 Round_3A_Project_ID 2020-01-2311 2 1371 Round_3B_Project_ID 2020-01-2304 2 1389 Round_3B_Project_ID 2020-01-2304 2 1385 Round_1A_Project_ID 2020-01-2104 3 1414 Round_1A_Project_ID 2020-01-2104 3 1429 Round_1A_Project_ID 2020-01-2104 3 1385 Round_2A_Project_ID 2020-01-2217 3 1414 Round_2A_Project_ID 2020-01-2217 3 1429 Round_2A_Project_ID 2020-01-2217 3   Code for the original data. data SASHELP; input ParticipantID:32. Round_Project:$20. Project_ID:$20.; datalines; 1387 Round_1A_Project_ID 2020-01-2102 1406 Round_1A_Project_ID 2020-01-2102 1387 Round_1B_Project_ID 2020-01-2133 1406 Round_1B_Project_ID 2020-01-2133 1387 Round_1C_Project_ID 2020-01-2136 1406 Round_1C_Project_ID 2020-01-2136 1387 Round_3A_Project_ID 2020-01-2310 1406 Round_3A_Project_ID 2020-01-2310 1371 Round_1A_Project_ID 2020-01-2103 1389 Round_1A_Project_ID 2020-01-2103 1371 Round_3A_Project_ID 2020-01-2311 1389 Round_3A_Project_ID 2020-01-2311 1371 Round_3B_Project_ID 2020-01-2304 1389 Round_3B_Project_ID 2020-01-2304 1385 Round_1A_Project_ID 2020-01-2104 1414 Round_1A_Project_ID 2020-01-2104 1429 Round_1A_Project_ID 2020-01-2104 1385 Round_2A_Project_ID 2020-01-2217 1414 Round_2A_Project_ID 2020-01-2217 1429 Round_2A_Project_ID 2020-01-2217 ;;;;   I was advised that it may be possible to do this with loops, but any solution is welcome. Thank you! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-22-2025 05:00 PM
Likes given to
View All
Quick links