BookmarkSubscribeRSS Feed
nxmogil
Obsidian | Level 7

Hi Friends, 

I am working on a project where I need to find out employee churn rate for 2001

that means employees left in 2001 /total employees depratement wise. 

please help me with ideas

This is the sample data 

input emp_no dept_no $ dept_name $9.from_date to_date ;

 10058 d001 Marketing 25-04-1988 01-01-2023
10108 d001 Marketing 06-12-1999 20-10-2001
10694 d001 Marketing 26-01-1988 11-07-2001
10787 d001 Marketing 19-07-1991 27-07-2002
10906 d002 Finance 18-10-1998 25-04-2001
12547 d002 Finance 17-10-1997 19-03-2002
12564 d002 Finance 03-11-1998 01-01-2023

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 0 replies
  • 371 views
  • 0 likes
  • 1 in conversation