topic Re: Creating a new field using dates in SAS Programming

Creating a new field using dates

iced_tea — Tue, 13 Oct 2020 00:07:19 GMT

Hello Community,

Is it something that could be done using SAS?

I have a table like this:

Customer	Start_Date	Rental_Date	Grace_Period	MovieTitle	Movie1	Movie2	Movies_List
12345	13-Mar-13	13-Mar-13	30	Gone Girl	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	13-Mar-13	30	Titanic	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	8-Apr-13	30	Gone Girl	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	8-Apr-13	30	Titanic	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	4-May-13	30	Gone Girl	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	4-May-13	30	Titanic	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	11-Feb-15	30	Hunger Games	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	11-Feb-15	30	Titanic	Gone Girl	Titanic	Gone Girl,Titanic
67890	10-Aug-14	10-Aug-14	30	Pitch Perfect	Pitch Perfect		Pitch Perfect
67890	10-Aug-14	8-Sep-14	30	Pitch Perfect	Pitch Perfect		Pitch Perfect
67890	10-Aug-14	17-Oct-14	30	Pitch Perfect	Pitch Perfect		Pitch Perfect
67890	10-Aug-14	29-Nov-14	30	Pitch Perfect	Pitch Perfect		Pitch Perfect
67890	10-Aug-14	31-Dec-14	30	Booksmart	Pitch Perfect		Pitch Perfect
67890	10-Aug-14	10-Feb-15	30	Booksmart	Pitch Perfect		Pitch Perfect
67890	10-Aug-14	22-May-15	30	Booksmart	Pitch Perfect		Pitch Perfect
67890	10-Aug-14	29-Jun-15	30	Booksmart	Pitch Perfect		Pitch Perfect

… where there are many rows per 1 customer and the table records the dates (Rental_Date) and the movies (MovieTitle) the customer rented on those dates. Sometimes a customer rents more than 1 movie, ex: customer 12345. This customer rented two movies on March 13, 2013.

What I want to do is to create a new column called “Switch_Status” that records whether the customer switched movies after whatever their initial movie/movies selection was. For example, customer 12345 initially rented 2 movies: Gone Girl and Titanic. I want the new column to record “Switch_Status” = “yes” because in the time Rental_Date+Grace_Period, they eventually stopped renting Gone Girl and Titanic, and instead rented Hunger Games and Titanic (February 11, 2015).

The second example customer 67890 is easier to record. Here, this customer initially rented Pitch Perfect and then after Rental_Date+Grace Period, there is evidence that they switched the movie they initially rented (Pitch Perfect), and instead rented Booksmart. So for this customer also, “Switch_Status” would be “yes”.

And obviously, if there is no evidence of switch, I want “Switch_Status” to equal “no”.

Is there any easy way to do this?

Thank you!

Re: Creating a new field using dates

Reeza — Tue, 13 Oct 2020 00:51:32 GMT

Sure, this is doable but I'd say 2 years out is really not within any grace period...

It would help if you showed a smaller, realistic example and the expected outcome. A description goes only so far, whereas showing the expected output for an input data set really helps to illustrate what you're trying to accomplish.

@iced_tea wrote:

Hello Community,

Is it something that could be done using SAS?

I have a table like this:

Customer

Start_Date

Rental_Date

Grace_Period

MovieTitle

Movie1

Movie2

Movies_List

12345

13-Mar-13

13-Mar-13

30

Gone Girl

Gone Girl

Titanic

Gone Girl,Titanic

12345

13-Mar-13

13-Mar-13

30

Titanic

Gone Girl

Titanic

Gone Girl,Titanic

12345

13-Mar-13

8-Apr-13

30

Gone Girl

Gone Girl

Titanic

Gone Girl,Titanic

12345

13-Mar-13

8-Apr-13

30

Titanic

Gone Girl

Titanic

Gone Girl,Titanic

12345

13-Mar-13

4-May-13

30

Gone Girl

Gone Girl

Titanic

Gone Girl,Titanic

12345

13-Mar-13

4-May-13

30

Titanic

Gone Girl

Titanic

Gone Girl,Titanic

12345

13-Mar-13

11-Feb-15

30

Hunger Games

Gone Girl

Titanic

Gone Girl,Titanic

12345

13-Mar-13

11-Feb-15

30

Titanic

Gone Girl

Titanic

Gone Girl,Titanic

67890

10-Aug-14

10-Aug-14

30

Pitch Perfect

Pitch Perfect

Pitch Perfect

67890

10-Aug-14

8-Sep-14

30

Pitch Perfect

Pitch Perfect

Pitch Perfect

67890

10-Aug-14

17-Oct-14

30

Pitch Perfect

Pitch Perfect

Pitch Perfect

67890

10-Aug-14

29-Nov-14

30

Pitch Perfect

Pitch Perfect

Pitch Perfect

67890

10-Aug-14

31-Dec-14

30

Booksmart

Pitch Perfect

Pitch Perfect

67890

10-Aug-14

10-Feb-15

30

Booksmart

Pitch Perfect

Pitch Perfect

67890

10-Aug-14

22-May-15

30

Booksmart

Pitch Perfect

Pitch Perfect

67890

10-Aug-14

29-Jun-15

30

Booksmart

Pitch Perfect

Pitch Perfect

… where there are many rows per 1 customer and the table records the dates (Rental_Date) and the movies (MovieTitle) the customer rented on those dates. Sometimes a customer rents more than 1 movie, ex: customer 12345. This customer rented two movies on March 13, 2013.

What I want to do is to create a new column called “Switch_Status” that records whether the customer switched movies after whatever their initial movie/movies selection was. For example, customer 12345 initially rented 2 movies: Gone Girl and Titanic. I want the new column to record “Switch_Status” = “yes” because in the time Rental_Date+Grace_Period, they eventually stopped renting Gone Girl and Titanic, and instead rented Hunger Games and Titanic (February 11, 2015).

The second example customer 67890 is easier to record. Here, this customer initially rented Pitch Perfect and then after Rental_Date+Grace Period, there is evidence that they switched the movie they initially rented (Pitch Perfect), and instead rented Booksmart. So for this customer also, “Switch_Status” would be “yes”.

And obviously, if there is no evidence of switch, I want “Switch_Status” to equal “no”.

Is there any easy way to do this?

Thank you!

Re: Creating a new field using dates

jimbarbour — Tue, 13 Oct 2020 03:22:46 GMT

I'm wouldn't say this is easy, but it can be done. Here are the results, below, and at the very bottom, the SAS code. Note: I changed the last two rental dates for customer 12345 so that they would be within the 30 day grace period.

Is this what you were looking for?

Jim

DATA	Cust_Movie_Data_Switch;
	DROP	_:;

	SET		Cust_Movie_Data;
		BY	Customer	Rental_Date;

	ARRAY	Prior_Movies	[*]		$32	_Prior_Movie1	_Prior_Movie2;

	FORMAT	_Prior_Rental_Date		DATE9.;
	FORMAT	_Prior2_Rental_Date		DATE9.;
	FORMAT	_Temp_Date				DATE9.;

	LENGTH	_Prior_Movie1			$32;
	LENGTH	_Prior_Movie2			$32;
	LENGTH	_Prior2_Movie1			$32;
	LENGTH	_Prior2_Movie2			$32;
	LENGTH	_Temp1					$32;
	LENGTH	_Temp2					$32;

	Switch_Status					=	'No ';

	_Prior_Customer					=	LAG(Customer);
	_Prior2_Customer				=	LAG2(Customer);
	_Prior_Rental_Date				=	LAG(Rental_Date);
	_Prior2_Rental_Date				=	LAG2(Rental_Date);
	_Prior_Movie1					=	LAG(Movie1);
	_Prior_Movie2					=	LAG(Movie2);
	_Prior2_Movie1					=	LAG2(Movie1);
	_Prior2_Movie2					=	LAG2(Movie2);
	_Prior_Rental_Date				=	LAG(Rental_Date);
	_Temp1							=	Prior_Movies[1];
	_Temp2							=	Prior_Movies[2];

	IF	FIRST.Customer																	THEN
		DO;
			CALL	MISSING(		_Prior_Customer
									,_Prior_Rental_Date
									,_Prior2_Rental_Date
									,_Prior_Movie1
									,_Prior_Movie2
									,_Prior_Rental_Date);
		END;
	
	IF	Rental_Date					=	_Prior_Rental_Date								THEN
		IF	_Prior2_Customer		=	Customer										THEN
			DO;
				_Prior_Rental_Date	=	_Prior2_Rental_Date;
				_Prior_Movie1		=	_Prior2_Movie1;
				_Prior_Movie2		=	_Prior2_Movie2;
			END;
		ELSE
			DO;
				CALL	MISSING(	_Prior_Rental_Date
									,_Prior_Movie1
									,_Prior_Movie2);
			END;

	IF	NOT	MISSING(_Prior_Rental_Date)													THEN
		_Temp_Date					=	INTNX('DAYS', _Prior_Rental_Date, Grace_Period);

	IF	NOT	MISSING(_Prior_Rental_Date)													AND
		Rental_Date					<	INTNX('DAYS', _Prior_Rental_Date, Grace_Period)	THEN
		IF	Movie1				NOT	IN	Prior_Movies									OR
			Movie2				NOT	IN	Prior_Movies									THEN
			DO;
				Switch_Status		=	'Yes';
			END;
RUN;

Re: Creating a new field using dates

iced_tea — Tue, 13 Oct 2020 11:00:00 GMT

Thank you Jim. I really appreciate your taking a look.

The only thing is that - in the case of the last two rental dates for customer 12345 being way outside the 30 days, I still would want this customer to be flagged as "Switch_Status" = "yes".

My apologies. I might have not made it clear. So, if the customer has a different movie/movies within Rental_Date+Grace_Period, then it's no switch. It is a switch if they have different movie/movies AFTER Rental_Date+Grace_Period. Does that make sense?

Re: Creating a new field using dates

jimbarbour — Tue, 13 Oct 2020 14:28:02 GMT

Ah, ah, I see. I misunderstood. I assumed the opposite, that within the grace period was considered a switch.

Let me reverse the logic.

Jim

Re: Creating a new field using dates

jimbarbour — Tue, 13 Oct 2020 14:57:56 GMT

Yes, all I had to do was reverse the less than/greater than symbol. Now record 13 also shows as a switch ("Yes"). Record 13 is a day or two past the grace period.

Results and code are below.

Jim

DATA	Cust_Movie_Data;
	INFILE	DATALINES
		DSD	DLM='09'x	MISSOVER;

	INPUT	Customer		$
			Start_Date		:	ANYDTDTE10.
			Rental_Date		:	ANYDTDTE10.
			Grace_Period	
			MovieTitle		:	$32.
			Movie1			:	$32.
			Movie2			:	$32.
			Movies_List		:	$64.
			;

	FORMAT	Start_Date			DATE9.;
	FORMAT	Rental_Date			DATE9.;

DATALINES;
12345	13-Mar-13	13-Mar-13	30	Gone Girl	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	13-Mar-13	30	Titanic	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	8-Apr-13	30	Gone Girl	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	8-Apr-13	30	Titanic	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	4-May-13	30	Gone Girl	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	4-May-13	30	Titanic	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	11-Feb_15	30	Hunger Games	Hunger Games	Titanic	Hunger Games,Titanic
12345	13-Mar-13	11-Feb_15	30	Titanic	Hunger Games	Titanic	Hunger Games,Titanic
67890	10-Aug-14	10-Aug-14	30	Pitch Perfect	Pitch Perfect	Pitch Perfect
67890	10-Aug-14	8-Sep-14	30	Pitch Perfect	Pitch Perfect	Pitch Perfect
67890	10-Aug-14	17-Oct-14	30	Pitch Perfect	Pitch Perfect	Pitch Perfect
67890	10-Aug-14	29-Nov-14	30	Pitch Perfect	Pitch Perfect	Pitch Perfect
67890	10-Aug-14	31-Dec-14	30	Booksmart	Booksmart	Booksmart
67890	10-Aug-14	10-Feb-15	30	Booksmart	Booksmart	Booksmart
67890	10-Aug-14	22-May-15	30	Booksmart	Booksmart	Booksmart
67890	10-Aug-14	29-Jun-15	30	Booksmart	Booksmart	Booksmart
;
RUN;

PROC	SORT		DATA=Cust_Movie_Data;
	BY	Customer	Rental_Date;
RUN;

DATA	Cust_Movie_Data_Switch;
	DROP	_:;

	SET		Cust_Movie_Data;
		BY	Customer	Rental_Date;

	ARRAY	Prior_Movies	[*]		$32	_Prior_Movie1	_Prior_Movie2;

	FORMAT	_Prior_Rental_Date		DATE9.;
	FORMAT	_Prior2_Rental_Date		DATE9.;
	FORMAT	_Temp_Date				DATE9.;

	LENGTH	_Prior_Movie1			$32;
	LENGTH	_Prior_Movie2			$32;
	LENGTH	_Prior2_Movie1			$32;
	LENGTH	_Prior2_Movie2			$32;
	LENGTH	_Temp1					$32;
	LENGTH	_Temp2					$32;

	Switch_Status					=	'No ';

	_Prior_Customer					=	LAG(Customer);
	_Prior2_Customer				=	LAG2(Customer);
	_Prior_Rental_Date				=	LAG(Rental_Date);
	_Prior2_Rental_Date				=	LAG2(Rental_Date);
	_Prior_Movie1					=	LAG(Movie1);
	_Prior_Movie2					=	LAG(Movie2);
	_Prior2_Movie1					=	LAG2(Movie1);
	_Prior2_Movie2					=	LAG2(Movie2);
	_Prior_Rental_Date				=	LAG(Rental_Date);
	_Temp1							=	Prior_Movies[1];
	_Temp2							=	Prior_Movies[2];

	IF	FIRST.Customer																	THEN
		DO;
			CALL	MISSING(		_Prior_Customer
									,_Prior_Rental_Date
									,_Prior2_Rental_Date
									,_Prior_Movie1
									,_Prior_Movie2
									,_Prior_Rental_Date);
		END;
	
	IF	Rental_Date					=	_Prior_Rental_Date								THEN
		IF	_Prior2_Customer		=	Customer										THEN
			DO;
				_Prior_Rental_Date	=	_Prior2_Rental_Date;
				_Prior_Movie1		=	_Prior2_Movie1;
				_Prior_Movie2		=	_Prior2_Movie2;
			END;
		ELSE
			DO;
				CALL	MISSING(	_Prior_Rental_Date
									,_Prior_Movie1
									,_Prior_Movie2);
			END;

	IF	NOT	MISSING(_Prior_Rental_Date)													THEN
		_Temp_Date					=	INTNX('DAYS', _Prior_Rental_Date, Grace_Period);

	IF	NOT	MISSING(_Prior_Rental_Date)													AND
		Rental_Date					>	INTNX('DAYS', _Prior_Rental_Date, Grace_Period)	THEN
		IF	Movie1				NOT	IN	Prior_Movies									OR
			Movie2				NOT	IN	Prior_Movies									THEN
			DO;
				Switch_Status		=	'Yes';
			END;
RUN;

Re: Creating a new field using dates

Reeza — Tue, 13 Oct 2020 15:33:33 GMT

I think the NOTSORTED option would be useful here.

Re: Creating a new field using dates

jimbarbour — Tue, 13 Oct 2020 15:48:01 GMT

@Reeza,

Yes, probably the better option. With such a small dataset, I just threw in a SORT, but perhaps that's a bit lazy on my part. 😳

Jim

Re: Creating a new field using dates

iced_tea — Tue, 13 Oct 2020 15:48:06 GMT

Interesting how it's working for you. I see the output you got. That's exactly what I'd like. But for me, even running the code to create Cust_Movie_Data only produces an empty table.

I tried reworking your code for my real data, and everyone ends up being Switch_Status = No, even though it is obvious some should be 'Yes', just by looking at their data row by row.

Re: Creating a new field using dates

jimbarbour — Tue, 13 Oct 2020 15:52:41 GMT

That's very very strange. You cut in paste every line of code even the DATALINES?

Are you using SAS Studio? Display Manager? Enterprise Guide? Which one are you using?

Try closing your session, opening a brand new session and cutting and pasting in the below code. I changed the DATALINES back to February 2015, so it's important to get these DATALINES, not the ones from before where I had the requirements backwards.

Jim

DATA	Cust_Movie_Data;
	INFILE	DATALINES
		DSD	DLM='09'x	MISSOVER;

	INPUT	Customer		$
			Start_Date		:	ANYDTDTE10.
			Rental_Date		:	ANYDTDTE10.
			Grace_Period	
			MovieTitle		:	$32.
			Movie1			:	$32.
			Movie2			:	$32.
			Movies_List		:	$64.
			;

	FORMAT	Start_Date			DATE9.;
	FORMAT	Rental_Date			DATE9.;

DATALINES;
12345	13-Mar-13	13-Mar-13	30	Gone Girl	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	13-Mar-13	30	Titanic	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	8-Apr-13	30	Gone Girl	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	8-Apr-13	30	Titanic	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	4-May-13	30	Gone Girl	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	4-May-13	30	Titanic	Gone Girl	Titanic	Gone Girl,Titanic
12345	13-Mar-13	11-Feb_15	30	Hunger Games	Hunger Games	Titanic	Hunger Games,Titanic
12345	13-Mar-13	11-Feb_15	30	Titanic	Hunger Games	Titanic	Hunger Games,Titanic
67890	10-Aug-14	10-Aug-14	30	Pitch Perfect	Pitch Perfect	Pitch Perfect
67890	10-Aug-14	8-Sep-14	30	Pitch Perfect	Pitch Perfect	Pitch Perfect
67890	10-Aug-14	17-Oct-14	30	Pitch Perfect	Pitch Perfect	Pitch Perfect
67890	10-Aug-14	29-Nov-14	30	Pitch Perfect	Pitch Perfect	Pitch Perfect
67890	10-Aug-14	31-Dec-14	30	Booksmart	Booksmart	Booksmart
67890	10-Aug-14	10-Feb-15	30	Booksmart	Booksmart	Booksmart
67890	10-Aug-14	22-May-15	30	Booksmart	Booksmart	Booksmart
67890	10-Aug-14	29-Jun-15	30	Booksmart	Booksmart	Booksmart
;
RUN;

PROC	SORT		DATA=Cust_Movie_Data;
	BY	Customer	Rental_Date;
RUN;

DATA	Cust_Movie_Data_Switch;
	DROP	_:;

	SET		Cust_Movie_Data;
		BY	Customer	Rental_Date;

	ARRAY	Prior_Movies	[*]		$32	_Prior_Movie1	_Prior_Movie2;

	FORMAT	_Prior_Rental_Date		DATE9.;
	FORMAT	_Prior2_Rental_Date		DATE9.;
	FORMAT	_Temp_Date				DATE9.;

	LENGTH	_Prior_Movie1			$32;
	LENGTH	_Prior_Movie2			$32;
	LENGTH	_Prior2_Movie1			$32;
	LENGTH	_Prior2_Movie2			$32;
	LENGTH	_Temp1					$32;
	LENGTH	_Temp2					$32;

	Switch_Status					=	'No ';

	_Prior_Customer					=	LAG(Customer);
	_Prior2_Customer				=	LAG2(Customer);
	_Prior_Rental_Date				=	LAG(Rental_Date);
	_Prior2_Rental_Date				=	LAG2(Rental_Date);
	_Prior_Movie1					=	LAG(Movie1);
	_Prior_Movie2					=	LAG(Movie2);
	_Prior2_Movie1					=	LAG2(Movie1);
	_Prior2_Movie2					=	LAG2(Movie2);
	_Prior_Rental_Date				=	LAG(Rental_Date);
	_Temp1							=	Prior_Movies[1];
	_Temp2							=	Prior_Movies[2];

	IF	FIRST.Customer																	THEN
		DO;
			CALL	MISSING(		_Prior_Customer
									,_Prior_Rental_Date
									,_Prior2_Rental_Date
									,_Prior_Movie1
									,_Prior_Movie2
									,_Prior_Rental_Date);
		END;
	
	IF	Rental_Date					=	_Prior_Rental_Date								THEN
		IF	_Prior2_Customer		=	Customer										THEN
			DO;
				_Prior_Rental_Date	=	_Prior2_Rental_Date;
				_Prior_Movie1		=	_Prior2_Movie1;
				_Prior_Movie2		=	_Prior2_Movie2;
			END;
		ELSE
			DO;
				CALL	MISSING(	_Prior_Rental_Date
									,_Prior_Movie1
									,_Prior_Movie2);
			END;

	IF	NOT	MISSING(_Prior_Rental_Date)													THEN
		_Temp_Date					=	INTNX('DAYS', _Prior_Rental_Date, Grace_Period);

	IF	NOT	MISSING(_Prior_Rental_Date)													AND
		Rental_Date					>	INTNX('DAYS', _Prior_Rental_Date, Grace_Period)	THEN
		IF	Movie1				NOT	IN	Prior_Movies									OR
			Movie2				NOT	IN	Prior_Movies									THEN
			DO;
				Switch_Status		=	'Yes';
			END;
RUN;

Re: Creating a new field using dates

iced_tea — Tue, 13 Oct 2020 16:10:09 GMT

hmmm interesting... I commented out the 3rd line:

DATA	Cust_Movie_Data;
	INFILE	DATALINES ;
/*		DSD	DLM='09'x	MISSOVER;*/

... and Cust_Movie_Data produced properly.

I am using SAS 9.4 (not SAS Studio, not Enterprise Guide).

Re: Creating a new field using dates

Reeza — Tue, 13 Oct 2020 16:13:41 GMT

You shouldn't need that step at all, that creates the example data. You should be replacing the data with your own input data set.

Re: Creating a new field using dates

jimbarbour — Tue, 13 Oct 2020 16:19:36 GMT

@iced_tea wrote:

hmmm interesting... I commented out the 3rd line:
DATA	Cust_Movie_Data;
	INFILE	DATALINES ;
/*		DSD	DLM='09'x	MISSOVER;*/
... and Cust_Movie_Data produced properly.

I am using SAS 9.4 (not SAS Studio, not Enterprise Guide).

Well, for your next SAS trivia challenge: You're using Display Manager. Display Manager is the Windows front end to SAS. SAS runs on mainframes, Unix, Linux, Posix (and probably others), so while a lot of people describe Display Manager as "SAS" or "Base SAS" really SAS is a much broader thing. OK, enough SAS trivia. 🙂

I think that makes sense that you would have to comment out that line. I think what's happening is that when I cut and paste into the code window that tabs are getting converted to spaces. When I copied your data over to my system, there were tabs in the data, so I added the DSD and DLM parameters.

Jim

Re: Creating a new field using dates

iced_tea — Tue, 13 Oct 2020 16:23:07 GMT

Yes Reeza, I agree. I just wanted to see Jim's example and how it is playing out for myself.

Re: Creating a new field using dates

iced_tea — Tue, 13 Oct 2020 16:25:14 GMT

Thank you for educating me. There is so much to learn!

Re: Creating a new field using dates

iced_tea — Tue, 13 Oct 2020 17:24:28 GMT

Jim, is there any reason you can think of for why everyone in my data ends up being Switch_Status = 'No'?

Re: Creating a new field using dates

jimbarbour — Tue, 13 Oct 2020 17:29:27 GMT

First, check your input data. Is everything fitting into the columns correctly? Are their missing values? Are there any unusual patterns? Are the rows properly separated? Is there any flow over from one row to the next or is there any truncation?

Second, does your sample data describe the actual data accurately? I programmed to your sample. If the pattern of the data in the real data differs from the sample data, the program will deliver different results.

Can you post some of the live data? You can anonymize it if need be. I'm suspecting there's something going on in the data that the sample didn't fully capture. You've got to be really picky with the details with sample data.

Jim

Re: Creating a new field using dates

iced_tea — Tue, 13 Oct 2020 18:23:24 GMT

Is this helpful?

PatID

index_ART

Final_Class

FILL_DATE

SUPPLY_DAYS

BrandName

Brand1

Brand2

Brand3

Brand4

Brand5

Brand6

index_Brand_List

Switch_Status

19737

2013-03-13

Combinations

13Mar2013

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

13Mar2013

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

08Apr2013

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

08Apr2013

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

04May2013

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

04May2013

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

01Jun2013

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

01Jun2013

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

08Jul2013

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

08Jul2013

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

03Aug2013

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

03Aug2013

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

04Sep2013

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

04Sep2013

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

01Oct2013

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

01Oct2013

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

27Oct2013

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

27Oct2013

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

24Nov2013

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

24Nov2013

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

20Dec2013

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

20Dec2013

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

15Jan2014

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

15Jan2014

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

10Feb2014

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

10Feb2014

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

10Mar2014

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

10Mar2014

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

21Apr2014

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

21Apr2014

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

17May2014

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

22May2014

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

14Jun2014

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

17Jun2014

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

10Jul2014

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

13Jul2014

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

16Aug2014

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

16Aug2014

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

11Sep2014

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

11Sep2014

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

20Oct2014

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

20Oct2014

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

15Nov2014

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

15Nov2014

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

11Dec2014

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

11Dec2014

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

06Jan2015

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

06Jan2015

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

11Feb2015

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

yes

19737

2013-03-13

Combinations

11Feb2015

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

16Mar2015

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

16Mar2015

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

13Apr2015

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

22Apr2015

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

11May2015

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

18May2015

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

06Jun2015

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

13Jun2015

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

04Jul2015

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

09Jul2015

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

30Jul2015

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

05Aug2015

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

25Aug2015

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

01Sep2015

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

24Sep2015

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

27Sep2015

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

23Oct2015

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

23Oct2015

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

20Nov2015

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

20Nov2015

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

16Dec2015

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

16Dec2015

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

16Jan2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

16Jan2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

11Feb2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

11Feb2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

08Mar2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

08Mar2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

04Apr2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

04Apr2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

30Apr2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

01May2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

27May2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

27May2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

22Jun2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

22Jun2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

18Jul2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

18Jul2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

13Aug2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

13Aug2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

08Sep2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

08Sep2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

04Oct2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

04Oct2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

02Nov2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

02Nov2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

01Dec2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

01Dec2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

27Dec2016

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

27Dec2016

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

12Sep2018

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

12Sep2018

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

18Sep2018

Zestril

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

12Oct2018

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

12Oct2018

Zestril

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

05Nov2018

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

17Nov2018

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

03Dec2018

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

02Jan2019

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

02Jan2019

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

26Jan2019

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

30Jan2019

Neurontin

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

04Mar2019

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

11Mar2019

Zestril

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

10Apr2019

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

10Apr2019

Zestril

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

04May2019

Zestril

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

09May2019

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

31May2019

Zestril

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

02Jun2019

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

24Jun2019

Zestril

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

26Jun2019

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

25Jul2019

Lipitor

Levoxyl

Neurontin

Levoxyl,Neurontin

19737

2013-03-13

Combinations

25Jul2019

Zestril

Levoxyl

Neurontin

Levoxyl,Neurontin

31598612

2013-01-28

Combinations

28Jan2013

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

28Jan2013

Amoxil

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

28Jan2013

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

01Mar2013

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

01Mar2013

Amoxil

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

01Mar2013

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

01Apr2013

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

01Apr2013

Amoxil

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

01Apr2013

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

29Apr2013

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

29Apr2013

Amoxil

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

29Apr2013

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

30Jul2013

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

30Jul2013

Amoxil

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

30Jul2013

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

27Aug2013

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

27Aug2013

Amoxil

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

27Aug2013

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

24Sep2013

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

24Sep2013

Amoxil

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

24Sep2013

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

25Oct2013

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

25Oct2013

Amoxil

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

25Oct2013

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

20Nov2013

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

20Nov2013

Amoxil

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

20Nov2013

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

30Dec2013

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

30Dec2013

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

31Jan2014

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

31Jan2014

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

20Feb2014

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

20Feb2014

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

18Mar2014

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

18Mar2014

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

21May2014

Lipitor

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

yes

31598612

2013-01-28

Combinations

21May2014

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

18Jun2014

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

18Jun2014

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

19Jun2014

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

29Jul2014

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

29Jul2014

Lipitor

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

29Jul2014

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

29Jul2014

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

28Aug2014

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

28Aug2014

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

28Aug2014

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

25Sep2014

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

25Sep2014

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

25Sep2014

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

23Oct2014

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

23Oct2014

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

23Oct2014

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

06Jan2015

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

06Jan2015

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Jan2015

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Jan2015

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Jan2015

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

28Apr2015

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

28Apr2015

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

28Apr2015

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

28May2015

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

29May2015

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

29May2015

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Jun2015

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Jun2015

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Jun2015

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

21Jul2015

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

21Jul2015

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

10Aug2015

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

10Aug2015

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

10Aug2015

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

01Oct2015

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

01Oct2015

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

01Oct2015

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

29Oct2015

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

29Oct2015

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

29Oct2015

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

16Dec2015

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

16Dec2015

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

16Dec2015

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

11Jan2016

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

11Jan2016

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

28Jan2016

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

28Jan2016

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

28Jan2016

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

26Feb2016

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

26Feb2016

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

27Feb2016

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

04Apr2016

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

04Apr2016

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

04Apr2016

Neurontin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

23May2016

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

23May2016

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

23May2016

Zestril

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Jun2016

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Jun2016

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Jun2016

Zestril

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Aug2016

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Aug2016

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Aug2016

Zestril

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Oct2016

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Oct2016

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

02Nov2016

Zestril

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Nov2016

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

22Nov2016

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

28Nov2016

Zestril

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

15Dec2016

Zestril

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

19Dec2016

Zofran

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31598612

2013-01-28

Combinations

19Dec2016

Motrin

Levoxyl

Amoxil

Neurontin

Levoxyl,Amoxil,Neurontin

31599752

2013-02-20

Combinations

20Feb2013

Tylenol

31599752

2013-02-20

Combinations

23Apr2013

Tylenol

31599752

2013-02-20

Combinations

10Jun2013

Tylenol

31599752

2013-02-20

Combinations

13Jul2013

Tylenol

31599752

2013-02-20

Combinations

06Aug2013

Tylenol

31599752

2013-02-20

Combinations

03Sep2013

Tylenol

31599752

2013-02-20

Combinations

30Sep2013

Tylenol

31599752

2013-02-20

Combinations

28Oct2013

Tylenol

31599752

2013-02-20

Combinations

03Dec2013

Tylenol

31599752

2013-02-20

Combinations

18Feb2014

Tylenol

31599752

2013-02-20

Combinations

14Mar2014

Tylenol

31599752

2013-02-20

Combinations

14Apr2014

Tylenol

31599752

2013-02-20

Combinations

15May2014

Tylenol

31599752

2013-02-20

Combinations

12Jun2014

Tylenol

31599752

2013-02-20

Combinations

29Nov2016

Tylenol

The first two PatIDs are a "yes" for Switch_Status. The last PatID is a "no" for Switch_Status.