Converting days to years using proc format

[saza]

I was able to create a new variable called 'Age' which = number of years of age the person was at the time of symptoms onset using this code:

data Age;
	set HospitalDays;
	Age = (dateSymptoms - DOB);
	format Age years. 
	run;

It worked perfectly! however, even when I used format Age years. the numbers are displayed as days from DOB to symptoms vs years.  

[PaigeMiller · Accepted solution]

Formats won't get the job done in this case. They can display dates as year, but your variable Age is not a date.

In an earlier thread, you said your lab asked you to use a specific function to do this. What function was it, and did you try that? If not, please try it.

[saza]

data Age;
set HospitalDays;
Age = yrdif(DOB, dateSymptoms);
run;

Hi Paige! I just needed to tweak my proc transpose to make the rest of my code work. the code above worked to help me some for the years,