About kebowers

kebowers · ‎02-16-2016

I am not sure that solves the problem. Maybe my real question is how to I inialize a new variable with something other than 0. I want it to be the final value of the totfem variable. I had created all these counting variables to keep track of how many male and female insects died each day as well as the total number of insects. What I need is the last value of totfem to be the initial value of a new variable (livefem). From there I think I can write a do loop to subtract the daily value of sumfem. data sasuser.sumhome; set sasuser.sorthome; retain sumadult sumfem summale sumegg cnt days sumlost; by Date2; days = Date2-Date1; if first.Date2 then do; sumlost =0; sumadult = 0; sumfem = 0; summale = 0; sumegg = 0; cnt = 0; end; sumlost= sumlost+lost; sumadult = sumadult+alive; sumfem = sumfem+deadfem; summale = summale+deadmale; sumegg= sumegg+eggs; cnt= cnt+1; if last.Date2 then output; run; data sasuser.hometot; set sasuser.sumhome; retain sumadult sumfem summale sumegg cnt days totfem ; by Date2; drop Cage Lost Alive Eggs; totfem+sumfem; run;

kebowers · ‎01-29-2016

Hii, I have some insect data where I have counts insects (Sum Adults), but I don't know if they're males or females until they die and are dissected (DeadFem and DeadMale). When they are all dead, then I summed up how many there total (TotFem). I want to know how many females there are on a given date to do a fecundity calculations (#females/#eggs laid). Date SumAdults DeadFem DeadMale TotFem 18 Apr 17 0 0 0 22 Apr 14 1 2 1 25 Apr 12 2 0 3 . . and so on. The last entry in TotFem tells me how many total females I had, so then I want a variable that starts at that value and subtracts the value of DeadFem for each date.

kebowers · ‎11-18-2015

Hi, I am doing a survival analysis and each row of data contains a date and the number of subjects (separated into female and male dead by columns) that died on that date. For example 16Nov 2015 3 1 18 Nov 2015 5 2 The first line would mean 3 females and 1 male died on 16 Nov and the second would mean 5 females and 2 maled died on 18 Nov. In order to run proc lifetest I need each of the dates where more than 1 subject died to be its own observation, like this: 16 Nov 2015 1 0 16 Nov 2015 1 0 16 Nov 2015 1 0 16 Nov 2015 0 1 18 Nov 2015 1 0 18 Nov 2015 1 0 18 Nov 2015 1 0 18 Nov 2015 1 0 18 Nov 2015 1 0 18 Nov 2015 0 1 18 Nov 2015 0 1 Suggestions greatly appreciated, Kristen

Online Status	Offline
Date Last Visited	‎02-17-2016 08:51 AM

Re: Summing variable and then counting back down

Summing variable and then counting back down

Creating multiple observations from a single observation

Re: Summing variable and then counting back down

Summing variable and then counting back down

Creating multiple observations from a single observation