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: 
DataPanda99
  • 7 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received
This widget could not be displayed.

Re: SAS Join Datasets with Calendar dates

by Fluorite | Level 6 in SAS Programming
‎06-20-2023 10:00 PM
‎06-20-2023 10:00 PM
Thank you, Kurt_Bremser! ... View more

Re: SAS Join Datasets with Calendar dates

by Fluorite | Level 6 in SAS Programming
‎06-20-2023 09:59 PM
‎06-20-2023 09:59 PM
Thank you Patrick! ... View more

SAS Join Datasets with Calendar dates

by Fluorite | Level 6 in SAS Programming
‎06-20-2023 04:01 AM
‎06-20-2023 04:01 AM
Hi Folks, I'm not a everyday SAS user but got stuck with this. Any help is highly appreciated. I have two datasets 1 & 2 and require to build an output like below using 1 and 2 datasets. Thanks in advance!   Dataset - 1 ID DATE Measure1 101 1-Jul-22 5 101 3-Jul-22 8 101 4-Jul-22 4 101 6-Jul-22 7 101 7-Jul-22 2 . . . . . . 101 31-Jul-22 3   Dataset-2 ID DATE Measure2 101 1-Jul-22 2 101 2-Jul-22 3 101 3-Jul-22 4 101 5-Jul-22 2 101 7-Jul-22 2 . . . . . . 101 31-Jul-22 5 Output desired: ID DATE Measure1 Measure2 101 1-Jul-22 5 2 101 2-Jul-22   3 101 3-Jul-22 8 4 101 4-Jul-22 4   101 5-Jul-22   2 101 6-Jul-22 7   101 7-Jul-22 2 2 . . . . . . . . 101 31-Jul-22 3 5 ... View more

Re: SAS logic help

by Fluorite | Level 6 in SAS Programming
‎07-16-2021 08:03 AM
‎07-16-2021 08:03 AM
Thanks a lot! Now I got it. 🙂 ... View more

Re: SAS logic help

by Fluorite | Level 6 in SAS Programming
‎07-16-2021 07:53 AM
‎07-16-2021 07:53 AM
Thank you but it's slightly not working.  I have added few more observations and when I run this it should come as N but coming in as Y.   23 15SEP2020:08:55:39 15SEP2020:09:27:12 N 24 15SEP2020:09:46:28 15SEP2020:09:46:51 N 25 15SEP2020:10:01:55 15SEP2020:10:02:30 N 26 15SEP2020:10:02:37 15SEP2020:10:03:00 N ... View more

Re: SAS logic help

by Fluorite | Level 6 in SAS Programming
‎07-16-2021 07:14 AM
‎07-16-2021 07:14 AM
Apologies for not explaining it properly earlier, I will try my best to explain here.. Let's take row number 19 onwards...Call entered at 09:17:33 and call connected at 10:07:03 and the next customer (row no-20) call entered at 09:24:44 and call connected at 09:26:08 (basically call connected earlier than the previous customer who was in a queue) and flagged as Y and the next customers (21&22) calls connected earlier than 19th customer though they called after 19th customer so flagged as Y. ... View more

SAS logic help

by Fluorite | Level 6 in SAS Programming
‎07-16-2021 06:52 AM
‎07-16-2021 06:52 AM
Hi Experts, Require your help on this. I have tried my best with LAG function but didn't work for all the scenarios. I have the TimeIn and TimeOut fields and have to create the Flag below. Thanks a lot for the help.   RowNo. TimeIn TimeOut Flag 1 14SEP2020:08:02:31 14SEP2020:08:02:31 N 2 14SEP2020:08:02:53 14SEP2020:08:04:19 N 3 14SEP2020:08:03:38 14SEP2020:08:04:57 N 4 14SEP2020:08:15:25 14SEP2020:08:25:39 N 5 14SEP2020:08:20:13 14SEP2020:08:20:38 Y 6 14SEP2020:08:49:01 14SEP2020:09:50:59 N 7 14SEP2020:08:53:43 14SEP2020:09:18:27 Y 8 14SEP2020:09:17:33 14SEP2020:10:07:03 N 9 14SEP2020:09:24:44 14SEP2020:09:26:08 Y 10 14SEP2020:09:27:15 14SEP2020:10:00:23 Y 11 14SEP2020:09:43:23 14SEP2020:09:43:26 Y 12 15SEP2020:08:02:31 15SEP2020:08:02:31 N 13 15SEP2020:08:02:53 15SEP2020:08:04:19 N 14 15SEP2020:08:03:38 15SEP2020:08:04:57 N 15 15SEP2020:08:15:25 15SEP2020:08:25:39 N 16 15SEP2020:08:20:13 15SEP2020:08:20:38 Y 17 15SEP2020:08:49:01 15SEP2020:09:50:59 N 18 15SEP2020:08:53:43 15SEP2020:09:18:27 Y 19 15SEP2020:09:17:33 15SEP2020:10:07:03 N 20 15SEP2020:09:24:44 15SEP2020:09:26:08 Y 21 15SEP2020:09:27:15 15SEP2020:10:00:23 Y 22 15SEP2020:09:43:23 15SEP2020:09:43:26 Y ... View more
Contact Me
Likes given to
View All
Quick links