I'm stuck on how to use sas to categorize my data while using the original excel file. I need to categorize as DMV or Non DMV... Does anyone know how to do it? I think an if/then statement is required. Prompt: Most Marine Corps Marathon runners are from the greater DC-Maryland-Virginia (DMV) metro area. Nevertheless, the race attracts enthusiasts nationally and internationally. Since out-of-the-area runners incur additional travel, hotel, food, etc expenses, it seems plausible they might, as a group, be more dedicated runners than local participants. For simplicity, define anyone from DC, Maryland or Virginia as originating from the DMV. Moreover, consider anyone with a finish time under 6 hours as a “runner” and with 6 hours or more as a “walker”. Exclude walkers from the analysis. (5 Pts) Using Sample01, test the assertion that runners from outside the DMV have a faster mean (or median) finish time than runners from the DMV. Use . What do you conclude about the assertion? (5 Pts) Provide a 95% confidence interval for the difference (in minutes) between the mean (or median) finish time of outside the DMV and DMV runners. Sample 1: 170 72 10665 10933 6963 7022 5037 4265 15606 14513 623 709 11168 11293 7723 7274 6215 5053 16667 16113 1044 1950 11169 11497 8821 7677 6363 5066 16812 17698 1180 2288 11691 12228 9242 8728 6522 5233 17038 18104 1921 3391 15528 14118 9503 9751 6678 6530 18697 18639 So far I've had sas produce a table with just the sample 1 runners in it. Code: %LET WorkingDirectory = C:\; PROC IMPORT DATAFILE="&WorkingDirectory.mcm_2017.csv" OUT=Runners DBMS=csv REPLACE; RUN; *Question 1; Data Sample01; INPUT Overall_Place @@; DATALINES; 170 72 10665 10933 6963 7022 5037 4265 15606 623 709 11168 11293 7723 7274 6215 5053 * 1044 1950 11169 11497 8821 7677 6363 5066 * 1180 2288 11691 12228 9242 8728 6522 5233 * 1921 3391 * 14118 9503 9751 6678 6530 * ; RUN; *Sample 01 Runners; PROC SQL; CREATE TABLE Sample01_Runners as SELECT Name, Gender, Age, Time, b.Overall_Place, City, State, Country FROM WORK.RUNNERS a, WORK.SAMPLE01 b WHERE a.Overall_Place=b.Overall_Place; Run; If you have questions don't hesitate to ask.
... View more