topic Converting days to years using proc format in Statistical Procedures

Converting days to years using proc format

saza — Sat, 26 Feb 2022 16:40:50 GMT

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.

Re: Converting days to years using proc format

PaigeMiller — Sat, 26 Feb 2022 17:11:02 GMT

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.

Re: Converting days to years using proc format

saza — Sat, 26 Feb 2022 17:15:59 GMT

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,