Hi SAS users!   I have 3 flags: flag_REF1, flag_REF2, flag_REF3 and where each flag is noted (=1), then I want to void that corresponding REF value. So in short I'm trying to produce the following steps but in a local macro: 1. flag_REF1=1 then REF1=.; 2. flag_REF2=1 then REF2=.; 3. flag_REF3=1 then REF3=.;   However, it's not working. Any thoughts on where I'm going wrong?   data want; set have; options mprint; %macro loop;  %local i;   %do i=1 %to 3;   %if flag_REF&i=1 %then %do; REF&i=.; %end;    %end; %mend loop; %loop;   Thanks!   run; ... View more

Hi SAS Users,   Could you help me figure out how to calculate duration of event dates and number of events based on a moving criteria? I would like to assign an event number based on any new event that occurs 30 days after the last grouping.  Below is my sample dataset, initial code and the wanted dataset. You can see from the wanted dataset, that once the duration exceeds 30 days, then a new event number is created and the count to 30 days starts over (e.g. subject=A1 date_event=03/19/2017).  I'm struggling with how to create the new events.   TIA, Sophie   data have; input SubjectID $3 date_event; informat date_event mmddyy10.; format date_event mmddyy10.; datalines; A1 10/12/2016 A1 11/05/2016 A1 11/06/2016 A1 03/19/2017 A1 04/01/2017 A1 08/08/2018 A1 09/01/2017 B2 12/10/2018 B2 12/14/2018 B2 01/03/2019 B2 06/20/2019 B2 07/02/2019 ;; run;   　 proc sql; create table days30 as select distinct a.SubjectID, a.date_event as date1, b.date_event as date2 from have as a left join have as b on a.SubjectID=b.SubjectID order by a.SubjectID, a.date_event ; quit;   data days30; set days30; duration_event=intck('day',date1,date2); run;     data want; input SubjectID $ date_event duration_event no_event; informat date_event mmddyy10.; format date_event mmddyy10.; datalines; A1 10/12/2016 0 1 A1 11/05/2016 24 1 A1 11/06/2016 25 1 A1 03/19/2017 0 2 A1 04/01/2017 13 2 A1 08/08/2018 0 3 A1 09/01/2018 24 3 B2 12/10/2018 0 1 B2 12/14/2018 4 1 B2 01/03/2019 24 1 B2 06/20/2019 0 2 B2 07/02/2019 12 12 ;; run;   ... View more

Dear SAS community-   I would like to create new columns based on existing values in the original columns.  I have the part of the code figured out where I can create new column names based on the original columns using a combination of arrays and the vname function. However, I cannot figure out how to specify that I only want the column name if there is a non-missing value in the original column.  "Have" is my starting dataset. "Want" is the dataset I would like.  Below those two is my current code.  Any suggestions?   Thanks!   data have; input SubID $ apple pear orange; datalines; AA 1 . 1 BB 1 2 8 CC 3 . . DD . 4 3 ;;   final dataset; SubjectID fruit1 fruit2 fruit3 AA apple . orange BB apple pear orange CC apple . . DD . pear orange   data want; set have; array new_fruit(3) $25 fruit1 - fruit3 ; retain fruit1 - fruit3; array old_fruit(3) apple pear orange ; do i = 1 to 3; if old_fruit(i) ^=. then do;  *This part is not right though I can't figure out how to revise; new_fruit(i) = vname(old_fruit(i)); end; end; drop i ; run ;   ... View more

Hi SAS users-   I originally had a numeric variable, SubjectID, that had a length of 6 but the value displayed was up to 11 digits.  I accidentally thought this numeric variable was actually a character, so I converted it to numeric even though it was already numeric. (See SAS code below for my conversion step.)   This resulted in truncated values of the original variable, e.g. 20000000021 is now 20000000.  Is there anyway to retrieve the original value of SubjectID?  Or is it gone for good?   Thanks!   data convert; set have (rename=(SubjectID=chrx_SubjectID));   length SubjectID 8. SubjectID=input(chrx_SubjectID,8.); run; ... View more

Dear SAS users,   Do you have suggestions on how I can create different start and stop dates based on noncontinuous data points?  For example, for each observation I want to create variables mon_start1, mon_end1, mon_start2, mon_end2, mon_start3, mon_end3, etc.  I can create mon_start1 and mon_end1, but cannot figure out how to calculate the remaining variables (mon_start2, mon_end2, mon_start3, mon_end3, etc.)    Here's a sample dataset for months Jan 2015 - Dec 2016 along with the beginning sas code where I created variables mon_start1 and mon_end1.   For example, for ID=AA, the start/end variables should be as follows: mon_start1=1, mon_end1=6, mon_start2=10, mon_end2=18, mon_start3=22,  mon_end3=24   data have; input id $ dob mmddyy10. total_mon mon1-mon24; format dob monyy7.; datalines; AA 01/11/2015 18 1 1 1 1 1 1 . . . 1 1 1 1 1 1 1 1 1 . . . 1 1 1 BB 01/29/2015 24 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 CC 08/23/2015 13 . . . . . . . 1 1 1 1 1 1 1 1 1 . . 1 1 1 1 . . DD 02/11/2015 20 . 1 1 1 . . . 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 EE 03/12/2016 8 . . . . . . . . . . . . . . 1 1 1 1 . 1 1 1 1 . ;   data have2; set have; start=1;   Mon_Start1=(intck('month','01Jan2015'd,dob))+1;   array month mon:; do m=Mon_Start1-start+1 to dim(month) while(month[m]); end;   if m>=24 then Mon_end1=total_mon; else Mon_End1=m-1; run;   Thanks! ... View more

Hi SAS community-   I would like to retain multiple variables within groups.  I can figure out how to retain 1 variable, but cannot get my code to do the 2nd variable in the way that I would like within groups.  Here's current sas code along with my 'want' dataset. My starting dataset has just the 3 variables: id, count and date.   Thanks!   proc sort data=have; by id; data want; set have; by id; retain date_r1-date_r3; if first.id then date_r1=date; ????   run;   data have; input id count date date_r1 date_r2 date_r3; datalines; aa 1 01/20/2014 . . . aa 2 03/24/2015 01/20/2014 . . aa 3 04/23/2015 01/20/2014 03/24/2015 . bb 1 10/23/2013 . . . bb 2 03/24/2015 10/23/2013 . . cc 3 08/10/2014 . . . dd . . . . . dd 2 05/19/2014 . . . ee 1 03/02/2014 . . . ee 2 03/19/2013 03/02/2014 . . ee 3 04/23/2015 03/02/2014 03/19/2013 . ee 4 10/12/2015 03/02/2014 03/19/2013 04/23/2015   ... View more