BookmarkSubscribeRSS Feed
matti77
Calcite | Level 5

I'm having a problem that should be easy to solve, but my SAS experience is quite weak. My dataset have multiple records per case, with each record containing data for a single episode = number of days spent on a given hospital unit. I want to divide the number of days spent on each hospital unit with the total number of days spent on all hospital units. I have attached a simplified example of the data structure and added a column of what I want to add to the data.

 

Appeciate all suggestions,

 

Mats

1 REPLY 1
mohamed_zaki
Barite | Level 11
proc sql ;
select *, days/SUM (days)  as weight
from have
group by id;
quit;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 760 views
  • 0 likes
  • 2 in conversation