I have one variable called date_of_birth that is a numeric value with default length 8.  A couple of the values are 82902 (which is August 29, 2002) and 111797 (which is November 17, 1997).  I'll be creating a second variable, date_last_visit, in which I'll need to calculate age at time of date_last_visit.  Date_last_visit will be July 4, 2022 for everyone.  Any ideas how to code this?  I've started by trying to format the date_of_birth variable by coding DOB=put(date_of_birth,mmddyy8.) with no success.  Thanks! ... View more

I have two separate Excel files (Data1.xlsx and Data2.xlsx) that both have fields ID and last_name.  I am exporting both of those data sets to separate permanent SAS datasets, needing the length and format of each field to be exported the same.  In Data1.xlsx, the longest last_name I have is "Gooligan" and in Data2.xlsx, the longest last_name I have is "Van Driverson." I am able to export them, but when I go to append the 2 SAS datasets, the last_name in the second dataset gets truncated to 8 characters (since Gooligan is the max of 8 characters in first dataset.)  How do I expand last_name in Data1.xlsx to 13 characters prior to exporting it to a permanent SAS dataset so that the files will append without truncation?   I realize I can append the files initially in Excel, but the SAS datasets need to be used later on for other reasons and need them to be the same structure.  Thanks! ... View more

I have a variable SCH_DATE in a data set that is currently numeric with default 8 length. Some of the data reflected in this field looks like the following in month, day, year order: 120968 52192 101481 91565 Ultimately, I want the SCH_DATE to look as follows, to include leading 0s: 120968 052192 101481 091565 How do I make the conversion? ... View more