You get the idea. Inconveniently, in this particular case, I received the data in an Excel file and when I uploaded the file all of the dates were in character format. Here is a simple fix.<\/p>\n
- \n
- Create an array of the character dates. Takes one statement. Note that you need that $ to indicate character variables.<\/li>\n
- Create an array of your numeric dates. Takes one statement. Leave OFF the $ to indicate these are NOT character variables.<\/li>\n
- Use a DO loop to fix any data problems, read into the new numeric variable and subtract 21,916. This is the number of days difference between the reference date for SAS and for Excel. You can read more about that here<\/a>.<\/li>\n
- Not required but good practice , since I was not going to use the character date values, I dropped those from the data set as well as the j subscript variable.<\/li>\n<\/ol>\n
data fixdata ;
\nset fix1;
\narray chardates {9} $ birthdate date_app date_assess date_eligible date_ipe date_closed\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>date_employ date_int_completed date_last_contact
\n;
\narray numdates {9} date_birth app_date assess_date eligible_date ipe_date closed_date employ_date
\nint_completed_date last_contact_date
\n;
\n** Change all date variables to exclude invalid dates ;
\n** And from Excel to SAS date format ;<\/code>
\ndo j = 1 to 9 ;
\nif chardates{j} = \"0000-00-00\" then numdates{j} = . ;
\nelse numdates{j} = chardates{j} - 21916 ;
\nend;
\ndrop j birthdate date_app date_assess date_eligible date_ipe date_closed date_employ\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 date_int_completed date_last_contact;<\/code><\/p>\n<\/p>\n
\nI live in opposite world. I blog on SAS and statistics for fun and make games for a living. Check out Making Camp Premium. Learn about Ojibwe culture, brush up your math skills, learn more English and have fun. All for under two bucks.<\/a><\/p>\n
- Not required but good practice , since I was not going to use the character date values, I dropped those from the data set as well as the j subscript variable.<\/li>\n<\/ol>\n
![\"Making](\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2018\/07\/making_camp-300x300.png\")
<\/a><\/p>\n