I have 2 tables I need to create a new table where the key doesn't match here is example TABLE 1 ID. date. key A. 06/01/15. 1 A. 06/02/16. 23 here is example TABLE 2 ID. date. key A. 06/01/15. 3 A. 06/02/16. 23 here what I want to see TABLE 3 ID. date. key A. 06/02/16. 3 The key 1 is not needed ... I'm kicking around merge I just need the key where there is no match thanks ... View more

Hi team I'm working on 2 tables an I need to determine if table1  service A was done within 2 min of table2  service B.. And also  to determine how many  service B  did not have any service A here is example TABLE 1 ID.    Ser    Start.                                        End Qw.    A     23May2016:00:34:00.     23May2016:00:40:00 TABLE 2   ID.    Ser    Start.                                        End   Qw.   B    23May2016:00:35:00.     23May2016:00:41:00   In the example table One open within 2 min of the 2nd service I would want to see table two in a dataset That's first part  here is 2nd part  TABLE 1   ID.    Ser    Start.                                        End   Qw.    A     26May2016:00:29:00.     26May2016:00:40:00   TABLE 2   ID.    Ser    Start.                                        End   Qw.    A     26May2016:00:38:00.     26May2016:00:40:00 On this example what it's showing is there was a service B but no service A open up within 2 min I would want that on its own dataset .... thanks again  for help ay   ... View more

I have table that shows when machine was rebooted which eq action code key xy and when it was service action code key gh col of table id key, action key start date dt End date dt time duration What I need is to determine is when there was an action key xy was there a action code key gh.. thst falls within 0 to 2 min if yes create dataset if action key eq xy and no gh within 0 tO 2 min create data setb for it ..data looks like this           ; Id. Key. Action key start date dt. End date dt dur A1 40 Gh 25 may 2016;00:01:00 25 may 2016;05:00. 4 min duration A1 34. Xy 25 may 2016;00:02:00 25 may 2016;00:18:00. 17 min duration I want a dataset where start from xy an gh falls within 2 min Id. Key. Action key start date dt. End date dt dur A1 40 Gh 25 may 2016;00:01:00 25 may 2016;05:00. 4 min duration A1 34. Xy 25 may 2016;00:08:00 25 may 2016;00:18:00. 10 min duration and a dataset of xy where gh didn't overlap 2 min thank you again In the bottom I was tinkering with it but running circles lol oc sql;      create table overlap as      select a.site_id, a.machine as a_machine, ....      from log_tbl as A, log_tbl as B      where a.site_id=b.site_id and a.start_dttm<b.start_dttm and a.end_dttm>b.start_dttm      ; quit; ... View more

Hi I have a table that has a date column I need to determine what week out of the month was it week1 week2 week3 week4...enclose is a sample of what I have an what I need it to look Id. Date A1. 01/01/16 A2. 01/16/16 A1. 01/26/16 Want Id. Date. Week A1. 01/01/16. Week1 A2. 01/16/16. Week2 A1. 01/26/16. Week4 thanks in advance ... View more

Hi I have a table that has the time set at eastern time I need it to be local time depending what time zone... Here is example STATE. START. END. TX. 02/07/16 01:59 AM. 02/07/16 02:02 AM I need that to convert to local texas time..... I can add zip code actually I have a column that has time off set which shows an -60. ... View more

Hi I have a macro Data _null_;start _ date = today ();; Call symput ('dt' , " ' "||put(start_date-1 ,yymmdd10.)||" ' "); Call symput ('dt', " ' "||put (end _ date -1,yymmdd10.)||" ' "); It doesn't bring any info because the data that I'm pulling from is a datetime 25.6 How do I convert my macro to pick up the datetime25.6 format? ... View more