topic How i can count the name many times in SAS? in SAS Programming

How i can count the name many times in SAS?

mionnh — Sun, 27 Feb 2022 22:08:28 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;

Re: How i can count the name many times in SAS?

japelin — Mon, 28 Feb 2022 04:16:44 GMT

The SAS code can be pasted using the "Insert SAS Code" icon on the editing screen for easier viewing.
What is the "NAME" you are referring to?
I can't determine it from the code alone; please paste the data in a usable format, such as a data step using datalines or as an attachment.
Please add a more specific description what you want to do.

Re: How i can count the name many times in SAS?

ballardw — Mon, 28 Feb 2022 16:16:30 GMT

Very often any question related to COUNT means that Proc FREQ is likely a good start. You can count individual levels of each variable or combinations of variables by using a * between names on a Tables statement. You may want the /list option for readability for multiple variables.

The Proc Freq statement option Order=freq means the output tables will be in decreasing order of frequency (i.e. decreasing count)