topic Re: Descriptive Analysis in New SAS User

Descriptive Analysis

Amir1360 — Sat, 18 Apr 2020 05:32:05 GMT

I need to conduct a series of descriptive analysis and come up with the average absenteeism (absent hours) per department and per location on a dataset which has the following variables:

Gender

City

Job Title

Department Name

Store Location

Division

Age

Length of Service

Absent Hours

Business Unit

What code do I need to write to get the average absenteeism (absent hours) per department and per location?

In addition, how can I measure the effects of age and length of service on absenteeism? (Which code should I write to get that)?

And; in order to discover if gender explains any differences in absenteeism. What code do I need to write?

Please help.

Thanks.

Re: Descriptive Analysis

PaigeMiller — Sat, 18 Apr 2020 11:39:41 GMT

Something like this

proc summary data=have nway;
    class department location;
    var absenthours;
    output out=_stats_ n= mean= min= max= median= std=/autoname;
run;

In addition, how can I measure the effects of age and length of service on absenteeism? (Which code should I write to get that)?

And; in order to discover if gender explains any differences in absenteeism. What code do I need to write?

Tell us what statistical method or statistical analysis you want to do, and then we can help you with the code.

Re: Descriptive Analysis

Amir1360 — Sat, 18 Apr 2020 16:18:44 GMT

Great, thank you.

I need to conduct scale diagnostics (reliability analysis) for the measures.

I also need to run two chi-square analyses to find out if there is discrimination in the organization against people.

Re: Descriptive Analysis

PaigeMiller — Sat, 18 Apr 2020 17:02:54 GMT

I don't know what "scale diagnostics" are so I can't help with that part.

PROC FREQ has a Chi-squared option, but there are many other ways to get chi-squared tests in SAS; and saying what test you want is not the same as saying what analysis you'd like to do. So please indicate what the statistical analysis method is that you'd like to use.