Something changed the default setting for the COMPRESS option for your jobs. Either you changed your personal autoexec.sas file.  Or perhaps some system level setting file changed.   In general if option settings are critical to your program then make sure to set them in your program.     The only reason that FORCE would be required in your program is if the structure (the set of variables, their types and storage lengths) of the dataset involved are DIFFERENT.  If you did not need the FORCE option before and now you do then something has changed in the datasets you are appending.  They have added and extra variable or changed the storage length of a variable.   The first step will only need the FORCE option is you are actually appending to an existing ATLAS.CLM_DATA_ASO_SEP dataset.  Which is not what you said you wanted to do.  Perhaps you should add code to check whether the target dataset already exists?   Assuming the first step created the ATLAS.CLM_DATA_ASO_SEP dataset then the only reason that you would need FORCE is that the structure of  IATLAS.CLM_DATA_ADJD_GLX_SEP is different than the structure of ATLAS.CLM_DATA_ASO_AUG.     So what changed in the creation of  IATLAS.CLM_DATA_ADJD_GLX_SEP ?   ... View more

Reach out to SAS tech support. There at least used to be a visually impaired employee who would know everything there is to know about that subject. ... View more

Brilliant, many thanks all for your prompt help to improve my understanding of local macro variables 🙂 ... View more

Here's the women's game. Very different style from the men's. France had more 3-pointers, but team USA (barely) won with an avalanche of 1-pointers. /* Source https://www.fiba.basketball/en/events/womens-olympic-basketball-tournament-paris-2024/games/122593-FRA-USA#playByPlay */ data PLAYERS; infile cards ; input COUNTRY $6. / _PLAYERS $200.; do _I=1 to countw(_PLAYERS,','); PLAYER=scan(_PLAYERS, _I, ','); output; end; retain FMTNAME '$country'; drop _:; cards; FRANCE Valeriane Ayayi,Marieme Badiane,Alexia Chery,Marine Fauthoux,Marine Johannes,Leila Lacan,Dominique Malonga,Sarah Michel Boury,Iliana Rupert,Janelle Salaun,Gabby Williams,Romane Bernies USA Napheesa Collier,Kahleah Copper,Chelsea Gray,Brittney Griner,Sabrina Ionescu,Jewell Loyd,Kelsey Plum,Breanna Stewart,Diana Taurasi,Alyssa Thomas,A'ja Wilson,Jackie Young run; proc format cntlin=PLAYERS(rename=(PLAYER=START COUNTRY=LABEL)); run; data CLEANUP; input @1 X :& $80. ; if X=:'End of' then QUARTER+1; format TIMEIN TIME time. TEXT1 TEXT2 $80.; if index(X, ':') then TIMEIN=hms(0, input(scan(X,1,':'),2.), input(scan(X,2,':'),2.)); else if index(X, '+') then POINTS=input(X,2.); else if index(X, '-') then ; else if missing(TEXT1) then TEXT1 =X; else TEXT2 =X; if index(X, '-') then do; SCORE = X; TIME = QUARTER * '0:10:00't - TIMEIN; if prxmatch('/\dpt.*missed/',TEXT1) then POINTS=input(compress(TEXT1,,'dk'),1.)/10; if TEXT1 not in: (' ', 'team offensive', 'Start of', 'End of', 'Timeout') then PLAYER=catx(' ',scan(TEXT1,1), scan(TEXT1,2)); if PLAYER='Sarah Michel' then PLAYER='Sarah Michel Boury'; COUNTRY=put(PLAYER,$country.); COUNTRYSORT= ifn(COUNTRY='USA', 1, 2); %* Set sort order for the graph; POINTS3 = POINTS*(POINTS=3); %* Prepare YAXISTABLE; POINTS2 = POINTS*(POINTS=2); %* Prepare YAXISTABLE; POINTS1 = POINTS*(POINTS=1); %* Prepare YAXISTABLE; output; call missing(TIME, POINTS, TEXT1, TEXT2); end; retain TIMEIN POINTS TEXT1 TEXT2; cards4; 00:00 End of period 9 - 15 00:02 Napheesa Collier defensive rebound 9 - 15 00:02 Alexia Chery 2pt floating jump shot missed 9 - 15 00:26 Alyssa Thomas made the assist 9 - 15 00:26 Brittney Griner +2 2pt turnaround jump shot made 9 - 15 00:38 Brittney Griner defensive rebound 9 - 13 00:38 Marine Johannes 3pt pullup jump shot missed 9 - 13 00:52 Kelsey Plum made the assist 9 - 13 00:52 Brittney Griner +2 2pt turnaround jump shot made 9 - 13 01:13 Marine Johannes +2 2pt driving layup made 9 - 11 01:30 Alyssa Thomas turnover; bad pass 7 - 11 01:38 Napheesa Collier offensive rebound 7 - 11 01:38 Alyssa Thomas 2nd of 2 free throws missed 7 - 11 01:38 Alyssa Thomas +1 1st of 2 free throws made 7 - 11 01:38 Brittney Griner OUT 7 - 10 01:38 A'ja Wilson IN 7 - 10 01:38 Alyssa Thomas foul drawn 7 - 10 01:38 Iliana Rupert personal foul; 2 free throws awarded 7 - 10 01:44 Alyssa Thomas steal 7 - 10 01:44 Iliana Rupert turnover; ball handling 7 - 10 01:53 Sarah Michel Boury steal 7 - 10 01:53 Napheesa Collier turnover; ball handling 7 - 10 01:55 Napheesa Collier offensive rebound 7 - 10 01:55 Sarah Michel Boury blocked the shot 7 - 10 01:55 Napheesa Collier layup missed 7 - 10 02:00 Napheesa Collier offensive rebound 7 - 10 02:00 Kahleah Copper 3pt jump shot missed 7 - 10 02:08 Marine Johannes +2 2pt fadeaway jump shot made 7 - 10 02:22 Kahleah Copper OUT 5 - 10 02:22 Jackie Young IN 5 - 10 02:22 Kelsey Plum +1 2nd of 2 free throws made 5 - 10 02:22 Kelsey Plum +1 1st of 2 free throws made 5 - 9 02:22 Leila Lacan OUT 5 - 8 02:22 Romane Bernies IN 5 - 8 02:22 Alexia Chery OUT 5 - 8 02:22 Marieme Badiane IN 5 - 8 02:22 Kelsey Plum foul drawn 5 - 8 02:22 Romane Bernies personal foul; 2 free throws awarded 5 - 8 02:30 Alyssa Thomas offensive rebound 5 - 8 02:30 Jackie Young 2pt pullup jump shot missed 5 - 8 02:45 A'ja Wilson defensive rebound 5 - 8 02:45 Marine Johannes 3pt jump shot missed 5 - 8 02:56 Kelsey Plum made the assist 5 - 8 02:56 Napheesa Collier +1 2nd of 2 free throws made 5 - 8 02:56 Napheesa Collier 1st of 2 free throws missed 5 - 7 02:56 Alyssa Thomas OUT 5 - 7 02:56 Breanna Stewart IN 5 - 7 02:56 Sarah Michel Boury OUT 5 - 7 02:56 Gabby Williams IN 5 - 7 02:56 Napheesa Collier foul drawn 5 - 7 02:56 Romane Bernies personal foul; 2 free throws awarded 5 - 7 03:03 Breanna Stewart defensive rebound 5 - 7 03:03 Gabby Williams 2pt floating jump shot missed 5 - 7 03:10 Gabby Williams steal 5 - 7 03:10 Breanna Stewart turnover; bad pass 5 - 7 03:23 Jackie Young defensive rebound 5 - 7 03:23 Marine Johannes 2pt floating jump shot missed 5 - 7 03:43 Jackie Young made the assist 5 - 7 03:43 A'ja Wilson +1 2nd of 2 free throws made 5 - 7 03:43 A'ja Wilson 1st of 2 free throws missed 5 - 6 03:43 A'ja Wilson foul drawn 5 - 6 03:43 Marieme Badiane personal foul; 2 free throws awarded 5 - 6 03:51 Jackie Young defensive rebound 5 - 6 03:51 Gabby Williams 2pt hook shot missed 5 - 6 03:55 Gabby Williams offensive rebound 5 - 6 03:55 Iliana Rupert 3pt pullup jump shot missed 5 - 6 04:10 Gabby Williams offensive rebound 5 - 6 04:10 Breanna Stewart blocked the shot 5 - 6 04:10 Marieme Badiane layup missed 5 - 6 04:15 Marieme Badiane offensive rebound 5 - 6 04:15 Marine Johannes 3pt step back jump shot missed 5 - 6 04:28 Romane Bernies defensive rebound 5 - 6 04:28 A'ja Wilson 2pt jump shot inside the paint missed 5 - 6 04:32 A'ja Wilson offensive rebound 5 - 6 04:32 A'ja Wilson 2pt pullup jump shot missed 5 - 6 04:37 Kelsey Plum OUT 5 - 6 04:37 Chelsea Gray IN 5 - 6 04:37 team offensive rebound 5 - 6 04:39 Marieme Badiane blocked the shot 5 - 6 04:39 Breanna Stewart layup missed 5 - 6 04:43 Napheesa Collier steal 5 - 6 04:43 Iliana Rupert turnover; ball handling 5 - 6 04:49 Iliana Rupert offensive rebound 5 - 6 04:49 Marine Johannes 3pt pullup jump shot missed 5 - 6 04:56 jump ball situation; throw-in 5 - 6 05:04 Iliana Rupert offensive rebound 5 - 6 05:04 Gabby Williams 3pt pullup jump shot missed 5 - 6 05:19 Breanna Stewart +1 2nd of 2 free throws made 5 - 6 05:19 Breanna Stewart +1 1st of 2 free throws made 5 - 5 05:19 Breanna Stewart foul drawn 5 - 4 05:19 Romane Bernies personal foul; 2 free throws awarded 5 - 4 05:36 Iliana Rupert OUT 5 - 4 05:36 Valeriane Ayayi IN 5 - 4 05:36 Napheesa Collier foul drawn 5 - 4 05:36 Valeriane Ayayi personal foul 5 - 4 05:41 Napheesa Collier defensive rebound 5 - 4 05:41 Valeriane Ayayi 2pt step back jump shot missed 5 - 4 05:55 Valeriane Ayayi foul drawn 5 - 4 05:55 Chelsea Gray personal foul 5 - 4 06:11 Marieme Badiane steal 5 - 4 06:11 A'ja Wilson turnover; ball handling 5 - 4 06:28 Gabby Williams +2 2pt driving layup made 5 - 4 06:40 Romane Bernies OUT 3 - 4 06:40 Janelle Salaun IN 3 - 4 06:40 Marine Johannes OUT 3 - 4 06:40 Marine Fauthoux IN 3 - 4 06:40 Chelsea Gray turnover; bad pass 3 - 4 06:41 A'ja Wilson foul drawn 3 - 4 06:41 Valeriane Ayayi personal foul 3 - 4 06:52 Napheesa Collier defensive rebound 3 - 4 06:52 Marine Fauthoux 2pt floating jump shot missed 3 - 4 06:58 Gabby Williams steal 3 - 4 06:58 Jackie Young turnover; ball handling 3 - 4 07:16 Gabby Williams +3 3pt pullup jump shot made 3 - 4 07:27 Breanna Stewart turnover; travelling 0 - 4 07:46 A'ja Wilson defensive rebound 0 - 4 07:46 Valeriane Ayayi 3pt pullup jump shot missed 0 - 4 08:08 Chelsea Gray made the assist 0 - 4 08:08 A'ja Wilson +2 layup made 0 - 4 08:13 Jackie Young steal 0 - 2 08:13 Marine Fauthoux turnover; bad pass 0 - 2 08:30 Marine Fauthoux defensive rebound 0 - 2 08:30 Breanna Stewart layup missed 0 - 2 08:38 Jackie Young defensive rebound 0 - 2 08:38 Gabby Williams 2pt pullup jump shot missed 0 - 2 08:51 Marieme Badiane offensive rebound 0 - 2 08:51 Marieme Badiane 2pt hook shot missed 0 - 2 09:14 Chelsea Gray made the assist 0 - 2 09:14 Breanna Stewart +2 2pt turnaround jump shot made 0 - 2 09:31 Napheesa Collier defensive rebound 0 - 0 09:31 Marine Fauthoux 3pt pullup jump shot missed 0 - 0 09:46 Gabby Williams defensive rebound 0 - 0 09:46 Breanna Stewart 2pt jump shot missed 0 - 0 10:00 Marieme Badiane jump ball lost 0 - 0 10:00 A'ja Wilson jump ball won 0 - 0 10:00 Start of game 0 - 0 00:00 End of period 25 - 25 00:00 Napheesa Collier +2 tip in made 25 - 25 00:02 Napheesa Collier offensive rebound 25 - 23 00:02 A'ja Wilson 2pt driving layup missed 25 - 23 00:08 Iliana Rupert OUT 25 - 23 00:08 Marieme Badiane IN 25 - 23 00:08 Alexia Chery OUT 25 - 23 00:08 Valeriane Ayayi IN 25 - 23 00:08 team offensive rebound 25 - 23 00:09 A'ja Wilson layup missed 25 - 23 00:12 A'ja Wilson offensive rebound 25 - 23 00:12 A'ja Wilson 2pt driving layup missed 25 - 23 00:32 A'ja Wilson defensive rebound 25 - 23 00:32 A'ja Wilson blocked the shot 25 - 23 00:32 Janelle Salaun 2pt driving layup missed 25 - 23 00:48 Marieme Badiane defensive rebound 25 - 23 00:48 Jackie Young 2pt floating jump shot missed 25 - 23 01:02 Janelle Salaun +2 2pt pullup jump shot made 25 - 23 01:21 Janelle Salaun foul drawn 23 - 23 01:21 Napheesa Collier personal foul 23 - 23 01:23 Janelle Salaun defensive rebound 23 - 23 01:23 A'ja Wilson 2pt driving layup missed 23 - 23 01:31 A'ja Wilson defensive rebound 23 - 23 01:31 Janelle Salaun 3pt pullup jump shot missed 23 - 23 01:54 Kelsey Plum OUT 23 - 23 01:54 Chelsea Gray IN 23 - 23 01:54 team defensive rebound 23 - 23 01:57 Chelsea Gray 2pt step back jump shot missed 23 - 23 02:24 Jackie Young steal 23 - 23 02:24 Gabby Williams turnover; bad pass 23 - 23 02:36 Chelsea Gray turnover; bad pass 23 - 23 02:45 Timeout 23 - 23 02:47 Marieme Badiane made the assist 23 - 23 02:47 Marine Fauthoux +3 3pt jump shot made 23 - 23 03:14 A'ja Wilson +2 2pt fadeaway jump shot made 20 - 23 03:23 A'ja Wilson defensive rebound 20 - 21 03:23 Marine Fauthoux 2pt floating jump shot missed 20 - 21 03:37 Chelsea Gray made the assist 20 - 21 03:37 Breanna Stewart +1 2nd of 2 free throws made 20 - 21 03:37 Breanna Stewart 1st of 2 free throws missed 20 - 20 03:37 Marine Fauthoux OUT 20 - 20 03:37 Leila Lacan IN 20 - 20 03:37 Breanna Stewart foul drawn 20 - 20 03:37 Leila Lacan personal foul; 2 free throws awarded 20 - 20 03:44 Breanna Stewart steal 20 - 20 03:44 Leila Lacan turnover; bad pass 20 - 20 03:57 Janelle Salaun defensive rebound 20 - 20 03:57 Napheesa Collier 2pt turnaround jump shot missed 20 - 20 04:17 Marieme Badiane made the assist 20 - 20 04:17 Valeriane Ayayi +2 2pt fadeaway jump shot made 20 - 20 04:35 Janelle Salaun defensive rebound 18 - 20 04:35 Breanna Stewart 3pt pullup jump shot missed 18 - 20 04:44 Valeriane Ayayi OUT 18 - 20 04:44 Alexia Chery IN 18 - 20 04:44 Timeout 18 - 20 04:44 A'ja Wilson foul drawn 18 - 20 04:44 Marieme Badiane personal foul 18 - 20 04:54 Napheesa Collier defensive rebound 18 - 20 04:54 Gabby Williams 2pt pullup jump shot missed 18 - 20 04:57 Gabby Williams steal 18 - 20 04:57 A'ja Wilson turnover; bad pass 18 - 20 05:02 A'ja Wilson defensive rebound 18 - 20 05:02 Alexia Chery 3pt step back jump shot missed 18 - 20 05:16 Janelle Salaun offensive rebound 18 - 20 05:16 Alexia Chery 3pt jump shot from center missed 18 - 20 05:38 A'ja Wilson +1 2nd of 2 free throws made 18 - 20 05:38 A'ja Wilson 1st of 2 free throws missed 18 - 19 05:38 Napheesa Collier OUT 18 - 19 05:38 Alyssa Thomas IN 18 - 19 05:38 Marieme Badiane OUT 18 - 19 05:38 Dominique Malonga IN 18 - 19 05:38 Janelle Salaun OUT 18 - 19 05:38 Sarah Michel Boury IN 18 - 19 05:38 A'ja Wilson foul drawn 18 - 19 05:38 Dominique Malonga personal foul; 2 free throws awarded 18 - 19 05:41 A'ja Wilson offensive rebound 18 - 19 05:41 A'ja Wilson 2pt hook shot missed 18 - 19 05:58 Alexia Chery +2 layup made 18 - 19 06:13 Sarah Michel Boury steal 16 - 19 06:13 Chelsea Gray turnover; bad pass 16 - 19 06:26 Chelsea Gray defensive rebound 16 - 19 06:26 Dominique Malonga layup missed 16 - 19 06:55 Chelsea Gray made the assist 16 - 19 06:55 Jackie Young +2 2pt jump shot made 16 - 19 06:56 A'ja Wilson OUT 16 - 17 06:56 Brittney Griner IN 16 - 17 06:56 Brittney Griner foul drawn 16 - 17 06:56 Alexia Chery personal foul 16 - 17 06:57 Brittney Griner offensive rebound 16 - 17 06:57 Breanna Stewart 2pt driving layup missed 16 - 17 07:08 Dominique Malonga made the assist 16 - 17 07:08 Gabby Williams +3 3pt pullup jump shot made 16 - 17 07:14 Dominique Malonga offensive rebound 13 - 17 07:14 Leila Lacan 3pt jump shot missed 13 - 17 07:28 Alyssa Thomas turnover; bad pass 13 - 17 07:34 Alyssa Thomas defensive rebound 13 - 17 07:34 Dominique Malonga layup missed 13 - 17 07:40 Sarah Michel Boury steal 13 - 17 07:40 Jackie Young turnover; bad pass 13 - 17 07:45 Breanna Stewart steal 13 - 17 07:45 Gabby Williams turnover; ball handling 13 - 17 08:04 Jackie Young OUT 13 - 17 08:04 Kahleah Copper IN 13 - 17 08:04 Chelsea Gray OUT 13 - 17 08:04 Kelsey Plum IN 13 - 17 08:04 Gabby Williams OUT 13 - 17 08:04 Marine Johannes IN 13 - 17 08:04 Dominique Malonga OUT 13 - 17 08:04 Iliana Rupert IN 13 - 17 08:04 Alyssa Thomas turnover; bad pass 13 - 17 08:17 Alexia Chery made the assist 13 - 17 08:17 Leila Lacan +2 2pt driving layup made 13 - 17 08:24 Marine Johannes defensive rebound 11 - 17 08:24 Kelsey Plum 3pt pullup jump shot missed 11 - 17 08:41 Sarah Michel Boury made the assist 11 - 17 08:41 Alexia Chery +2 layup made 11 - 17 08:47 Alexia Chery offensive rebound 9 - 17 08:47 Iliana Rupert 3pt jump shot missed 9 - 17 09:03 Sarah Michel Boury offensive rebound 9 - 17 09:03 Marine Johannes 3pt jump shot missed 9 - 17 09:24 Kahleah Copper +2 2pt driving layup made 9 - 17 09:34 Kahleah Copper defensive rebound 9 - 15 09:34 Alexia Chery 3pt jump shot missed 9 - 15 09:49 Iliana Rupert defensive rebound 9 - 15 09:49 Brittney Griner 2pt hook shot missed 9 - 15 10:00 jump ball situation; throw-in 9 - 15 10:00 Start of period 9 - 15 00:00 End of period 43 - 45 00:00 Marine Johannes 3pt pullup jump shot missed 43 - 45 00:05 Alyssa Thomas OUT 43 - 45 00:05 Sabrina Ionescu IN 43 - 45 00:05 A'ja Wilson +1 2nd of 2 free throws made 43 - 45 00:05 A'ja Wilson +1 1st of 2 free throws made 43 - 44 00:05 Jackie Young OUT 43 - 43 00:05 Kelsey Plum IN 43 - 43 00:05 A'ja Wilson foul drawn 43 - 43 00:05 Iliana Rupert personal foul; 2 free throws awarded 43 - 43 00:08 A'ja Wilson offensive rebound 43 - 43 00:08 Sabrina Ionescu 2pt driving layup missed 43 - 43 00:25 Marine Johannes +3 3pt pullup jump shot made 43 - 43 00:34 Marieme Badiane defensive rebound 40 - 43 00:34 Kelsey Plum 2pt turnaround jump shot missed 40 - 43 00:44 Marieme Badiane turnover; ball handling 40 - 43 00:59 Iliana Rupert defensive rebound 40 - 43 00:59 Napheesa Collier 3pt jump shot missed 40 - 43 01:16 Kahleah Copper steal 40 - 43 01:16 Marine Johannes turnover; bad pass 40 - 43 01:36 Sabrina Ionescu made the assist 40 - 43 01:36 Napheesa Collier +2 layup made 40 - 43 01:43 Kahleah Copper foul drawn 40 - 41 01:43 Iliana Rupert personal foul 40 - 41 01:50 Kahleah Copper defensive rebound 40 - 41 01:50 Marine Johannes 2pt step back jump shot missed 40 - 41 02:05 Kelsey Plum OUT 40 - 41 02:05 Jackie Young IN 40 - 41 02:05 Sarah Michel Boury OUT 40 - 41 02:05 Gabby Williams IN 40 - 41 02:05 Leila Lacan foul drawn 40 - 41 02:05 Jackie Young personal foul 40 - 41 02:05 Leila Lacan steal 40 - 41 02:05 Jackie Young turnover; ball handling 40 - 41 02:15 Sabrina Ionescu defensive rebound 40 - 41 02:15 A'ja Wilson blocked the shot 40 - 41 02:15 Gabby Williams 2pt pullup jump shot missed 40 - 41 02:31 Sabrina Ionescu made the assist 40 - 41 02:31 Napheesa Collier +2 layup made 40 - 41 02:45 A'ja Wilson defensive rebound 40 - 39 02:45 Iliana Rupert 3pt jump shot from center missed 40 - 39 02:58 Jackie Young made the assist 40 - 39 02:58 A'ja Wilson +2 layup made 40 - 39 03:16 Iliana Rupert OUT 40 - 37 03:16 Valeriane Ayayi IN 40 - 37 03:16 Jackie Young foul drawn 40 - 37 03:16 Marine Johannes personal foul 40 - 37 03:18 Jackie Young defensive rebound 40 - 37 03:18 A'ja Wilson blocked the shot 40 - 37 03:18 Leila Lacan 2pt driving layup missed 40 - 37 03:36 A'ja Wilson +1 2nd of 2 free throws made 40 - 37 03:36 A'ja Wilson +1 1st of 2 free throws made 40 - 36 03:36 A'ja Wilson foul drawn 40 - 35 03:36 Gabby Williams personal foul; 2 free throws awarded 40 - 35 03:37 A'ja Wilson offensive rebound 40 - 35 03:37 Jackie Young 2pt pullup jump shot missed 40 - 35 03:46 Napheesa Collier OUT 40 - 35 03:46 Breanna Stewart IN 40 - 35 03:49 Sabrina Ionescu defensive rebound 40 - 35 03:49 A'ja Wilson blocked the shot 40 - 35 03:49 Marieme Badiane 2pt jump shot from center missed 40 - 35 04:06 Marine Johannes defensive rebound 40 - 35 04:06 Breanna Stewart 3pt jump shot missed 40 - 35 04:13 Kahleah Copper defensive rebound 40 - 35 04:13 Leila Lacan 3pt pullup jump shot missed 40 - 35 04:33 Sabrina Ionescu OUT 40 - 35 04:33 Kelsey Plum IN 40 - 35 04:33 Kelsey Plum turnover; bad pass 40 - 35 04:46 Valeriane Ayayi made the assist 40 - 35 04:46 Leila Lacan +2 layup made 40 - 35 04:57 Kahleah Copper made the assist 38 - 35 04:57 Breanna Stewart +2 2pt driving layup made 38 - 35 05:06 Kahleah Copper offensive rebound 38 - 33 05:06 Jackie Young 3pt jump shot missed 38 - 33 05:19 Leila Lacan +1 1st free throw made 38 - 33 05:19 Leila Lacan foul drawn 37 - 33 05:19 Kelsey Plum personal foul; 1 free throw awarded 37 - 33 05:19 Leila Lacan +2 2pt floating jump shot made 37 - 33 05:33 Jackie Young made the assist 35 - 33 05:33 Kelsey Plum +3 3pt jump shot made 35 - 33 05:39 Kahleah Copper steal 35 - 30 05:39 Valeriane Ayayi turnover; bad pass 35 - 30 05:43 Valeriane Ayayi offensive rebound 35 - 30 05:43 Marine Johannes layup missed 35 - 30 05:54 Marieme Badiane defensive rebound 35 - 30 05:54 Kahleah Copper 3pt jump shot missed 35 - 30 05:59 Leila Lacan OUT 35 - 30 05:59 Janelle Salaun IN 35 - 30 05:59 Marine Johannes OUT 35 - 30 05:59 Marine Fauthoux IN 35 - 30 05:59 Timeout 35 - 30 05:59 Kahleah Copper foul drawn 35 - 30 05:59 Janelle Salaun personal foul 35 - 30 06:02 A'ja Wilson steal 35 - 30 06:02 Marine Fauthoux turnover; ball handling 35 - 30 06:24 Kelsey Plum made the assist 35 - 30 06:24 A'ja Wilson +2 2pt driving layup made 35 - 30 06:30 Kelsey Plum defensive rebound 35 - 28 06:30 Valeriane Ayayi 2pt driving layup missed 35 - 28 06:44 Kahleah Copper made the assist 35 - 28 06:44 Kelsey Plum +3 3pt jump shot made 35 - 28 07:05 Marine Fauthoux turnover; bad pass 35 - 25 07:09 Marine Fauthoux defensive rebound 35 - 25 07:09 Kahleah Copper 2pt driving layup missed 35 - 25 07:23 Marieme Badiane +1 2nd of 2 free throws made 35 - 25 07:23 Marieme Badiane +1 1st of 2 free throws made 34 - 25 07:23 Marieme Badiane foul drawn 33 - 25 07:23 A'ja Wilson personal foul; 2 free throws awarded 33 - 25 07:38 Marieme Badiane steal 33 - 25 07:38 Kelsey Plum turnover; bad pass 33 - 25 07:59 Kahleah Copper OUT 33 - 25 07:59 Napheesa Collier IN 33 - 25 07:59 Timeout 33 - 25 08:01 Gabby Williams made the assist 33 - 25 08:01 Valeriane Ayayi +3 3pt jump shot from center made 33 - 25 08:08 Kelsey Plum OUT 30 - 25 08:08 Chelsea Gray IN 30 - 25 08:08 Marieme Badiane foul drawn 30 - 25 08:08 Jackie Young personal foul 30 - 25 08:24 team defensive rebound 30 - 25 08:25 Napheesa Collier layup missed 30 - 25 08:28 Napheesa Collier offensive rebound 30 - 25 08:28 Jackie Young 2pt driving layup missed 30 - 25 08:47 Marine Fauthoux +3 3pt pullup jump shot made 30 - 25 08:54 Marine Fauthoux offensive rebound 27 - 25 08:54 Gabby Williams 3pt pullup jump shot missed 27 - 25 09:19 Janelle Salaun defensive rebound 27 - 25 09:19 A'ja Wilson layup missed 27 - 25 09:39 Marieme Badiane made the assist 27 - 25 09:39 Valeriane Ayayi +2 2pt pullup jump shot made 27 - 25 10:00 jump ball situation; throw-in 25 - 25 10:00 Start of period 25 - 25 00:00 End of game 66 - 67 00:00 Marine Johannes made the assist 66 - 67 00:00 Gabby Williams +2 2pt floating jump shot made 66 - 67 00:03 Kahleah Copper +1 2nd of 2 free throws made 64 - 67 00:03 Kahleah Copper +1 1st of 2 free throws made 64 - 66 00:03 Kahleah Copper foul drawn 64 - 65 00:03 Gabby Williams personal foul; 2 free throws awarded 64 - 65 00:05 Gabby Williams +3 3pt pullup jump shot made 64 - 65 00:11 Kelsey Plum +1 2nd of 2 free throws made 61 - 65 00:11 Kelsey Plum +1 1st of 2 free throws made 61 - 64 00:11 Kelsey Plum foul drawn 61 - 63 00:11 Gabby Williams personal foul; 2 free throws awarded 61 - 63 00:13 Marine Johannes +1 2nd of 2 free throws made 61 - 63 00:13 Marine Johannes +1 1st of 2 free throws made 60 - 63 00:13 Marine Johannes foul drawn 59 - 63 00:13 Kahleah Copper personal foul; 2 free throws awarded 59 - 63 00:17 Timeout 59 - 63 00:17 A'ja Wilson +1 2nd of 2 free throws made 59 - 63 00:17 A'ja Wilson 1st of 2 free throws missed 59 - 62 00:17 A'ja Wilson foul drawn 59 - 62 00:17 Marine Fauthoux personal foul; 2 free throws awarded 59 - 62 00:20 A'ja Wilson defensive rebound 59 - 62 00:20 Breanna Stewart blocked the shot 59 - 62 00:20 Marine Fauthoux 3pt jump shot missed 59 - 62 00:41 A'ja Wilson turnover; travelling 59 - 62 00:54 Marine Johannes OUT 59 - 62 00:54 Janelle Salaun IN 59 - 62 00:54 Timeout 59 - 62 00:54 team defensive rebound 59 - 62 00:57 Gabby Williams 3pt pullup jump shot missed 59 - 62 01:19 Breanna Stewart made the assist 59 - 62 01:19 Kahleah Copper +2 2pt driving layup made 59 - 62 01:32 Janelle Salaun OUT 59 - 60 01:32 Marine Johannes IN 59 - 60 01:32 Timeout 59 - 60 01:33 Gabby Williams +2 2pt pullup jump shot made 59 - 60 01:45 Valeriane Ayayi defensive rebound 57 - 60 01:45 Kelsey Plum 3pt jump shot missed 57 - 60 01:51 Breanna Stewart offensive rebound 57 - 60 01:51 Kahleah Copper 2pt driving layup missed 57 - 60 02:08 Marine Johannes turnover; ball handling 57 - 60 02:19 Kelsey Plum +1 2nd of 2 free throws made 57 - 60 02:19 Kelsey Plum +1 1st of 2 free throws made 57 - 59 02:19 Kelsey Plum foul drawn 57 - 58 02:19 Marine Fauthoux personal foul; 2 free throws awarded 57 - 58 02:34 Gabby Williams +1 2nd of 2 free throws made 57 - 58 02:34 Gabby Williams +1 1st of 2 free throws made 56 - 58 02:34 Napheesa Collier OUT 55 - 58 02:34 Jackie Young IN 55 - 58 02:34 Gabby Williams foul drawn 55 - 58 02:34 Jackie Young personal foul; 2 free throws awarded 55 - 58 02:34 Marine Johannes OUT 55 - 58 02:34 Janelle Salaun IN 55 - 58 02:34 Marieme Badiane OUT 55 - 58 02:34 Iliana Rupert IN 55 - 58 02:34 jump ball situation; throw-in 55 - 58 02:38 Gabby Williams offensive rebound 55 - 58 02:38 Iliana Rupert 3pt jump shot missed 55 - 58 02:47 Gabby Williams offensive rebound 55 - 58 02:47 Marine Fauthoux 3pt pullup jump shot missed 55 - 58 03:11 A'ja Wilson +2 2pt step back jump shot made 55 - 58 03:24 team defensive rebound 55 - 56 03:27 Janelle Salaun 3pt jump shot missed 55 - 56 03:45 Janelle Salaun defensive rebound 55 - 56 03:45 Breanna Stewart 2nd of 2 free throws missed 55 - 56 03:45 Breanna Stewart +1 1st of 2 free throws made 55 - 56 03:45 Timeout 55 - 55 03:45 Breanna Stewart foul drawn 55 - 55 03:45 Valeriane Ayayi personal foul; 2 free throws awarded 55 - 55 04:00 Gabby Williams +2 2pt driving layup made 55 - 55 04:09 Kelsey Plum made the assist 53 - 55 04:09 Kahleah Copper +2 layup made 53 - 55 04:16 Breanna Stewart defensive rebound 53 - 53 04:16 Gabby Williams layup missed 53 - 53 04:20 Gabby Williams offensive rebound 53 - 53 04:20 Valeriane Ayayi 3pt jump shot missed 53 - 53 04:35 Kahleah Copper +1 2nd of 2 free throws made 53 - 53 04:35 Kahleah Copper +1 1st of 2 free throws made 53 - 52 04:35 Kelsey Plum OUT 53 - 51 04:35 Sabrina Ionescu IN 53 - 51 04:35 Kahleah Copper foul drawn 53 - 51 04:35 Marine Fauthoux personal foul; 2 free throws awarded 53 - 51 04:42 Kahleah Copper defensive rebound 53 - 51 04:42 Marine Fauthoux 3pt pullup jump shot missed 53 - 51 04:57 Valeriane Ayayi steal 53 - 51 04:57 Sabrina Ionescu turnover; ball handling 53 - 51 05:04 Marine Fauthoux +1 2nd of 2 free throws made 53 - 51 05:04 Marine Fauthoux +1 1st of 2 free throws made 52 - 51 05:04 Marine Fauthoux foul drawn 51 - 51 05:04 Sabrina Ionescu personal foul; 2 free throws awarded 51 - 51 05:15 Iliana Rupert OUT 51 - 51 05:15 Marieme Badiane IN 51 - 51 05:15 A'ja Wilson +1 2nd of 2 free throws made 51 - 51 05:15 A'ja Wilson +1 1st of 2 free throws made 51 - 50 05:15 Jackie Young OUT 51 - 49 05:15 Kelsey Plum IN 51 - 49 05:15 Breanna Stewart OUT 51 - 49 05:15 Napheesa Collier IN 51 - 49 05:15 Janelle Salaun OUT 51 - 49 05:15 Marine Johannes IN 51 - 49 05:15 A'ja Wilson foul drawn 51 - 49 05:15 Marieme Badiane personal foul; 2 free throws awarded 51 - 49 05:32 Valeriane Ayayi made the assist 51 - 49 05:32 Marieme Badiane +2 layup made 51 - 49 05:54 team defensive rebound 49 - 49 05:58 Kelsey Plum 3pt jump shot from center missed 49 - 49 06:18 Valeriane Ayayi +1 2nd of 2 free throws made 49 - 49 06:18 Gabby Williams made the assist 48 - 49 06:18 Valeriane Ayayi +1 1st of 2 free throws made 48 - 49 06:18 Valeriane Ayayi foul drawn 47 - 49 06:18 Napheesa Collier personal foul; 2 free throws awarded 47 - 49 06:25 Gabby Williams offensive rebound 47 - 49 06:25 Valeriane Ayayi 3pt jump shot missed 47 - 49 06:40 Sabrina Ionescu made the assist 47 - 49 06:40 A'ja Wilson +2 2pt pullup jump shot made 47 - 49 06:51 Napheesa Collier foul drawn 47 - 47 06:51 Marine Fauthoux personal foul 47 - 47 07:07 Napheesa Collier defensive rebound 47 - 47 07:07 Valeriane Ayayi 3pt jump shot missed 47 - 47 07:23 Napheesa Collier turnover; travelling 47 - 47 07:46 Kelsey Plum OUT 47 - 47 07:46 Alyssa Thomas IN 47 - 47 07:46 Marieme Badiane +1 2nd of 2 free throws made 47 - 47 07:46 Marieme Badiane +1 1st of 2 free throws made 46 - 47 07:46 Marieme Badiane foul drawn 45 - 47 07:46 A'ja Wilson personal foul; 2 free throws awarded 45 - 47 08:01 Kahleah Copper +1 2nd of 2 free throws made 45 - 47 08:01 Kahleah Copper +1 1st of 2 free throws made 45 - 46 08:01 Napheesa Collier OUT 45 - 45 08:01 Jackie Young IN 45 - 45 08:01 A'ja Wilson OUT 45 - 45 08:01 Breanna Stewart IN 45 - 45 08:01 Kahleah Copper foul drawn 45 - 45 08:01 Marieme Badiane personal foul; 2 free throws awarded 45 - 45 08:25 Marine Fauthoux made the assist 45 - 45 08:25 Marieme Badiane +2 2pt jump shot made 45 - 45 08:37 Marine Johannes foul drawn 43 - 45 08:37 Jackie Young personal foul 43 - 45 08:37 team defensive rebound 43 - 45 08:38 Kahleah Copper 3pt jump shot missed 43 - 45 08:53 Marine Johannes turnover; out of bounds 43 - 45 09:10 Gabby Williams OUT 43 - 45 09:10 Leila Lacan IN 43 - 45 09:10 Marine Fauthoux OUT 43 - 45 09:10 Sarah Michel Boury IN 43 - 45 09:10 Valeriane Ayayi foul drawn 43 - 45 09:10 Jackie Young personal foul 43 - 45 09:10 team defensive rebound 43 - 45 09:10 Jackie Young layup missed 43 - 45 09:19 team turnover; 24 seconds violation 43 - 45 09:21 Marine Johannes 3pt step back jump shot missed 43 - 45 09:44 Marieme Badiane defensive rebound 43 - 45 09:44 Alyssa Thomas 2pt turnaround jump shot missed 43 - 45 10:00 jump ball situation; throw-in 43 - 45 10:00 Start of period 43 - 45 ;;;; run; proc sort data=CLEANUP out=SORTED; by TIME ; where POINTS | TEXT2 in('IN','OUT') ; run; data YGROUPS; %* 4 Groups: Country scores, player scores, dividers, line plot; set SORTED end=LASTOBS; where TEXT2 not in('IN','OUT') ; output; %* Group for per-player plot; PLAYER=COUNTRY; COUNTRYSORT=0; if POINTS >= 1 then output; %* Group for per-country plot, top of Y axis (COUNTRYSORT=0); if LASTOBS; %* At the end, write out the data needed to display the 2 other groups; call missing(of POINTS1-POINTS3, POINTS); %* No YAXISTABLE data; TIME='0:00:00't; POINTSORT=999; %* Group used to draw team dividers; PLAYER='TEAM USA' ; COUNTRYSORT=1; output; %* COUNTRYSORT as needed and POINTSORT=999 to be at the top of the country players; PLAYER='TEAM FRANCE'; COUNTRYSORT=2; output; /* PLAYER='09'x; COUNTRYSORT=4; output; %* Group to reserve space for sparkline plot, bottom of Y axis (COUNTRYSORT=4); */ run; proc sql; %* Derive total scores used for sorting; create table POINTS_PLOT as select *, sum(POINTS*(POINTS >= 1)) as TOTPOINTS , sum(POINTS1) as TOTPOINTS1 , sum(POINTS2) as TOTPOINTS2, sum(POINTS3) as TOTPOINTS3 from YGROUPS group by PLAYER, COUNTRY order by COUNTRYSORT, POINTSORT desc, TOTPOINTS desc, COUNTRY, PLAYER; quit; proc sql; create table LEADTIME as select SCORE, min(TIME) as TIME from SORTED group by SCORE order by calculated TIME ; data LEAD_PLOT; set LEADTIME(keep=TIME SCORE) end=LASTOBS; if ^LASTOBS then set LEADTIME(keep=TIME rename=(TIME=NEXTTIME) firstobs=2); else NEXTTIME='0:40:00't; if _N_=1 then TIME=0; DIF=input(resolve('%eval('||SCORE||')'),8.); run; proc sql; %* Get list of players for each quarter; create table QP as select unique QUARTER, PLAYER, COUNTRY from CLEANUP where PLAYER ne ' ' and PLAYER not like 'team%' order by 1, 2; %* Get list of player swap times; create table INOUT as select QUARTER, PLAYER, TIME, COUNTRY, ifc(TEXT2='IN', 'stop', 'start')as ENTRY length=5 from CLEANUP where TEXT2 in ('IN','OUT') order by 1, 2, 3; data QPTIME; %* Assign max play time to each player; set QP; TIME=QUARTER*'0:10:00't-'0:10:00't; ENTRY='start'; output; TIME=QUARTER*'0:10:00't ; ENTRY='stop '; output; run; data QPINOUT; %* Mix max times and actual times ; set QPTIME INOUT(where=(ENTRY='start')) INOUT(where=(ENTRY='stop ')) ; by QUARTER PLAYER TIME; run; data INOUT_PLOT; if 0 then set QPINOUT nobs=NOBS; do CURRENT=1 to NOBS; NEXT=CURRENT+1; set QPINOUT point=CURRENT; if CURRENT ne NOBS then set QPINOUT(keep= QUARTER PLAYER ENTRY rename=(QUARTER=_QUARTER PLAYER=_PLAYER ENTRY=_ENTRY)) point=NEXT; if ENTRY='start' then do; %* lastest START possible, skip to next record if available; if QUARTER=_QUARTER & PLAYER=_PLAYER & _ENTRY='start' then continue; else START=TIME; end; if ENTRY='stop' then do; %* earliest STOP, skip next record if also STOP; END=TIME; output; if QUARTER=_QUARTER & PLAYER=_PLAYER & _ENTRY='stop' then CURRENT+1; end; end; stop; run; data ANNO; %* Create line plots, line plot labels, line plot background; length FUNCTION LABEL FILLCOLOR LINECOLOR COMMENT X1SPACE X2SPACE Y1SPACE Y2SPACE ANCHOR $48; retain X1SPACE X2SPACE 'datavalue' Y1SPACE Y2SPACE 'datapercent' FUNCTION 'line' WIDTH 105 Y0LINESCORE -11; X1=0; Y1=Y0LINESCORE; LINECOLOR='red'; LINETHICKNESS=.1; do until (LASTOBS2); set SORTED(where=(COUNTRY='FRANCE' and POINTS >= 1)) end=LASTOBS2; P+POINTS; X2=ifn(LASTOBS2, '0:40:00't, TIME); Y2=P*.15+Y0LINESCORE; COMMENT='Line Score France'; output; X1=X2; Y1=Y2; end; X1=0; Y1=Y0LINESCORE; P=0; LINECOLOR='blue'; do until (LASTOBS1); set SORTED(where=(COUNTRY='USA' and POINTS >= 1)) end=LASTOBS1 ; P+POINTS; X2=ifn(LASTOBS1, '0:40:00't, TIME); Y2=P*.15+Y0LINESCORE; COMMENT='Line Score USA'; output; X1=X2; Y1=Y2; end; Y0TRACKER=-17; TRACKERSCALE=0.5; X1=0; Y1=Y0TRACKER ; LINECOLOR='gray'; X2='0:40:10't; Y2=Y1; COMMENT='Line 0 Lead Tracker '; output; Y1=Y0TRACKER+5*TRACKERSCALE; Y2=Y1; COMMENT='Line 5 Lead Tracker'; output; Y1=Y0TRACKER-5*TRACKERSCALE; Y2=Y1; COMMENT='Line 5 Lead Tracker'; output; ANCHOR='right'; FUNCTION='text'; TEXTSIZE=8; X1='0:40:45't; Y1=Y0TRACKER ; LABEL='0'; COMMENT='Value 0 Lead Tracker '; output; Y1=Y0TRACKER+5*TRACKERSCALE; LABEL='5'; COMMENT='Value 5 Lead Tracker'; output; Y1=Y0TRACKER-5*TRACKERSCALE; LABEL='5'; COMMENT='Value 5 Lead Tracker'; output; Y1=Y0TRACKER; FUNCTION='rectangle'; DISPLAY='fill'; WIDTHUNIT='data'; do until (LASTOBS3); set LEAD_PLOT end=LASTOBS3 ; X1=TIME; WIDTH=(NEXTTIME-TIME)+0.01; if DIF<0 then do; HEIGHT=-DIF*TRACKERSCALE; ANCHOR='bottomleft'; FILLCOLOR='blue'; end; else do; HEIGHT=+DIF*TRACKERSCALE; ANCHOR='topleft '; FILLCOLOR='red '; end; COMMENT='Bars Lead Tracker'; if DIF then output; end; WIDTH='0:42:10't; ANCHOR='Center'; LAYER='back '; DISPLAY='fill'; FUNCTION='rectangle'; X1= '0:20:00't; Y1= -6; FILLCOLOR='lightyellow'; HEIGHT=11; COMMENT='yellow rectangle'; output; FUNCTION='rectangle'; X1= '0:20:00't; Y1=-17; FILLCOLOR='cxeeeeff '; HEIGHT=11; COMMENT='blue rectangle '; output; FILLCOLOR=' '; FUNCTION='text '; X1= '0:14:00't; Y1= -6; TEXTCOLOR='blue '; LABEL='USA '; COMMENT='Line plot label'; output; FUNCTION='text '; X1= '0:15:00't; Y1=-10; TEXTCOLOR='red '; LABEL='France '; COMMENT='Line plot label'; output; FUNCTION='text '; X1=-'0:03:00't; Y1= -7; TEXTCOLOR='black'; LABEL='SCOREBOARD'; COMMENT='Y axis value '; output; FUNCTION='text '; X1=-'0:03:00't; Y1=Y0TRACKER; TEXTCOLOR='black'; LABEL='LEAD TRACKER'; COMMENT='Y axis value '; output; COMMENT='legend'; FILLCOLOR=' '; LAYER='front'; X1SPACE ='datapercent'; X2SPACE ='datapercent'; Y1SPACE ='datapercent'; Y2SPACE ='datapercent'; FUNCTION='text '; X1=53 ; Y1=110; TEXTCOLOR='black'; LABEL='S c o r e d'; output; FUNCTION='text '; X1=75 ; Y1=110; TEXTCOLOR='black'; LABEL='M i s s e d'; output; FUNCTION='oval '; X1=67.5; Y1=114; HEIGHT=2; WIDTH=HEIGHT * 13 ; FILLCOLOR='cxfff5f5'; output; FUNCTION='text '; X1=70 ; Y1=114; TEXTCOLOR='black'; LABEL='1'; FILLCOLOR=' '; output; FUNCTION='oval '; X1=74 ; Y1=114; HEIGHT=3.5; WIDTH=HEIGHT *13; FILLCOLOR='cxf2f2ff'; output; FUNCTION='text '; X1=76.5; Y1=114; TEXTCOLOR='black'; LABEL='2'; FILLCOLOR=' '; output; FUNCTION='oval '; X1=81 ; Y1=114; HEIGHT=5; WIDTH=HEIGHT * 13 ; FILLCOLOR='cxf3f9f3'; output; FUNCTION='text '; X1=85 ; Y1=114; TEXTCOLOR='black'; LABEL='3'; FILLCOLOR=' '; output; FUNCTION='line '; X1=13 ; Y1=114; X2=19; Y2=Y1; LINECOLOR='cxe3e3e3'; LINETHICKNESS=5; LAYER='back'; output; FUNCTION='text '; X1=26 ; Y1=114; LABEL='P l a y e r o n c o u r t'; WIDTH=999; output; COMMENT='IN OUT'; X1SPACE ='datavalue'; X2SPACE ='datavalue'; Y1SPACE ='datavalue'; Y2SPACE ='datavalue'; Y1=.; Y2=.; ANCHOR='left'; FUNCTION='line'; do until (LASTOBS4); set INOUT_PLOT end=LASTOBS4; X1=START; X2=END; YC1=PLAYER; YC2=PLAYER; if PLAYER not in('Romane Bernies','Sarah Michel Boury','Dominique Malonga') then output; %* not on graph as never attempted a shot; end; run; data ATTRMAPPOINTS; %* Differentiate shot types using color and size; input ID $ VALUE $ FILLCOLOR :$16. MARKERSIZE MARKERTRANSPARENCY LINECOLOR $ LINEPATTERN LINETHICKNESS; datalines; point 1 red 12 .6 red 2 1 point 2 blue 18 .6 red 2 1 point 3 green 24 .6 red 2 1 point 0.1 red 12 .9 red 1 0 point 0.2 blue 18 .9 red 1 0 point 0.3 green 24 .9 red 1 0 ; options missing=' '; ods graphics / reset width=14in height=8.5in noborder ; proc sgplot data=POINTS_PLOT dattrmap=ATTRMAPPOINTS sganno=ANNO nowall; title height=16pt "2024 Paris Olympics Women's Basketball Final - USA vs. France"; scatter x=TIME y=PLAYER / group=POINTS attrid=point jitter filledoutlinedmarkers markeroutlineattrs=(color=darkgray) markerattrs=(symbol=circlefilled) ; %* Jitter scores for shots occuring at same clock time (e.g., free throws); xaxis display=(nolabel noline noticks) values=('00:00:00't to'00:40:00't by '00:02:00't) ; yaxis display=(nolabel noline noticks) valueattrs=(size=10pt) grid discreteorder=data reverse offsetmax=0.16; yaxistable TOTPOINTS / stat=mean label='PTS' labelattrs=(size=8pt weight=bold) valueattrs=(size=10pt) location=outside; %* Show total points by categories; yaxistable TOTPOINTS3 / stat=mean label='3' labelattrs=(size=8pt weight=bold) valueattrs=(size=10pt) location=outside; yaxistable TOTPOINTS2 / stat=mean label='2' labelattrs=(size=8pt weight=bold) valueattrs=(size=10pt) location=outside; yaxistable TOTPOINTS1 / stat=mean label='1' labelattrs=(size=8pt weight=bold) valueattrs=(size=10pt) location=outside; keylegend / exclude=(' ' '0.1' '0.2' '0.3') sortorder=ascending noborder location=outside title="POINTS" position=top; refline 'TEAM USA' 'TEAM FRANCE' / axis=y lineattrs=(thickness=6pt); %* Draw H separator lines between teams; refline ('0:00:00't to '0:40:00't by '0:10:00't) / axis=x; %* Draw V ref lines for start/end of quarters; run;     ... View more

https://documentation.sas.com/doc/en/pgmsascdc/v_053/statug/statug_templt_sect019.htm   See if this example helps.  Search it for circumflex. ... View more

Don't use Optex. Use MktEx.   %mktex(3 3 3, n=17)   Better yet, %mktex(3 3 3, n=9) or %mktex(3 3 3, n=18)   %mktex will use OPTEX if nothing else is better, but it has other methods that often work better.   https://support.sas.com/rnd/app/macros/MktEx/MktEx.pdf   For a very small problem such as this, OPTEX, and most any other reasonable method will work the same. However, for larger problems, %mktex will often work better than OPTEX.   ... View more

Thank you again for answering my follow-up questions!! Your book really helped me a lot, and I will take a closer look at the chapter again! ... View more

Yes, I realized it didn't work because I had quote around the text. Thanks for the tips!  ... View more

A design that approximates a balanced incomplete block design should do the trick. A fully balanced design is not possible with 400 papers and your other constraints. All you need is one simple line:   %mktbibd(b=400,k=2,v=3) ... View more

Holy moly Batman! it worked. I removed the str(') from the proc report lines in the macro and it worked great.  ... View more

Short answer: Use QUIT to terminate interactive procedures. Reasons include both clarity and to ensure that ODS output (and other global SAS statements) are correctly applied. See this blog post from 2011: https://blogs.sas.com/content/iml/2011/12/12/sas-tip-put-ods-statements-inside-procedures.html  ... View more

To clear, there is no current SAS option to halt program execution when an error is found. Such an option has long been requested in SAS Product Suggestions. That means you are left with ERRORABEND and SYNTAXCHECK. Personally I find the latter most useful and it is the default for batch jobs anyway. You may find it is a good compromise given the lack of a halt system option. ... View more

Dear Jill, Thank you very much for figuring it out. Since I did not have the patience you have (real time 65:55:43.65) to run the programme, I had aborted it. So logically this error message. But even with the instructions (maxiter=1000 maxfunc=5000), there is still no guarantee of a solution. Also, I must give you, greetings from Warren Kuhfeld. Best, Roy   ... View more

Do you really want to check for SORT=1,  or check for start of a new group.  Of course they are the same if SORT=1 is reliably the first (and only) observation of each incoming group.   There is a way to use LAG, as here:   data have; input Group Sort Value ; cards; 1 1 50 1 2 55 1 3 60 1 4 70 2 1 40 2 2 60 2 3 40 2 4 90 ;run; data want; set have; by group; x+lag(value); if first.group then x=0; y+value; if first.group then y=value; run; Of course you could use  "IF sort=1"  instead of "IF first.group".         ... View more