Example dataset:
DATA OPPOSITN;
INPUT ID O1-O7 T1-T7 SCOLMER SCOLPER;
CARDS;
1000 2 0 1 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 15
1001 2 1 2 0 5 1 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 6
1003 4 2 0 0 0 0 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 14 12
1004 4 0 1 0 . . 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 13
1005 5 9 3 4 4 3 3 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 9
1007 8 10 2 0 1 2 2 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 7 16
1008 1 2 0 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 7
1009 1 0 1 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 16 20
1011 3 1 0 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 20
1012 4 2 2 3 6 . 6 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 12
1013 4 2 0 0 . 2 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 7 7
1014 5 7 10 4 4 6 2 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 12
1016 4 2 0 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 12
1017 7 4 3 6 3 4 5 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 6 5
1018 5 2 1 6 2 . . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 14 11
1020 5 2 6 0 0 . . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 10
1021 7 1 1 . 0 4 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 13 17
1022 7 3 2 1 1 0 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 14
1023 5 1 2 1 4 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 5 7
1024 5 4 4 0 . 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 13 21
1026 3 0 0 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 17 18
1027 6 5 9 3 2 2 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 8
1100 0 10 2 5 2 3 4 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 3 9
1101 5 2 0 6 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 11
1102 0 1 4 4 2 . 3 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 12
1103 2 . 3 0 1 . 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 11
1104 0 2 2 3 1 0 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 7
1106 2 3 6 3 1 0 4 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 14 12
1107 2 0 2 0 2 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 13 12
1110 0 2 2 6 5 0 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 14 14
1113 0 0 0 0 5 1 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 11
1115 0 6 6 5 2 . . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 6
1116 1 2 6 3 3 2 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 8
1117 0 2 3 1 1 3 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 11
1119 0 0 0 6 2 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 6
1120 0 0 0 1 3 . 3 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 11
1121 0 4 7 6 3 6 5 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 6
1122 0 2 5 1 0 0 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 9
1123 2 8 8 7 8 8 8 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 8
1124 0 1 1 2 3 0 2 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 3 1
1125 0 9 5 2 7 0 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 3 11
1126 0 0 0 3 5 0 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 7 11
1127 0 . 2 7 2 2 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 10
1200 1 3 4 0 0 2 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 9
1201 0 0 1 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 16
1202 2 6 5 0 4 1 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 12
1204 0 0 3 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 7 12
1205 2 4 3 6 2 5 3 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 12
1206 0 0 2 0 1 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 12
1207 0 0 0 4 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 14 12
1208 4 0 1 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 10
1209 3 0 2 2 0 1 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 12
1210 1 1 6 5 0 1 8 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 6 6
1211 0 0 3 1 1 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 10
1212 0 5 5 1 2 0 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 8 11
1213 1 6 3 4 1 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 7 12
1214 0 0 4 3 . 3 2 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 7 7
1216 0 1 3 0 0 1 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 12
1217 2 6 7 2 1 1 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 11
1219 0 0 0 2 1 0 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 10
1221 1 2 3 0 . . . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 8 3
1222 0 0 2 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 10
1223 0 1 0 0 0 0 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 12
1225 4 2 5 2 3 1 4 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 7 9
1226 1 5 0 0 . 5 2 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 8 10
1227 0 1 4 4 1 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 7 12
1300 9 8 5 8 7 4 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 5 12
1302 7 6 7 7 4 2 6 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 8
1400 0 1 0 0 0 1 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 15 15
1401 1 1 0 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 15 15
1402 0 0 0 0 0 0 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 15
1404 3 0 1 1 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 10
1405 2 0 0 0 0 0 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 10
1406 3 0 2 3 0 0 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 7
1407 1 2 3 1 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 13 6
1408 1 1 1 1 0 0 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 9
1409 2 1 2 0 0 0 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 8 10
1410 3 0 1 1 0 0 2 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 6 2
1500 0 5 3 1 2 0 2 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 10
1501 1 0 0 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 10
1502 2 0 1 0 1 0 5 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 17 15
1504 4 . . 1 2 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 11
1505 3 6 9 4 0 5 9 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 5
1506 1 1 . 0 1 1 3 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 14
1600 7 3 3 2 5 0 3 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 11
1601 2 . 4 0 0 1 3 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 10
1602 0 1 0 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 6 7
1604 0 0 0 0 0 1 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 14 19
1605 2 2 4 5 3 2 3 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 12
1606 5 6 2 4 1 8 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 14 12
1607 8 5 6 6 1 0 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 12
1700 1 2 2 5 1 0 3 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 11
1702 8 4 1 6 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 11
1704 10 1 2 3 . 1 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 12
1705 0 0 0 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 8 12
1706 0 3 0 0 0 1 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 12
1708 0 0 0 0 1 0 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 7 11
1709 0 0 0 0 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 9
1711 1 2 3 2 8 3 7 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 10
1714 0 0 0 0 0 0 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 7
1715 1 0 1 0 0 3 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 12
1716 1 2 5 0 0 0 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 13 15
1717 1 1 6 6 2 1 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 15 12
1719 2 1 . 1 3 2 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 11
1720 5 3 2 0 2 2 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 6 7
1723 1 8 2 4 . 3 8 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 3 7
1724 0 0 0 1 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 7 10
1725 5 1 0 0 0 0 2 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 14 18
1726 7 9 3 6 . . . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 14
1727 1 . 3 2 0 0 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 5 7
1728 2 0 0 0 4 1 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 10
1729 3 4 1 0 0 . . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 13 11
1731 4 3 1 0 0 2 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 17
1732 0 2 2 1 0 2 2 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 11
1733 3 0 2 2 3 6 4 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 5 9
1734 1 0 0 0 0 0 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 10 11
1735 3 1 3 3 3 0 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 9
1737 5 0 0 2 2 3 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 10
1739 2 3 0 0 5 1 . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 9
2000 2 1 3 1 1 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 11
2001 1 3 1 0 . . 2 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 12
2003 1 0 0 0 0 0 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 14 11
2005 0 2 2 . 0 3 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 13 11
2006 0 0 0 0 . 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 8
2007 7 7 8 5 3 1 4 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 10
2008 1 0 1 0 0 4 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 7 8
2009 2 2 3 0 0 2 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 10
2010 2 0 9 1 3 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 8
2011 0 1 0 0 0 6 3 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 12
2012 2 1 0 1 0 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 16
2013 1 0 0 0 0 1 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 15
2014 0 1 5 1 0 0 3 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 9 7
2015 2 2 3 3 0 1 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 12 11
2016 0 0 . 0 1 0 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 13 11
2017 4 6 6 0 0 1 4 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 8 10
2018 4 2 7 6 . . . -0.6 -0.2 -0.1 0 0.1 0.2 0.3 13 10
2019 0 8 2 1 0 3 0 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 11 11
3000 3 1 5 1 6 . 1 -0.6 -0.2 -0.1 0 0.1 0.2 0.3 7 12
RUN;
Code for trajectory model and plot:
PROC TRAJ DATA=OPPOSITN OUTPLOT=OP OUTSTAT=OS OUT=OF OUTEST=OE ITDETAIL;
ID ID; VAR O1-O7; INDEP T1-T7;
MODEL CNORM; MAX 10; NGROUPS 3; ORDER 3 3 3;
RUN;
%TRAJPLOT(OP,OS,'Opposition vs. Scaled Age','Cnorm Model','Opposition','Scaled Age')
Does anyone know how to show trajectory line one at a time in the plot (in the above example, I should get 3 plots, one line in each plot)?
Thanks!
I had never heard of PROC TRAJ, and couldn't find it in any of the SAS online docs. Looks like it was created and is supported by the folks at Carnegie Mellon. You can find the documentation for it here: traj: group-based modeling of longitudinal data (cmu.edu)
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.