Hi,
I think there's a simple solution to this problem, but I can't find it for the life of me.
I have a wide dataset of about 800 people that includes all the visits they made to their doctors over a period of 2 years. Some people visited once (everyone had to visit at least once to be included) and some visited many times- one person had 910 visits. For each visit, I have a continuous number that indicates the amount of time the doctor spent on that visit. For each patient, I want to add up all the times over the two year period so that each patient has one "total" time value. I want the missing values to count as zeroes. If there were not many visits, I would just use the sum statement, like:
total_time=sum(time1,time2,time3);
But do I really have to write it out 910 times?? I tried using a dash:
total_time=sum(time1-time910);
But total_time was missing as a result of doing that.
Is there any other way? Thanks so much in advance.
Laurie
totat=sum(OF time1-time910);
totat=sum(OF time1-time910);
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.