cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
dcd
‎03-13-2019
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Create a Dummy Variable based on values in multiple different rows

by Calcite | Level 5 in New SAS User
‎02-20-2019 05:37 AM
‎02-20-2019 05:37 AM
This works perfectly, thanks! ... View more

Re: Create a Dummy Variable based on values in multiple different rows

by Calcite | Level 5 in New SAS User
‎02-20-2019 04:40 AM
‎02-20-2019 04:40 AM
I tried adding a counter to make it work in both cases, instead it stopped working in either one.    data want; array possible_days {1:1000} _temporary_ (1000*0); events=0; do until (end_of_have); set have end=end_of_have; if Thing=1 then do; events+1; d=max(day-30, 1) to day; possible_days{d}=1; end; end; if events=0 then do; d=day-29 to 1000; possible_days{d}=.; end; drop d; drop events; do until (end_of_have); set have end=end_of_have; early_warning=possible_days{day}; output; end; run;  However the code seems like it should work? (more likely I'm just clueless I guess)   The log locates the errors in the  d=max(day-30, 1) to day; d=day-29 to 1000; lines saying 'syntax error' and 'expecting arithmetic operator' respectively.  ... View more

Re: Create a Dummy Variable based on values in multiple different rows

by Calcite | Level 5 in New SAS User
‎02-20-2019 03:16 AM
‎02-20-2019 03:16 AM
I was just clarifying to novinosrin. I only now got the chance to try what you suggested but I'm getting an empty table when the Thing is always 0. Any idea why is that?   Also there is an out of subscript error when Thing happens on say day 10 but that's easy to fix. ... View more

Re: Create a Dummy Variable based on values in multiple different rows

by Calcite | Level 5 in New SAS User
‎02-19-2019 02:37 PM
‎02-19-2019 02:37 PM
In want2 early_warning is 0 up to day 19 because we do have info up to day 55 -that is more than 30 days later- that there is no triggering event. In day 28 we don't have info for 30 days -day 55 is only 27 days away- so we can't be sure, hence I'd like a null there. ... View more

Create a Dummy Variable based on values in multiple different rows

by Calcite | Level 5 in New SAS User
‎02-19-2019 12:21 PM
‎02-19-2019 12:21 PM
Hello, I'd very much appreciate a certain amount of help with this. This is my current data:   data WORK.HAVE; infile datalines dsd truncover; input Thing:32. Day:32.; datalines; 0 1 0 4 0 11 0 14 0 19 0 28 0 35 0 41 1 48 1 55 ;;;;   I want to create an Early_Warning dummy Variable that will take the value of 1, if Thing is happening with the next 30 days. So in this case this is what the result should look like:   data WORK.WANT; infile datalines dsd truncover; input Thing:32. Day:32. Early_Warning:32.; datalines; 0 1 0 0 4 0 0 11 0 0 14 0 0 19 1 0 28 1 0 35 1 0 41 1 1 48 1 1 55 1 ;;;;   Lastly, if we can't be sure whether Thing is happening within the next 30 days, I want the Early_Warning to be null and the data should look like this.   data WORK.WANT2; infile datalines dsd truncover; input Thing:32. Day:32. Early_Warning:32.; datalines; 0 1 0 0 4 0 0 11 0 0 14 0 0 19 0 0 28 . 0 35 . 0 41 . 0 48 . 0 55 . ;;;;     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-13-2019 11:45 AM
Quick links