Hi all,   I would like to create cycle windows for variables that contain several 'day' timepoints within one cycle.   So, I have values that look like this:   Visit DATE C1 Day 1 01AUG2017 C1 Day  5 04AUG2017 C2 Day 1 15AUG2017 C2 Day 5 19AUG2017 C3 Day 1 25AUG2017 C3 Day 15 05SEP2017 C4 Day 1 10SEP2017     And I would like to create new variables that display the start and end date within each cycle- where the end date is one day before the start of the next cycle.  New variables:  Cycle, Cycle Start, Cycle End.  I'm not sure how to get the end date.  Maybe with lag or something?  Any help is greatly appreciated!!     This is the logic...   Visit DATE CYCLE CYCLE START CYCLE END C1 Day 1 01AUG2017 Cycle 1 01AUG2015 14AUG2017 C1 Day  5 04AUG2017 Cycle 1 01AUG2015 14AUG2015 C2 Day 1 15AUG2017 Cycle 2 15AUG2017 24AUG2017 C2 Day 5 19AUG2017 Cycle 2 15AUG2017 24AUG2017 C3 Day 1 25AUG2017 Cycle 3 25AUG2017 09SEP2017 C3 Day 15 05SEP2017 Cycle 3 25AUG2017 09SEP2017 C4 Day 1 10SEP2017           but this is how it should look so I can join to other tables:   CYCLE  CYCLE_START CYCLE_END C1 01AUG2015 14AUG2017 C2 15AUG2017 24AUG2017 C3 25AUG2017 09SEP2017   Here is where I started for the start date... data want set have (keep=patient visit vsdat); if scan(visit,3)='1' then do; cycle_start=date; Cycle=scan(visit,1); ... View more

Hi!   I have a race text variable that can have multiple values for race:   RACE Asian, White White Black, White Asian, Black   How can I use a find all occurrences of say, Asian, and assign a numeric value?  I know it is not using 'contains' but this is an example of what I'm trying to do.  Maybe index?   data want; set have; if c then do; ord=1; if race contains ('White') then sord=6; else if race contains ('Black') then sord=4; else if race contains ('Asian') then sord=3; end; run;     ... View more

Hi!     I have string values with Cycle 1 Day 1 Cycle 1 Day 15 Cycle 2 Day 1 . . Cycle 23 Day 1 Cycle 23 Day 15   I want to output 'Day 1' observations regardless of cycle.  Using index, is outputting a Day 15's as well since it 'contains' Day 1.   data want set have if index(visit, "Day 1") then do; cycle = input(scan(VISIT, 2), 3.); end; if cycle ne ''  ; run;     Help is appreciated!   ... View more

Hi!  more questions!   I have output results that look like this form summing by subject and reset to zero with each new date.  How can I output just the last observation BY date ( so I just get the final sum by date and not the running total)?  These are results from same subject.   02OCT2017 81 81 02OCT2017 22 103 02OCT2017 39 142 11DEC2017 93 93 11DEC2017 23 116 11DEC2017 57 173   This is outputting the last subject of all dates, but I need last subject at each new date encountered. data out; set in by patient dat; if last.patient; run; ... View more

Hi!   Hi!  I'm having issues summing by subject  and date.  I need the sum to reset to zero when encountering a new date (by subject).  Here is my code;   data want; set have; by patient date; if first.patient and res ^= . then targetsum=res; else if res ^= . then targetsum+res; output; end; run; Here a sample of output for one subject. you can see the totals are not resetting with new date.   02OCT2017 81 81 02OCT2017 22 103 02OCT2017 39 142 11DEC2017 93 235 11DEC2017 23 258 11DEC2017 57 315   ... View more

Hi!   I have three variables, that need to be joined to one variable and output to new line separate by backslash.  Sorry...so weird to explain!!     I tried:   data final1; length class $300.; set final; class=sys||'/'||'~n/'||hiterm||'/'||'~n/'|| lowterm; run;   proc print data=final1; run;   I need to one variable 'class' with concatenated values of sys, hiterm,lowterm on unique line when '/' encountered:   CLASS sys/ hiterm/ lowterm   or sample data output   CLASS Investigation/ Metabolism/ Hyperglycemia     ... View more

Hi all,   I'm trying to do a left join with values of variables in the two tables in different cases.  I am getting a error when trying to do the upcase in the where statement.     proc sql; create table final as select a.*, b.LBTO from allx as a left lbx as b on a.id=b.id where a.upcase(test)=b.upcase(test) and a.upcase(visit)=b.upcase(visit); quit;   help appreciated! ... View more

Hi,   how can I use scan or subtr to keep everything to the right of the first hyphen?     var_have 2 - Some-what 4 - Very much   var_want Some-what Very much   Thanks!       ... View more

  Hi!  I'm trying to pull a word out of a character string and join it with a different char string separated by colon.   For variable DSAE, I have values that look like this: AE: (1) hypertension 16-NOV-2017.  I need to pull out the 'hypertension'   Then I need to join with another variable DSDE , with the two values separated by colon.   I tried this:   if DSAE ne '' then reason = strip(DSDE) || ': ' || scan(DSAE ,3,' '); else if DSAE = '' then reason = strip(DSDE);   But my new variable  REASON is not displaying the new string.   Help appreciated! ... View more

Hi!   I have a value of string variable :   AESOUT 3::4  (this is the value of variable AESOUT)   I need other variables to populate with 'Y' if contains a 3 or a 4    data want; set have;   if findw(aesout,'3')>0 then AESHOSP='Y'; else AESHOSP=''; if findw(aesout,'4')>0 then AESDISAB='Y'; else AESDISAB='';   ...However I am getting null values in the new variables (AESHOSP and AESDISAB) where I am expecting a 'Y'.     Help is appreciated!   ... View more

Hi!     I have values that look like this:   VAR_NAME (3) left hearing 12JAN2017 (14) right hearing 30JAN2017   The only thing i need to capture from this value are the numbers within the parentheses.  Can someone help me use a scan or substr to capture this (or other function) ?     Thanks!             ... View more

I just need a space!  But i'm not getting one 😞   _1=strip(put(mean, 8.1)) ||  " (" || strip(put(std, 10.2)) || ")");   so output should look like:  64.0 (11.00) .  But i'm getting 64.0(11.00)         Thanks! ... View more