Hello-,
I am trying to create a variable year from SAS date.
When I run this code on the date, I get the wrong answer:
data want1;
input Birthdate;
cards;
5/27/2014 |
5/28/2014 |
5/29/2014 |
5/30/2014 |
5/31/2014 |
6/1/2014 |
6/2/2014 |
6/3/2014 |
6/4/2014 |
6/5/2014 |
6/6/2014 |
6/7/2014 |
6/8/2014 |
6/9/2014 |
6/10/2014 |
6/11/2014 |
6/12/2014 |
6/13/2014 |
6/14/2014 |
6/15/2014 |
6/16/2014 |
6/17/2014 |
6/18/2014 |
6/19/2014 |
6/20/2014 |
6/21/2014 |
6/22/2014 |
6/23/2014 |
6/24/2014 |
6/25/2014 |
6/26/2014 |
6/27/2014 |
6/28/2014 |
6/29/2014 |
6/30/2014 |
7/1/2014 |
7/2/2014 |
7/3/2014 |
7/4/2014 |
7/5/2014 |
7/6/2014 |
7/7/2014 |
7/8/2014 |
7/9/2014 |
7/10/2014 |
7/11/2014 |
7/12/2014 |
7/13/2014 |
7/14/2014 |
7/15/2014 |
7/16/2014 |
7/17/2014 |
7/18/2014 |
7/19/2014 |
7/20/2014 |
7/21/2014 |
7/22/2014 |
7/23/2014 |
7/24/2014 |
7/25/2014 |
7/26/2014 |
7/27/2014 |
7/28/2014 |
7/29/2014 |
7/30/2014 |
7/31/2014 |
8/1/2014 |
8/2/2014 |
8/3/2014 |
8/4/2014 |
8/5/2014 |
8/6/2014 |
8/7/2014 |
8/8/2014 |
8/9/2014 |
8/10/2014 |
8/11/2014 |
8/12/2014 |
8/13/2014 |
8/14/2014 |
8/15/2014 |
8/16/2014 |
8/17/2014 |
8/18/2014 |
8/19/2014 |
8/20/2014 |
8/21/2014 |
8/22/2014 |
8/23/2014 |
8/24/2014 |
8/25/2014 |
8/26/2014 |
8/27/2014 |
8/28/2014 |
8/29/2014 |
8/30/2014 |
8/31/2014 |
9/1/2014 |
9/2/2014 |
9/3/2014 |
9/4/2014 |
9/5/2014 |
9/6/2014 |
9/7/2014 |
9/8/2014 |
9/9/2014 |
9/10/2014 |
9/11/2014 |
9/12/2014 |
9/13/2014 |
9/14/2014 |
9/15/2014 |
9/16/2014 |
9/17/2014 |
9/18/2014 |
9/19/2014 |
9/20/2014 |
9/21/2014 |
9/22/2014 |
9/23/2014 |
9/24/2014 |
9/25/2014 |
9/26/2014 |
9/27/2014 |
9/28/2014 |
9/29/2014 |
9/30/2014 |
10/1/2014 |
10/2/2014 |
10/3/2014 |
10/4/2014 |
10/5/2014 |
10/6/2014 |
10/7/2014 |
10/8/2014 |
10/9/2014 |
10/10/2014 |
10/11/2014 |
10/12/2014 |
10/13/2014 |
10/14/2014 |
10/15/2014 |
10/16/2014 |
10/17/2014 |
10/18/2014 |
10/19/2014 |
10/20/2014 |
10/21/2014 |
10/22/2014 |
10/23/2014 |
10/24/2014 |
10/25/2014 |
10/26/2014 |
10/27/2014 |
10/28/2014 |
10/29/2014 |
10/30/2014 |
10/31/2014 |
11/1/2014 |
11/2/2014 |
11/3/2014 |
11/4/2014 |
11/5/2014 |
11/6/2014 |
11/7/2014 |
11/8/2014 |
11/9/2014 |
11/10/2014 |
11/11/2014 |
11/12/2014 |
11/13/2014 |
11/14/2014 |
11/15/2014 |
11/16/2014 |
11/17/2014 |
11/18/2014 |
11/19/2014 |
11/20/2014 |
11/21/2014 |
11/22/2014 |
11/23/2014 |
11/24/2014 |
11/25/2014 |
11/26/2014 |
11/27/2014 |
11/28/2014 |
11/29/2014 |
11/30/2014 |
12/1/2014 |
12/2/2014 |
12/3/2014 |
12/4/2014 |
12/5/2014 |
12/6/2014 |
12/7/2014 |
12/8/2014 |
12/9/2014 |
12/10/2014 |
12/11/2014 |
12/12/2014 |
12/13/2014 |
12/14/2014 |
12/15/2014 |
12/16/2014 |
12/17/2014 |
12/18/2014 |
12/19/2014 |
12/20/2014 |
12/21/2014 |
12/22/2014 |
12/23/2014 |
12/24/2014 |
12/25/2014 |
12/26/2014 |
12/27/2014 |
12/28/2014 |
12/29/2014 |
12/30/2014 |
12/31/2014 |
1/1/2015 |
1/2/2015 |
1/3/2015 |
1/4/2015 |
1/5/2015 |
1/6/2015 |
1/7/2015 |
1/8/2015 |
1/9/2015 |
1/10/2015 |
1/11/2015 |
1/12/2015 |
1/13/2015 |
1/14/2015 |
1/15/2015 |
1/16/2015 |
1/17/2015 |
1/18/2015 |
1/19/2015 |
1/20/2015 |
1/21/2015 |
1/22/2015 |
1/23/2015 |
1/24/2015 |
1/25/2015 |
1/26/2015 |
1/27/2015 |
1/28/2015 |
1/29/2015 |
1/30/2015 |
1/31/2015 |
2/1/2015 |
2/2/2015 |
2/3/2015 |
2/4/2015 |
2/5/2015 |
2/6/2015 |
2/7/2015 |
2/8/2015 |
2/9/2015 |
2/10/2015 |
2/11/2015 |
2/12/2015 |
2/13/2015 |
2/14/2015 |
2/15/2015 |
2/16/2015 |
2/17/2015 |
2/18/2015 |
2/19/2015 |
2/20/2015 |
2/21/2015 |
2/22/2015 |
2/23/2015 |
2/24/2015 |
2/25/2015 |
2/26/2015 |
2/27/2015 |
2/28/2015 |
3/1/2015 |
3/2/2015 |
3/3/2015 |
3/4/2015 |
3/5/2015 |
3/6/2015 |
3/7/2015 |
3/8/2015 |
3/9/2015 |
3/10/2015 |
3/11/2015 |
3/12/2015 |
3/13/2015 |
3/14/2015 |
3/15/2015 |
3/16/2015 |
3/17/2015 |
3/18/2015 |
3/19/2015 |
3/20/2015 |
3/21/2015 |
3/22/2015 |
3/23/2015 |
3/24/2015 |
3/25/2015 |
3/26/2015 |
3/27/2015 |
3/28/2015 |
3/29/2015 |
3/30/2015 |
3/31/2015 |
4/1/2015 |
4/2/2015 |
4/3/2015 |
4/4/2015 |
4/5/2015 |
4/6/2015 |
4/7/2015 |
4/8/2015 |
4/9/2015 |
4/10/2015 |
4/11/2015 |
4/12/2015 |
4/13/2015 |
4/14/2015 |
4/15/2015 |
4/16/2015 |
4/17/2015 |
4/18/2015 |
4/19/2015 |
4/20/2015 |
4/21/2015 |
4/22/2015 |
4/23/2015 |
4/24/2015 |
4/25/2015 |
4/26/2015 |
4/27/2015 |
4/28/2015 |
4/29/2015 |
4/30/2015 |
5/1/2015 |
5/2/2015 |
5/3/2015 |
5/4/2015 |
5/5/2015 |
5/6/2015 |
5/7/2015 |
5/8/2015 |
5/9/2015 |
5/10/2015 |
5/11/2015 |
5/12/2015 |
5/13/2015 |
5/14/2015 |
5/15/2015 |
5/16/2015 |
5/17/2015 |
5/18/2015 |
5/19/2015 |
5/20/2015 |
5/21/2015 |
5/22/2015 |
5/23/2015 |
5/24/2015 |
5/25/2015 |
5/26/2015 |
5/27/2015 |
5/28/2015 |
5/29/2015 |
5/30/2015 |
5/31/2015 |
6/1/2015 |
6/2/2015 |
6/3/2015 |
6/4/2015 |
6/5/2015 |
6/6/2015 |
6/7/2015 |
6/8/2015 |
6/9/2015 |
6/10/2015 |
6/11/2015 |
6/12/2015 |
6/13/2015 |
6/14/2015 |
6/15/2015 |
6/16/2015 |
6/17/2015 |
6/18/2015 |
6/19/2015 |
6/20/2015 |
6/21/2015 |
6/22/2015 |
6/23/2015 |
6/24/2015 |
6/25/2015 |
6/26/2015 |
6/27/2015 |
6/28/2015 |
6/29/2015 |
6/30/2015 |
7/1/2015 |
7/2/2015 |
7/3/2015 |
7/4/2015 |
7/5/2015 |
7/6/2015 |
7/7/2015 |
7/8/2015 |
7/9/2015 |
7/10/2015 |
7/11/2015 |
7/12/2015 |
7/13/2015 |
7/14/2015 |
7/15/2015 |
7/16/2015 |
7/17/2015 |
7/18/2015 |
7/19/2015 |
7/20/2015 |
7/21/2015 |
7/22/2015 |
7/23/2015 |
7/24/2015 |
7/25/2015 |
7/26/2015 |
7/27/2015 |
7/28/2015 |
7/29/2015 |
7/30/2015 |
7/31/2015 |
8/1/2015 |
8/2/2015 |
8/3/2015 |
8/4/2015 |
8/5/2015 |
8/6/2015 |
8/7/2015 |
8/8/2015 |
8/9/2015 |
8/10/2015 |
8/11/2015 |
8/12/2015 |
8/13/2015 |
8/14/2015 |
8/15/2015 |
8/16/2015 |
8/17/2015 |
8/18/2015 |
8/19/2015 |
8/20/2015 |
8/21/2015 |
8/22/2015 |
8/23/2015 |
8/24/2015 |
8/25/2015 |
8/26/2015 |
8/27/2015 |
8/28/2015 |
8/29/2015 |
8/30/2015 |
8/31/2015 |
9/1/2015 |
9/2/2015 |
9/3/2015 |
9/4/2015 |
9/5/2015 |
9/6/2015 |
9/7/2015 |
9/8/2015 |
9/9/2015 |
9/10/2015 |
9/11/2015 |
9/12/2015 |
9/13/2015 |
9/14/2015 |
9/15/2015 |
9/16/2015 |
9/17/2015 |
9/18/2015 |
9/19/2015 |
9/20/2015 |
9/21/2015 |
9/22/2015 |
9/23/2015 |
9/24/2015 |
9/25/2015 |
9/26/2015 |
9/27/2015 |
9/28/2015 |
9/29/2015 |
9/30/2015 |
10/1/2015 |
10/2/2015 |
10/3/2015 |
10/4/2015 |
10/5/2015 |
10/6/2015 |
10/7/2015 |
10/8/2015 |
10/9/2015 |
10/10/2015 |
10/11/2015 |
10/12/2015 |
10/13/2015 |
10/14/2015 |
10/15/2015 |
10/16/2015 |
10/17/2015 |
10/18/2015 |
10/19/2015 |
10/20/2015 |
10/21/2015 |
10/22/2015 |
10/23/2015 |
10/24/2015 |
10/25/2015 |
10/26/2015 |
10/27/2015 |
10/28/2015 |
10/29/2015 |
10/30/2015 |
10/31/2015 |
11/1/2015 |
11/2/2015 |
11/3/2015 |
11/4/2015 |
11/5/2015 |
11/6/2015 |
11/7/2015 |
11/8/2015 |
11/9/2015 |
11/10/2015 |
11/11/2015 |
11/12/2015 |
11/13/2015 |
11/14/2015 |
11/15/2015 |
11/16/2015 |
11/17/2015 |
11/18/2015 |
11/19/2015 |
11/20/2015 |
11/21/2015 |
11/22/2015 |
11/23/2015 |
11/24/2015 |
11/25/2015 |
11/26/2015 |
11/27/2015 |
11/28/2015 |
11/29/2015 |
11/30/2015 |
12/1/2015 |
12/2/2015 |
12/3/2015 |
12/4/2015 |
12/5/2015 |
12/6/2015 |
12/7/2015 |
12/8/2015 |
12/9/2015 |
12/10/2015 |
12/11/2015 |
12/12/2015 |
12/13/2015 |
12/14/2015 |
12/15/2015 |
12/16/2015 |
12/17/2015 |
12/18/2015 |
12/19/2015 |
12/20/2015 |
12/21/2015 |
12/22/2015 |
12/23/2015 |
12/24/2015 |
12/25/2015 |
12/26/2015 |
12/27/2015 |
12/28/2015 |
12/29/2015 |
12/30/2015 |
12/31/2015 |
1/1/2016 |
1/2/2016 |
1/3/2016 |
1/4/2016 |
1/5/2016 |
1/6/2016 |
1/7/2016 |
1/8/2016 |
1/9/2016 |
1/10/2016 |
1/11/2016 |
1/12/2016 |
1/13/2016 |
1/14/2016 |
1/15/2016 |
1/16/2016 |
1/17/2016 |
1/18/2016 |
1/19/2016 |
1/20/2016 |
1/21/2016 |
1/22/2016 |
1/23/2016 |
1/24/2016 |
1/25/2016 |
1/26/2016 |
1/27/2016 |
1/28/2016 |
1/29/2016 |
1/30/2016 |
1/31/2016 |
2/1/2016 |
2/2/2016 |
2/3/2016 |
2/4/2016 |
2/5/2016 |
2/6/2016 |
2/7/2016 |
2/8/2016 |
2/9/2016 |
2/10/2016 |
2/11/2016 |
2/12/2016 |
2/13/2016 |
2/14/2016 |
2/15/2016 |
2/16/2016 |
2/17/2016 |
2/18/2016 |
2/19/2016 |
2/20/2016 |
2/21/2016 |
2/22/2016 |
2/23/2016 |
2/24/2016 |
2/25/2016 |
2/26/2016 |
2/27/2016 |
2/28/2016 |
2/29/2016 |
3/1/2016 |
3/2/2016 |
3/3/2016 |
3/4/2016 |
3/5/2016 |
3/6/2016 |
3/7/2016 |
3/8/2016 |
3/9/2016 |
3/10/2016 |
3/11/2016 |
3/12/2016 |
3/13/2016 |
3/14/2016 |
3/15/2016 |
3/16/2016 |
3/17/2016 |
3/18/2016 |
3/19/2016 |
3/20/2016 |
3/21/2016 |
3/22/2016 |
3/23/2016 |
3/24/2016 |
3/25/2016 |
3/26/2016 |
3/27/2016 |
3/28/2016 |
3/29/2016 |
3/30/2016 |
3/31/2016 |
4/1/2016 |
4/2/2016 |
4/3/2016 |
4/4/2016 |
4/5/2016 |
4/6/2016 |
4/7/2016 |
4/8/2016 |
4/9/2016 |
4/10/2016 |
4/11/2016 |
4/12/2016 |
4/13/2016 |
4/14/2016 |
4/15/2016 |
4/16/2016 |
4/17/2016 |
4/18/2016 |
4/19/2016 |
4/20/2016 |
4/21/2016 |
4/22/2016 |
4/23/2016 |
4/24/2016 |
4/25/2016 |
4/26/2016 |
4/27/2016 |
4/28/2016 |
4/29/2016 |
4/30/2016 |
5/1/2016 |
5/2/2016 |
5/3/2016 |
5/4/2016 |
5/5/2016 |
5/6/2016 |
5/7/2016 |
5/8/2016 |
5/9/2016 |
5/10/2016 |
5/11/2016 |
5/12/2016 |
5/13/2016 |
5/14/2016 |
5/15/2016 |
5/16/2016 |
5/17/2016 |
5/18/2016 |
5/19/2016 |
5/20/2016 |
5/21/2016 |
5/22/2016 |
5/23/2016 |
5/24/2016 |
5/25/2016 |
5/26/2016 |
5/27/2016 |
5/28/2016 |
5/29/2016 |
5/30/2016 |
5/31/2016 |
6/1/2016 |
6/2/2016 |
6/3/2016 |
6/4/2016 |
6/5/2016 |
6/6/2016 |
6/7/2016 |
6/8/2016 |
6/9/2016 |
6/10/2016 |
6/11/2016 |
6/12/2016 |
6/13/2016 |
6/14/2016 |
6/15/2016 |
6/16/2016 |
6/17/2016 |
6/18/2016 |
6/19/2016 |
6/20/2016 |
6/21/2016 |
6/22/2016 |
6/23/2016 |
6/24/2016 |
6/25/2016 |
6/26/2016 |
6/27/2016 |
6/28/2016 |
6/29/2016 |
6/30/2016 |
7/1/2016 |
7/2/2016 |
7/3/2016 |
7/4/2016 |
7/5/2016 |
7/6/2016 |
7/7/2016 |
7/8/2016 |
7/9/2016 |
7/10/2016 |
7/11/2016 |
7/12/2016 |
7/13/2016 |
7/14/2016 |
7/15/2016 |
7/16/2016 |
7/17/2016 |
7/18/2016 |
7/19/2016 |
7/20/2016 |
7/21/2016 |
7/22/2016 |
7/23/2016 |
7/24/2016 |
7/25/2016 |
7/26/2016 |
7/27/2016 |
7/28/2016 |
7/29/2016 |
7/30/2016 |
7/31/2016 |
8/1/2016 |
8/2/2016 |
8/3/2016 |
8/4/2016 |
8/5/2016 |
8/6/2016 |
8/7/2016 |
8/8/2016 |
8/9/2016 |
8/10/2016 |
8/11/2016 |
8/12/2016 |
8/13/2016 |
8/14/2016 |
8/15/2016 |
8/16/2016 |
8/17/2016 |
8/18/2016 |
8/19/2016 |
8/20/2016 |
8/21/2016 |
8/22/2016 |
8/23/2016 |
8/24/2016 |
8/25/2016 |
8/26/2016 |
8/27/2016 |
8/28/2016 |
8/29/2016 |
8/30/2016 |
8/31/2016 |
9/1/2016 |
9/2/2016 |
9/3/2016 |
9/4/2016 |
9/5/2016 |
9/6/2016 |
9/7/2016 |
9/8/2016 |
9/9/2016 |
9/10/2016 |
9/11/2016 |
9/12/2016 |
9/13/2016 |
9/14/2016 |
9/15/2016 |
9/16/2016 |
9/17/2016 |
9/18/2016 |
9/19/2016 |
9/20/2016 |
9/21/2016 |
9/22/2016 |
9/23/2016 |
9/24/2016 |
9/25/2016 |
9/26/2016 |
9/27/2016 |
9/28/2016 |
9/29/2016 |
9/30/2016 |
10/1/2016 |
10/2/2016 |
10/3/2016 |
10/4/2016 |
10/5/2016 |
10/6/2016 |
10/7/2016 |
10/8/2016 |
10/9/2016 |
10/10/2016 |
10/11/2016 |
10/12/2016 |
10/13/2016 |
10/14/2016 |
10/15/2016 |
10/16/2016 |
10/17/2016 |
10/18/2016 |
10/19/2016 |
10/20/2016 |
10/21/2016 |
10/22/2016 |
10/23/2016 |
10/24/2016 |
10/25/2016 |
10/26/2016 |
10/27/2016 |
10/28/2016 |
10/29/2016 |
10/30/2016 |
10/31/2016 |
11/1/2016 |
11/2/2016 |
11/3/2016 |
11/4/2016 |
11/5/2016 |
11/6/2016 |
11/7/2016 |
11/8/2016 |
11/9/2016 |
11/10/2016 |
11/11/2016 |
11/12/2016 |
11/13/2016 |
11/14/2016 |
11/15/2016 |
11/16/2016 |
11/17/2016 |
11/18/2016 |
11/19/2016 |
11/20/2016 |
11/21/2016 |
11/22/2016 |
11/23/2016 |
11/24/2016 |
11/25/2016 |
11/26/2016 |
11/27/2016 |
11/28/2016 |
11/29/2016 |
11/30/2016 |
12/1/2016 |
12/2/2016 |
12/3/2016 |
12/4/2016 |
12/5/2016 |
12/6/2016 |
12/7/2016 |
12/8/2016 |
12/9/2016 |
12/10/2016 |
12/11/2016 |
12/12/2016 |
12/13/2016 |
12/14/2016 |
12/15/2016 |
12/16/2016 |
12/17/2016 |
12/18/2016 |
12/19/2016 |
12/20/2016 |
12/21/2016 |
12/22/2016 |
12/23/2016 |
12/24/2016 |
12/25/2016 |
12/26/2016 |
12/27/2016 |
12/28/2016 |
12/29/2016 |
12/30/2016 |
12/31/2016 |
1/1/2017 |
1/2/2017 |
1/3/2017 |
1/4/2017 |
1/5/2017 |
1/6/2017 |
1/7/2017 |
1/8/2017 |
1/9/2017 |
1/10/2017 |
1/11/2017 |
1/12/2017 |
1/13/2017 |
1/14/2017 |
1/15/2017 |
1/16/2017 |
1/17/2017 |
1/18/2017 |
1/19/2017 |
1/20/2017 |
1/21/2017 |
1/22/2017 |
1/23/2017 |
1/24/2017 |
1/25/2017 |
1/26/2017 |
1/27/2017 |
1/28/2017 |
1/29/2017 |
1/30/2017 |
1/31/2017 |
2/1/2017 |
2/2/2017 |
2/3/2017 |
2/4/2017 |
2/5/2017 |
2/6/2017 |
2/7/2017 |
2/8/2017 |
2/9/2017 |
2/10/2017 |
2/11/2017 |
2/12/2017 |
2/13/2017 |
2/14/2017 |
2/15/2017 |
2/16/2017 |
2/17/2017 |
2/18/2017 |
2/19/2017 |
2/20/2017 |
2/21/2017 |
2/22/2017 |
2/23/2017 |
2/24/2017 |
2/25/2017 |
2/26/2017 |
2/27/2017 |
2/28/2017 |
3/1/2017 |
3/2/2017 |
3/3/2017 |
3/4/2017 |
3/5/2017 |
3/6/2017 |
3/7/2017 |
3/8/2017 |
3/9/2017 |
3/10/2017 |
3/11/2017 |
3/12/2017 |
3/13/2017 |
3/14/2017 |
3/15/2017 |
3/16/2017 |
3/17/2017 |
3/18/2017 |
3/19/2017 |
3/20/2017 |
3/21/2017 |
3/22/2017 |
3/23/2017 |
3/24/2017 |
3/25/2017 |
3/26/2017 |
3/27/2017 |
3/28/2017 |
3/29/2017 |
3/30/2017 |
3/31/2017 |
4/1/2017 |
4/2/2017 |
4/3/2017 |
4/4/2017 |
4/5/2017 |
4/6/2017 |
4/7/2017 |
4/8/2017 |
4/9/2017 |
4/10/2017 |
4/11/2017 |
4/12/2017 |
4/13/2017 |
4/14/2017 |
4/15/2017 |
4/16/2017 |
4/17/2017 |
4/18/2017 |
4/19/2017 |
4/20/2017 |
4/21/2017 |
4/22/2017 |
4/23/2017 |
4/24/2017 |
4/25/2017 |
4/26/2017 |
4/27/2017 |
4/28/2017 |
4/29/2017 |
4/30/2017 |
5/1/2017 |
5/2/2017 |
5/3/2017 |
5/4/2017 |
5/5/2017 |
5/6/2017 |
5/7/2017 |
5/8/2017 |
5/9/2017 |
5/10/2017 |
5/11/2017 |
5/12/2017 |
5/13/2017 |
5/14/2017 |
5/15/2017 |
5/16/2017 |
5/17/2017 |
5/18/2017 |
5/19/2017 |
5/20/2017 |
5/21/2017 |
5/22/2017 |
5/23/2017 |
5/24/2017 |
5/25/2017 |
5/26/2017 |
5/27/2017 |
5/28/2017 |
5/29/2017 |
5/30/2017 |
5/31/2017 |
6/1/2017 |
6/2/2017 |
6/3/2017 |
6/4/2017 |
6/5/2017 |
6/6/2017 |
6/7/2017 |
6/8/2017 |
6/9/2017 |
6/10/2017 |
6/11/2017 |
6/12/2017 |
6/13/2017 |
6/14/2017 |
6/15/2017 |
6/16/2017 |
6/17/2017 |
6/18/2017 |
6/19/2017 |
6/20/2017 |
6/21/2017 |
6/22/2017 |
6/23/2017 |
6/24/2017 |
6/25/2017 |
6/26/2017 |
6/27/2017 |
6/28/2017 |
6/29/2017 |
6/30/2017 |
7/1/2017 |
7/2/2017 |
7/3/2017 |
7/4/2017 |
7/5/2017 |
7/6/2017 |
7/7/2017 |
7/8/2017 |
7/9/2017 |
7/10/2017 |
7/11/2017 |
7/12/2017 |
7/13/2017 |
7/14/2017 |
7/15/2017 |
7/16/2017 |
7/17/2017 |
7/18/2017 |
7/19/2017 |
7/20/2017 |
7/21/2017 |
7/22/2017 |
7/23/2017 |
7/24/2017 |
7/25/2017 |
7/26/2017 |
7/27/2017 |
7/28/2017 |
7/29/2017 |
7/30/2017 |
7/31/2017 |
8/1/2017 |
8/2/2017 |
8/3/2017 |
8/4/2017 |
8/5/2017 |
8/6/2017 |
8/7/2017 |
8/8/2017 |
8/9/2017 |
8/10/2017 |
8/11/2017 |
8/12/2017 |
8/13/2017 |
8/14/2017 |
8/15/2017 |
8/16/2017 |
8/17/2017 |
8/18/2017 |
8/19/2017 |
8/20/2017 |
8/21/2017 |
8/22/2017 |
8/23/2017 |
8/24/2017 |
8/25/2017 |
8/26/2017 |
8/27/2017 |
8/28/2017 |
8/29/2017 |
8/30/2017 |
8/31/2017 |
9/1/2017 |
9/2/2017 |
9/3/2017 |
9/4/2017 |
9/5/2017 |
9/6/2017 |
9/7/2017 |
9/8/2017 |
9/9/2017 |
9/10/2017 |
9/11/2017 |
9/12/2017 |
9/13/2017 |
9/14/2017 |
9/15/2017 |
9/16/2017 |
9/17/2017 |
9/18/2017 |
9/19/2017 |
9/20/2017 |
9/21/2017 |
9/22/2017 |
9/23/2017 |
9/24/2017 |
9/25/2017 |
9/26/2017 |
9/27/2017 |
9/28/2017 |
9/29/2017 |
9/30/2017 |
10/1/2017 |
10/2/2017 |
10/3/2017 |
10/4/2017 |
10/5/2017 |
10/6/2017 |
10/7/2017 |
10/8/2017 |
10/9/2017 |
10/10/2017 |
10/11/2017 |
10/12/2017 |
10/13/2017 |
10/14/2017 |
10/15/2017 |
10/16/2017 |
10/17/2017 |
10/18/2017 |
10/19/2017 |
10/20/2017 |
10/21/2017 |
10/22/2017 |
10/23/2017 |
10/24/2017 |
10/25/2017 |
10/26/2017 |
10/27/2017 |
10/28/2017 |
10/29/2017 |
10/30/2017 |
10/31/2017 |
11/1/2017 |
11/2/2017 |
11/3/2017 |
11/4/2017 |
11/5/2017 |
11/6/2017 |
11/7/2017 |
11/8/2017 |
11/9/2017 |
11/10/2017 |
11/11/2017 |
11/12/2017 |
11/13/2017 |
11/14/2017 |
11/15/2017 |
11/16/2017 |
11/17/2017 |
11/18/2017 |
11/19/2017 |
11/20/2017 |
11/21/2017 |
11/22/2017 |
11/23/2017 |
11/24/2017 |
11/25/2017 |
11/26/2017 |
11/27/2017 |
;
run;
if 05/27/2014<=BirthDate<05/27/2015 then year=1;
else if 05/27/2015<=BirthDate<05/27/2016 then year=2;
else if 05/27/2016<=BirthDate<05/27/2017 then year=3;
else if BirthDate>=05/27/2017 then year=4;
run;
proc freq data=want1;
table year;
run;
Wrong results:
SAS Output
year | Frequency | Percent | Cumulative Frequency |
Cumulative Percent |
---|---|---|---|---|
4 | 20207 | 100.00 | 20207 | 100.00 |
data:
SAS Output
first you didnt read corretly with input statement like
input birthdate :mmddyy10.;
a
nd then you need sas date constants like this
if '27may/2014'd<=BirthDate<'27may2015'd then year=1;
first you didnt read corretly with input statement like
input birthdate :mmddyy10.;
a
nd then you need sas date constants like this
if '27may/2014'd<=BirthDate<'27may2015'd then year=1;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.