I try too answer this questions

mionnh — Sun, 27 Feb 2022 22:14:16 GMT

proc import datafile='C:\Users\n01427744\My Files\OneDrive\Files\SAS\ksi.csv'

    out = work.ksi

    dbms = csv;

run;

proc contents data=ksi;

run;

proc sort data=ksi

        out = work.KSI_sortbyYearAccnum;

    by Year Accnum;

run;

data AGGKSI;

    set work.ksi_sortbyyearaccnum(Keep= Accnum Year Time Street1 Street2 offset road_class District wardnum Division

                                  LATITUDE LONGITUDE LOCCOORD ACCLOC TRAFFCTL VISIBILITY LIGHT RDSFCOND ACCLASS IMPACTYPE

                                PEDESTRIAN CYCLIST AUTOMOBILE MOTORCYCLE TRUCK TRSN_CITY_VEH EMERG_VEH

                                PASSENGER SPEEDING AG_DRIV REDLIGHT ALCOHOL DISABILITY Neighbourhood);

by year accnum;

if last.accnum;

run;

proc print data=aggksi;

run;

Q1: Aggregate KSI data by ACCNUM, so that each observation is a unique KSI event.

a) How many KSI incidents occurred in the city of Toronto from 2006-2019?

b) Which is the most incidents district, neighborhood, and location?

c) What about the road and weather condition for most KSI incidents?

d) How many KSI incidents involving speeding were fatal ?

Q2: Transform the aggregated KSI data by Geographic Coordinates (Latitude and Longitude), each observation should be a unique location, so that the KSI number in each unique location can be calculated. What are the top five locations with most KSI incidents in Toronto?

Re: I try too answer this questions

LinusH — Mon, 28 Feb 2022 09:11:58 GMT

Is this for training?

Also, it's hard to give any solid advice without seeing any data.

Re: I try too answer this questions

Sajid01 — Mon, 28 Feb 2022 14:26:02 GMT

Hello @mionnh
These are fairly straightforward questions.
Please try and let us know if you have any error.
make sure data is included in the post as sas datastep and the log.

topic Re: I try too answer this questions in SAS Programming

I try too answer this questions

Re: I try too answer this questions

Re: I try too answer this questions