topic How to calculate mode for length in SAS Procedures

How to calculate mode for length

jerry898969 — Tue, 11 Dec 2012 17:15:44 GMT

I have a column that has text in each row. I was assigned to find the mode of this column by my manager. I have never heard of mode in this respects so i'm not sure how I would calculate it in sas. Any help would be great appreciated.

Re: How to calculate mode for length

Reeza — Tue, 11 Dec 2012 17:19:41 GMT

proc freq and sort descending will get you the most freq. I think there's an option to set it to sort descending.

Re: How to calculate mode for length

jerry898969 — Tue, 11 Dec 2012 18:56:39 GMT

Reeza,

Thank you for your help I will try that out. Is there a proc that can give me mean, median and mode all at once? If not what would be the best approach to calcualte mean and median?

Thank you so much

Re: How to calculate mode for length

Reeza — Tue, 11 Dec 2012 19:02:55 GMT

For a text variable?

I don't know how mean or median for those would be applicable.

Mode makes some sort of sense to find the most frequent comment or word.

For numeric variables, use proc means/summary/univariate.

Re: How to calculate mode for length

jerry898969 — Tue, 11 Dec 2012 19:44:52 GMT

Sorry I didn't explain it better. It is the length of the text field I need these statistics for. I will try those procs thanks.

Re: How to calculate mode for length

ballardw — Tue, 11 Dec 2012 23:32:59 GMT

Data want;

set have;

VarLength=length(variablename of interest);

run;

proc means data=want mean median mode;

var Varlength;

run;

Re: How to calculate mode for length

Prit — Wed, 12 Dec 2012 06:31:49 GMT

In three ways you can calculate mean, mode and median of numeric variable.

1) Proc menas data=<dataset_name> mean mode median;

var <variable_names>;

run;

2) Proc summary data=<dataset_name> print mean mode median;

var <variable_names>;

run;

3) ODS select basicmeasures;

Proc univariate data=<dataset_name>;

var <variable_names>;

run;

Check it out.

-Prit