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: 
SAS_Learner2
‎05-05-2023
  • 13 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Want Calculate hour differences based on condition

by Calcite | Level 5 in SAS Programming
‎05-04-2023 03:13 AM
‎05-04-2023 03:13 AM
Thanks, Flag2 variable coming correct. but date2 variable is not having the expected value when Flag2 = "Y". For the 5th row date2 should have value 18AUG2022:07:26:00.   How to store that value in separate/same variable ? Please help     ... View more

Re: consecutive date variable duration

by Calcite | Level 5 in SAS Programming
‎04-28-2023 12:30 PM
‎04-28-2023 12:30 PM
Thank you for your prompt response. Yes, we have to take absolute days with they are going to negative. There should not be any flag if only only date1 or/and date2 are present.   Many Thanks.     ... View more

Re: consecutive date variable duration

by Calcite | Level 5 in SAS Programming
‎04-28-2023 10:29 AM
‎04-28-2023 10:29 AM
Sorry, My bad. It should be days only not hours.   ... View more

consecutive date variable duration

by Calcite | Level 5 in SAS Programming
‎04-28-2023 10:14 AM
‎04-28-2023 10:14 AM
Hello,   I have n number of variables. I want to calculate consecutive date variable difference and if duration is 50 days then I want flag that particular record. Below 001 subject has 5 dates .. If date3-date1 or date4-date2 or date5-date3 is 50 days then flag as "Y". 002 has only one date1 so no need to flag. if we have 10 dates for any subject we should calculate date3-date1, date4-date2, date5-date3, date6-date4 so on.   id    date1 date2 date3 date4 date5 001 13JUL2021 24FEB2022 28MAY2021 07JUN2021 28JUN2021 002 15NOV2021 . . . . .       ... View more

want to handle multiple conditions. Please help

by Calcite | Level 5 in SAS Programming
‎04-27-2023 07:20 AM
‎04-27-2023 07:20 AM
Hello Friends, I am facing challenge to get flagging variables to be derived.   Have data: ID Body_Part Rash_Date 001 SR 18APR2022:20:00:00 001 SR 24OCT2022:19:01:00 001 SR 04NOV2021:21:00:00 001 SR 05AUG2022:18:00:00 001 SR,KL 05OCT2021:21:00:00 001 SR,KL 09OCT2021:14:14:00 001 EL 29JAN2022:21:00:00 001 EL 04NOV2021:21:00:00 001 KL 14DEC2022:19:00:00 001 KL 26MAR2022:12:04:00 001 KL 05APR2022:21:00:00 001 KL 14FEB2022:21:00:00 001 KL 13SEP2022:19:26:00 001 KL 28NOV2021:18:42:00 001 KL 04FEB2022:09:00:00 001 KL 05AUG2022:18:00:00 001 KL 15SEP2021:15:00:00 001 KL 30JAN2022:23:27:00 001 KL 24SEP2021:21:04:00 001 KL 20SEP2022:08:58:00 001 KL 30NOV2021:20:59:00 001 KL 24OCT2022:19:01:00 001 KL 01DEC2021:20:53:00 001 KL 29MAR2022:22:38:00 001 KL 29DEC2021:00:38:00 001 KL 13APR2022:18:35:00 001 KL 28JUN2022:19:00:00 001 KL 09NOV2022:19:59:00 001 KL 22NOV2021:23:37:00 001 KL 22JUN2022:19:19:00 001 KL 09JUN2022:17:02:00 001 KL 17JAN2022:21:00:00 001 KL 12JUN2022:22:01:00 001 KL 15FEB2022:13:51:00 001 KL 21JAN2022:21:00:00 001 KL 01NOV2021:21:00:00 001 KL 24JAN2022:15:57:00 001 KL 15MAY2022:08:01:00 001 KL 10JAN2022:19:40:00 001 KL 10MAY2022:19:01:00 001 KL 10AUG2022:15:00:00 001 KL 03MAY2022:18:00:00 001 KL 19OCT2022:19:54:00 001 KL 13FEB2022:21:00:00 001 KL 07JAN2022:21:00:00 001 KL 02MAY2022:18:17:00 001 KL 22SEP2021:21:57:00 001 KL 30SEP2021:21:00:00 001 KL 05JAN2022:00:13:00 001 CR 19OCT2022:20:54:00 001 CR 13SEP2022:19:26:00 001 CR 28JUN2022:19:00:00 001 CR, SR 22JUN2022:19:19:00 001 SR 05AUG2022:18:01:00 001 SR,FR,S U_R 28NOV2021:16:42:00 001 TR 02MAY2022:17:18:00 1. I want to create a flag whenever there is a rash on new body Part. data want1 (drop = Body_Part); set have; by id Body_Part Rash_Date; do i = 1 to while (scan(body_Part,i,",") ^= ' '); n_body_Part = scan(body_Part,i, ' '); output; end; run; data want2; set want1(rename = body_Part=n_body_Part); by id body_Part Rash_date; if first.bodyPart then A1 = "Y"; run; Output will come like below:   ID Body_Part Rash_Date New_Body_Part 001 SR 18APR2022:20:00:00 Y 001 SR 22JUN2022:19:19:00 001 SR 05AUG2022:18:00:00 001 SR 24OCT2022:19:01:00 001 KL 26MAR2022:12:04:00 Y 001 KL 29MAR2022:22:38:00 001 KL 05APR2022:21:00:00 001 KL 13APR2022:18:35:00 001 KL 02MAY2022:18:17:00 001 KL 02MAY2022:18:17:00 001 KL 03MAY2022:18:00:00 001 KL 10MAY2022:19:01:00 001 KL 15MAY2022:08:01:00 001 KL 09JUN2022:17:02:00 001 KL 12JUN2022:22:01:00 001 KL 22JUN2022:19:19:00 001 KL 28JUN2022:19:00:00 001 KL 05AUG2022:18:00:00 001 KL 10AUG2022:15:00:00 001 KL 13SEP2022:19:26:00 001 KL 20SEP2022:08:58:00 001 KL 19OCT2022:19:54:00 001 KL 24OCT2022:19:01:00 001 KL 09NOV2022:19:59:00 001 KL 14DEC2022:19:00:00 001 KR 22JUN2022:19:19:00 Y 001 KR 28JUN2022:19:00:00 001 KR 13SEP2022:19:26:00 001 KR 19OCT2022:20:54:00 001 SR 05AUG2022:18:01:00 Y 001 TR 02MAY2022:17:18:00 Y 001 TR 02MAY2022:17:18:00 001 SR 05OCT2021:21:00:00 Y 001 SR 05OCT2021:21:00:00 001 SR 09OCT2021:14:14:00 001 SR 04NOV2021:21:00:00 001 A UR 28NOV2021:16:42:00 Y 001 A UR 28NOV2021:16:42:00 001 EL 04NOV2021:21:00:00 Y 001 EL 29JAN2022:21:00:00 001 EL 29JAN2022:21:00:00 001 FR 28NOV2021:16:42:00 Y 001 FR 28NOV2021:16:42:00 001 KL 15SEP2021:15:00:00 Y 001 KL 22SEP2021:21:57:00 001 KL 22SEP2021:21:57:00 001 KL 24SEP2021:21:04:00 001 KL 24SEP2021:21:04:00 001 KL 30SEP2021:21:00:00 001 KL 30SEP2021:21:00:00 001 KL 05OCT2021:21:00:00 001 KL 05OCT2021:21:00:00 001 KL 09OCT2021:14:14:00 001 KL 01NOV2021:21:00:00 001 KL 22NOV2021:23:37:00 001 KL 22NOV2021:23:37:00 001 KL 28NOV2021:18:42:00 001 KL 28NOV2021:18:42:00 001 KL 30NOV2021:20:59:00 001 KL 30NOV2021:20:59:00 001 KL 01DEC2021:20:53:00 001 KL 29DEC2021:00:38:00 001 KL 05JAN2022:00:13:00 001 KL 07JAN2022:21:00:00 001 KL 10JAN2022:19:40:00 001 KL 17JAN2022:21:00:00 001 KL 21JAN2022:21:00:00 001 KL 24JAN2022:15:57:00 001 KL 30JAN2022:23:27:00 001 KL 04FEB2022:09:00:00 001 KL 13FEB2022:21:00:00 001 KL 13FEB2022:21:00:00 001 KL 14FEB2022:21:00:00 001 KL 14FEB2022:21:00:00 001 KL 15FEB2022:13:51:00 001 SR 28NOV2021:16:42:00 Y 001 SR 28NOV2021:16:42:00   2. I want to create another flag variable Repeat_Part when the hours difference between Rash date time and last drug adminstration date time for the same body Part if it is more than 50 hours then Repeat Part = "Y" There can be multiple rashes at differnt body Parts. ID Body_Part Rash_Date New_Body_Part cur_rashdt_lst_inf_date Repeat_Part 001 SR 18APR2022:20:00:00 Y 001 SR 22JUN2022:19:19:00 001 SR 05AUG2022:18:00:00 001 SR 24OCT2022:19:01:00 001 KL 26MAR2022:12:04:00 Y 001 KL 29MAR2022:22:38:00 001 KL 05APR2022:21:00:00 001 KL 13APR2022:18:35:00 001 KL 02MAY2022:18:17:00 001 KL 02MAY2022:18:17:00 001 KL 03MAY2022:18:00:00 001 KL 10MAY2022:19:01:00 001 KL 15MAY2022:08:01:00 001 KL 09JUN2022:17:02:00 001 KL 12JUN2022:22:01:00 001 KL 22JUN2022:19:19:00 001 KL 28JUN2022:19:00:00 001 KL 05AUG2022:18:00:00 001 KL 10AUG2022:15:00:00 001 KL 13SEP2022:19:26:00 001 KL 20SEP2022:08:58:00 001 KL 19OCT2022:19:54:00 001 KL 24OCT2022:19:01:00 001 KL 09NOV2022:19:59:00 001 KL 14DEC2022:19:00:00 001 KR 22JUN2022:19:19:00 Y 001 KR 28JUN2022:19:00:00 001 KR 13SEP2022:19:26:00 001 KR 19OCT2022:20:54:00 001 SR 05AUG2022:18:01:00 Y 001 TR 02MAY2022:17:18:00 Y 001 TR 02MAY2022:17:18:00 001 SR 05OCT2021:21:00:00 Y 001 SR 05OCT2021:21:00:00 001 SR 09OCT2021:14:14:00 001 SR 04NOV2021:21:00:00 001 A UR 28NOV2021:16:42:00 Y 001 A UR 28NOV2021:16:42:00 001 EL 04NOV2021:21:00:00 Y 001 EL 29JAN2022:21:00:00 001 EL 29JAN2022:21:00:00 001 FR 28NOV2021:16:42:00 Y 001 FR 28NOV2021:16:42:00 001 KL 15SEP2021:15:00:00 Y 001 KL 22SEP2021:21:57:00 001 KL 22SEP2021:21:57:00 001 KL 24SEP2021:21:04:00 001 KL 24SEP2021:21:04:00 001 KL 30SEP2021:21:00:00 001 KL 30SEP2021:21:00:00 001 KL 05OCT2021:21:00:00 001 KL 05OCT2021:21:00:00 001 KL 09OCT2021:14:14:00 001 KL 01NOV2021:21:00:00 001 KL 22NOV2021:23:37:00 001 KL 22NOV2021:23:37:00 001 KL 28NOV2021:18:42:00 001 KL 28NOV2021:18:42:00 001 KL 30NOV2021:20:59:00 001 KL 30NOV2021:20:59:00 001 KL 01DEC2021:20:53:00 001 KL 29DEC2021:00:38:00 001 KL 05JAN2022:00:13:00 001 KL 07JAN2022:21:00:00 001 KL 10JAN2022:19:40:00 001 KL 17JAN2022:21:00:00 001 KL 21JAN2022:21:00:00 001 KL 24JAN2022:15:57:00 001 KL 30JAN2022:23:27:00 001 KL 04FEB2022:09:00:00 001 KL 13FEB2022:21:00:00 001 KL 13FEB2022:21:00:00 001 KL 14FEB2022:21:00:00 001 KL 14FEB2022:21:00:00 001 KL 15FEB2022:13:51:00 001 SR 28NOV2021:16:42:00 Y 001 SR 28NOV2021:16:42:00 3. Once repeat_Part creted with Y when condition satisfies.. I want to further check the rashes which is coming at same body Part and its rash datetime difference not falling < 50 hours when compSRed with New_Body_Part="Y" or Repeat_Rash = Y its Drug adminstration date. If duration between repeated rash at same locaiton date time minus last rash (which has New_Body_Part = "Y" or Repeat_Part = "Y") hours differnce is more than 50 hours I want flag "Y" for RepeaTRash_gt50hours. ID BodyPart Rash_Date New_Body_Part cur_rashdt_lst_inf_date Repeat_Part RepeaTRash_gt50hours 001 SR 18APR2022:20:00:00 Y 001 SR 22JUN2022:19:19:00 001 SR 05AUG2022:18:00:00 001 SR 24OCT2022:19:01:00 001 KL 26MAR2022:12:04:00 Y 001 KL 29MAR2022:22:38:00 001 KL 05APR2022:21:00:00 001 KL 13APR2022:18:35:00 001 KL 02MAY2022:18:17:00 001 KL 02MAY2022:18:17:00 001 KL 03MAY2022:18:00:00 001 KL 10MAY2022:19:01:00 001 KL 15MAY2022:08:01:00 001 KL 09JUN2022:17:02:00 001 KL 12JUN2022:22:01:00 001 KL 22JUN2022:19:19:00 001 KL 28JUN2022:19:00:00 001 KL 05AUG2022:18:00:00 001 KL 10AUG2022:15:00:00 001 KL 13SEP2022:19:26:00 001 KL 20SEP2022:08:58:00 001 KL 19OCT2022:19:54:00 001 KL 24OCT2022:19:01:00 001 KL 09NOV2022:19:59:00 001 KL 14DEC2022:19:00:00 001 KR 22JUN2022:19:19:00 Y 001 KR 28JUN2022:19:00:00 001 KR 13SEP2022:19:26:00 001 KR 19OCT2022:20:54:00 001 SR 05AUG2022:18:01:00 Y 001 TR 02MAY2022:17:18:00 Y 001 TR 02MAY2022:17:18:00 001 SR 05OCT2021:21:00:00 Y 001 SR 05OCT2021:21:00:00 001 SR 09OCT2021:14:14:00 001 SR 04NOV2021:21:00:00 001 A UR 28NOV2021:16:42:00 Y 001 A UR 28NOV2021:16:42:00 001 EL 04NOV2021:21:00:00 Y 001 EL 29JAN2022:21:00:00 001 EL 29JAN2022:21:00:00 001 FR 28NOV2021:16:42:00 Y 001 FR 28NOV2021:16:42:00 001 KL 15SEP2021:15:00:00 Y 001 KL 22SEP2021:21:57:00 001 KL 22SEP2021:21:57:00 001 KL 24SEP2021:21:04:00 001 KL 24SEP2021:21:04:00 001 KL 30SEP2021:21:00:00 001 KL 30SEP2021:21:00:00 001 KL 05OCT2021:21:00:00 001 KL 05OCT2021:21:00:00 001 KL 09OCT2021:14:14:00 001 KL 01NOV2021:21:00:00 001 KL 22NOV2021:23:37:00 001 KL 22NOV2021:23:37:00 001 KL 28NOV2021:18:42:00 001 KL 28NOV2021:18:42:00 001 KL 30NOV2021:20:59:00 001 KL 30NOV2021:20:59:00 001 KL 01DEC2021:20:53:00 001 KL 29DEC2021:00:38:00 001 KL 05JAN2022:00:13:00 001 KL 07JAN2022:21:00:00 001 KL 10JAN2022:19:40:00 001 KL 17JAN2022:21:00:00 001 KL 21JAN2022:21:00:00 001 KL 24JAN2022:15:57:00 001 KL 30JAN2022:23:27:00 001 KL 04FEB2022:09:00:00 001 KL 13FEB2022:21:00:00 001 KL 13FEB2022:21:00:00 001 KL 14FEB2022:21:00:00 001 KL 14FEB2022:21:00:00 001 KL 15FEB2022:13:51:00 001 SR 28NOV2021:16:42:00 Y 001 SR 28NOV2021:16:42:00 Notes to consider while creting Repeat_Part variable: a. If single body Part rash have multiple drug admistrations then take max of from the list drug adminstation (03MAY2022:21:00:00) into consideraiton to calculate hours difference. vis. KL 02MAY2022:18:17:00 03MAY2022:00:17:00 KL 02MAY2022:18:17:00 03MAY2022:21:00:00 It has multiple adminstraitons for same rash. so we hav to consider 03MAY2022:21:00:00 only this record in final dataset and calculaitons. b. If multiple body Parts has same datetime rashes then we have to consider minimum of any one of the rash last drung adminstation datetime to calculate hours differnce with previous rash. 001 SR,FR,A UR 28NOV2021:16:42:00 This record has multple body Parts rash at same datetime. First we have look for SR,FR,A UR drug adminstration datetime. a. then take maximum of each body Part if either of the Part has multile adminstration for same rash (as explained in point 4) b. then we will have one record for each rash with max drug adminstration datetime. c. from this data take min drug adminstation of these 3 body Parts. d. and calculate hour differnce between current rash date - previous last drug adminstration datetime (c point date). 4. My final dataset should have 8 variables: 1.ID 2.Body_Part 3.Rash_Date 4.New_Body_Part 5.Cur_rashdt_Minus_lst_inf_date_hours 6.Repeat_Part 7.currenTRash_date_minus_lasTRepeaTRash_eq_Y_durg adminstration date in hour. 8. RepeaTRash_gt_50hours. If rashs happended at multple body Parts at same then it should come only in one record. ID Body_Part Rash_Date 001 KL 15SEP2021:15:00:00 001 KL 22SEP2021:21:57:00 001 KL 24SEP2021:21:04:00 001 KL 30SEP2021:21:00:00 001 SR,KL 05OCT2021:21:00:00 001 SR,KL 09OCT2021:14:14:00 001 KL 01NOV2021:21:00:00 001 EL 04NOV2021:21:00:00 001 SR 04NOV2021:21:00:00 001 KL 22NOV2021:23:37:00 001 SR,FR,A UR 28NOV2021:16:42:00 001 KL 28NOV2021:18:42:00 001 KL 30NOV2021:20:59:00 001 KL 01DEC2021:20:53:00 001 KL 29DEC2021:00:38:00 001 KL 05JAN2022:00:13:00 001 KL 07JAN2022:21:00:00 001 KL 10JAN2022:19:40:00 001 KL 17JAN2022:21:00:00 001 KL 21JAN2022:21:00:00 001 KL 24JAN2022:15:57:00 001 EL 29JAN2022:21:00:00 001 KL 30JAN2022:23:27:00 001 KL 04FEB2022:09:00:00 001 KL 13FEB2022:21:00:00 001 KL 14FEB2022:21:00:00 001 KL 15FEB2022:13:51:00 001 KL 26MAR2022:12:04:00 001 KL 29MAR2022:22:38:00 001 KL 05APR2022:21:00:00 001 KL 13APR2022:18:35:00 001 SR 18APR2022:20:00:00 001 TR 02MAY2022:17:18:00 001 KL 02MAY2022:18:17:00 001 KL 03MAY2022:18:00:00 001 KL 10MAY2022:19:01:00 001 KL 15MAY2022:08:01:00 001 KL 09JUN2022:17:02:00 001 KL 12JUN2022:22:01:00 001 KL 22JUN2022:19:19:00 001 CR, SR 22JUN2022:19:19:00 001 KL 28JUN2022:19:00:00 001 CR 28JUN2022:19:00:00 001 KL 05AUG2022:18:00:00 001 SR 05AUG2022:18:00:00 001 SR 05AUG2022:18:01:00 001 KL 10AUG2022:15:00:00 001 CR 13SEP2022:19:26:00 001 KL 13SEP2022:19:26:00 001 KL 20SEP2022:08:58:00 001 KL 19OCT2022:19:54:00 001 CR 19OCT2022:20:54:00 001 SR 24OCT2022:19:01:00 001 KL 24OCT2022:19:01:00 001 KL 09NOV2022:19:59:00 001 KL 14DEC2022:19:00:00   ... View more

Re: Want to compare one variable multiple variable values and create f...

by Calcite | Level 5 in SAS Programming
‎04-24-2023 03:57 PM
‎04-24-2023 03:57 PM
Now I have ten locations. How can I write for multiple location variables?   ... View more

Re: Want to compare one variable multiple variable values and create f...

by Calcite | Level 5 in SAS Programming
‎04-24-2023 03:44 PM
‎04-24-2023 03:44 PM
Yes, Locaiton1 and Location2 are Loc1 and Loc2. I updated names now in question.  I am not seeing any warnings or errors.   ... View more

Want to compare one variable multiple variable values and create flag

by Calcite | Level 5 in SAS Programming
‎04-24-2023 03:35 PM
‎04-24-2023 03:35 PM
  ID Visited Loc1 Loc2 Flag 001 Asia,Africa   Asia Y 001 Europe,USA, UK UK   Y 001 Europe,Australia China Japan N I want create Flag variable whenever if Locaiton1 or Location2 having one of the location in Visited variable.   I am using below code. But not working.   data want; set have; Array loc $ loc1-loc2; do i = 1 to 2; if index(Visited, loc[i])>0 then flag = "Y"; end; Run;   Please help.     ... View more

Want Calculate hour differences based on condition

by Calcite | Level 5 in SAS Programming
‎04-18-2023 01:18 PM
‎04-18-2023 01:18 PM
Hi Folks, I have data like below. When the flag1 variable has "Y" and for the "N" records, we want to take last Flag1 = "Y" or Flag2 = "Y" record date1 value to date2 variable minus current date1 value is greater than 90 hours then flag2 value should be flagged as "Y". then repeat the same logic for remaining records. Below 1st record has Flag1 "Y" so I want to take this date1 record value compare with next Flag1 = "N" records.   For the 22AUG2022 record hour difference is greather than 90 hour so We want to get Flag2 as Y. Then since this is Flag2 = "Y" for record 22AUG2022:02:30:00 I want to take this date1 value further for flag1 = "N" records.   Have: I have data like below. ID date1                         Flag1  1 18AUG2022:07:26:00 Y                                             .            1 19AUG2022:02:30:00 N       1 20AUG2022:03:00:00 N        1 21AUG2022:01:00:00 N        1 22AUG2022:02:30:00 N        1 23AUG2022:01:00:00 N        1 25AUG2022:02:30:00 N        1 26AUG2022:02:00:00 N          Want: ID date1                         Flag1 Date2                             Diff_hr Flag2 1 18AUG2022:07:26:00 Y          .                                    .            1 19AUG2022:02:30:00 N       18AUG2022:07:26:00    19         N 1 20AUG2022:03:00:00 N       18AUG2022:07:26:00    43         N 1 21AUG2022:01:00:00 N       18AUG2022:07:26:00    65         N 1 22AUG2022:02:30:00 N       18AUG2022:07:26:00    91         Y 1 23AUG2022:01:00:00 N       22AUG2022:02:30:00    22         N 1 25AUG2022:02:30:00 N       22AUG2022:02:30:00    72         N 1 26AUG2022:02:00:00 N       22AUG2022:02:30:00    95         Y     ... View more

Want to get previous date value to next record which is less than curr...

by Calcite | Level 5 in SAS Programming
‎04-18-2023 09:54 AM
‎04-18-2023 09:54 AM
Hello,   I have data like below. I am strugging to get the desired output.   ID Date1                          Date2 1 18AUG2022:07:26:00 18AUG2022:16:27:00 1 18AUG2022:07:26:00 19AUG2022:15:00:00 1 19AUG2022:02:30:00 19AUG2022:15:00:00 1 19AUG2022:02:30:00 20AUG2022:11:00:00 1 20AUG2022:03:00:00 20AUG2022:11:00:00 1 20AUG2022:03:00:00 21AUG2022:12:30:00 1 21AUG2022:01:00:00 21AUG2022:12:30:00 1 21AUG2022:01:00:00 22AUG2022:11:30:00 1 22AUG2022:02:30:00 22AUG2022:11:30:00 1 22AUG2022:02:30:00 23AUG2022:12:30:00   I want date3 variable to be created and this value should come previous Date2 records and Date3 value should be less than Date1 value. ID Date1                         Date2                          Date3 1 18AUG2022:07:26:00 18AUG2022:16:27:00 . 1 19AUG2022:02:30:00 19AUG2022:15:00:00 18AUG2022:16:27:00 1 20AUG2022:03:00:00 20AUG2022:11:00:00 19AUG2022:15:00:00 1 21AUG2022:01:00:00 21AUG2022:12:30:00 20AUG2022:11:00:00 1 22AUG2022:02:30:00 22AUG2022:11:30:00 21AUG2022:12:30:00     Please help.         ... View more

Re: want to calculate difference hours from dates

by Calcite | Level 5 in SAS Programming
‎04-14-2023 03:58 AM
‎04-14-2023 03:58 AM
Great thank you for your quick response. ... View more

want to calculate difference hours from dates

by Calcite | Level 5 in SAS Programming
‎04-14-2023 03:36 AM
‎04-14-2023 03:36 AM
  Hello Friends,   I have data below. When Flag1 = "N" I want to get Date2 populated from Date1 variable of last Flag1 = "Y" record value.   In below data row 2 has Flag1 = "Y", therefore I want this row 2 record date1 (22SEP2021:21:57:00) to be populated retained to Flag1 = "N" records. Row3 has Flag1 = "N" Hence I want to populate Date3 with Date1 (22SEP2021:21:57:00) of last Flag1 = "Y" record.   row   ID Date1                                 Flag1                Date2 1       001 15SEP2021:15:00:00       N 2       001 22SEP2021:21:57:00       Y 3       001 24SEP2021:21:04:00       N                     22SEP2021:21:57:00 4       001 30SEP2021:21:00:00       Y 5       001 05OCT2021:21:00:00       N                     30SEP2021:21:00:00 6       001 09OCT2021:14:14:00       N                     30SEP2021:21:00:00     Please suggest the approaching way to get this done.   Thank you in advance.   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-05-2023 10:25 AM
Quick links