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: 
BookmarkSubscribeRSS Feed
iced_tea
Obsidian | Level 7 iced_tea
Obsidian | Level 7

Re: Creating a new field using dates

Posted 10-13-2020 01:24 PM (221 views)  |   In reply to jimbarbour
Jim, is there any reason you can think of for why everyone in my data ends up being Switch_Status = 'No'?
0 Likes
Reply
jimbarbour
Meteorite | Level 14 jimbarbour
Meteorite | Level 14

Re: Creating a new field using dates

Posted 10-13-2020 01:29 PM (216 views)  |   In reply to iced_tea

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

Reply
iced_tea
Obsidian | Level 7 iced_tea
Obsidian | Level 7

Re: Creating a new field using dates

Posted 10-13-2020 02:23 PM (194 views)  |   In reply to jimbarbour

Is this helpful? 

 

PatIDindex_ARTFinal_ClassFILL_DATESUPPLY_DAYSBrandNameBrand1Brand2Brand3Brand4Brand5Brand6index_Brand_ListSwitch_Status
197372013-03-13Combinations13Mar201330LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations13Mar201330NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations08Apr201330LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations08Apr201330NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations04May201330LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations04May201330NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations01Jun201330LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations01Jun201330NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations08Jul201330LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations08Jul201330NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations03Aug201330LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations03Aug201330NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations04Sep201330LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations04Sep201330NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations01Oct201330LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations01Oct201330NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations27Oct201330LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations27Oct201330NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations24Nov201330LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations24Nov201330NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations20Dec201330LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations20Dec201330NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations15Jan201430LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations15Jan201430NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations10Feb201430LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations10Feb201430NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations10Mar201430LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations10Mar201430NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations21Apr201430LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations21Apr201430NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations17May201430NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations22May201430LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations14Jun201430NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations17Jun201430LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations10Jul201430NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations13Jul201430LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations16Aug201430LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations16Aug201430NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations11Sep201430LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations11Sep201430NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations20Oct201430LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations20Oct201430NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations15Nov201430LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations15Nov201430NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations11Dec201430LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations11Dec201430NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations06Jan201530LevoxylLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations06Jan201530NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations11Feb201530LipitorLevoxylNeurontin    Levoxyl,Neurontinyes
197372013-03-13Combinations11Feb201530NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations16Mar201530LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations16Mar201530NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations13Apr201530NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations22Apr201530LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations11May201530NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations18May201530LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations06Jun201530NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations13Jun201530LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations04Jul201530NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations09Jul201530LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations30Jul201530NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations05Aug201530LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations25Aug201530NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations01Sep201530LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations24Sep201530NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations27Sep201530LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations23Oct201530LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations23Oct201530NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations20Nov201530LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations20Nov201530NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations16Dec201530LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations16Dec201530NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations16Jan201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations16Jan201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations11Feb201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations11Feb201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations08Mar201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations08Mar201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations04Apr201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations04Apr201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations30Apr201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations01May201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations27May201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations27May201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations22Jun201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations22Jun201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations18Jul201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations18Jul201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations13Aug201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations13Aug201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations08Sep201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations08Sep201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations04Oct201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations04Oct201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations02Nov201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations02Nov201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations01Dec201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations01Dec201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations27Dec201630LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations27Dec201630NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations12Sep201830LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations12Sep201830NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations18Sep201830ZestrilLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations12Oct201830LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations12Oct201830ZestrilLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations05Nov201830NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations17Nov201830LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations03Dec201830NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations02Jan201930LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations02Jan201930NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations26Jan201930LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations30Jan201930NeurontinLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations04Mar201930LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations11Mar201930ZestrilLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations10Apr201930LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations10Apr201930ZestrilLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations04May201930ZestrilLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations09May201930LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations31May201930ZestrilLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations02Jun201930LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations24Jun201930ZestrilLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations26Jun201930LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations25Jul201930LipitorLevoxylNeurontin    Levoxyl,Neurontin 
197372013-03-13Combinations25Jul201930ZestrilLevoxylNeurontin    Levoxyl,Neurontin 
315986122013-01-28Combinations28Jan201330LevoxylLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations28Jan201330AmoxilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations28Jan201330NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations01Mar201330LevoxylLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations01Mar201330AmoxilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations01Mar201330NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations01Apr201330LevoxylLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations01Apr201330AmoxilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations01Apr201330NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations29Apr201330LevoxylLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations29Apr201330AmoxilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations29Apr201330NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations30Jul201330LevoxylLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations30Jul201330AmoxilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations30Jul201330NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations27Aug201330LevoxylLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations27Aug201330AmoxilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations27Aug201330NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations24Sep201330LevoxylLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations24Sep201330AmoxilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations24Sep201330NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations25Oct201330LevoxylLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations25Oct201330AmoxilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations25Oct201330NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations20Nov201330LevoxylLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations20Nov201330AmoxilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations20Nov201330NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations30Dec201330LevoxylLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations30Dec201330NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations31Jan201430LevoxylLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations31Jan201430NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations20Feb201430LevoxylLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations20Feb201430NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations18Mar201430LevoxylLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations18Mar201430NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations21May201430LipitorLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontinyes
315986122013-01-28Combinations21May201430NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations18Jun201430ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations18Jun201430MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations19Jun201430NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations29Jul201430ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations29Jul201430LipitorLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations29Jul201430MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations29Jul201430NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations28Aug201430ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations28Aug201430MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations28Aug201430NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations25Sep201430ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations25Sep201430MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations25Sep201430NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations23Oct201430ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations23Oct201430MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations23Oct201430NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations06Jan201530ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations06Jan201530NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Jan201530ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Jan201530MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Jan201530NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations28Apr201530ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations28Apr201530MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations28Apr201530NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations28May201530NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations29May201530ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations29May201530MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Jun201530ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Jun201530MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Jun201530NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations21Jul201530ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations21Jul201530MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations10Aug201530ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations10Aug201530MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations10Aug201530NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations01Oct201530ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations01Oct201530MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations01Oct201530NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations29Oct201530ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations29Oct201530MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations29Oct201530NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations16Dec201530ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations16Dec201530MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations16Dec201530NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations11Jan201630ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations11Jan201630NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations28Jan201630ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations28Jan201630MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations28Jan201630NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations26Feb201630MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations26Feb201630NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations27Feb201630ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations04Apr201630ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations04Apr201630MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations04Apr201630NeurontinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations23May201630ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations23May201630MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations23May201630ZestrilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Jun201630ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Jun201630MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Jun201630ZestrilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Aug201630ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Aug201630MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Aug201630ZestrilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Oct201630ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Oct201630MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations02Nov201630ZestrilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Nov201630ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations22Nov201630MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations28Nov201630ZestrilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations15Dec201630ZestrilLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations19Dec201630ZofranLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315986122013-01-28Combinations19Dec201630MotrinLevoxylAmoxilNeurontin   Levoxyl,Amoxil,Neurontin
315997522013-02-20Combinations20Feb201330TylenolTylenol     Tylenol 
315997522013-02-20Combinations23Apr201330TylenolTylenol     Tylenol 
315997522013-02-20Combinations10Jun201330TylenolTylenol     Tylenol 
315997522013-02-20Combinations13Jul201330TylenolTylenol     Tylenol 
315997522013-02-20Combinations06Aug201330TylenolTylenol     Tylenol 
315997522013-02-20Combinations03Sep201330TylenolTylenol     Tylenol 
315997522013-02-20Combinations30Sep201330TylenolTylenol     Tylenol 
315997522013-02-20Combinations28Oct201330TylenolTylenol     Tylenol 
315997522013-02-20Combinations03Dec201330TylenolTylenol     Tylenol 
315997522013-02-20Combinations18Feb201430TylenolTylenol     Tylenol 
315997522013-02-20Combinations14Mar201430TylenolTylenol     Tylenol 
315997522013-02-20Combinations14Apr201430TylenolTylenol     Tylenol 
315997522013-02-20Combinations15May201430TylenolTylenol     Tylenol 
315997522013-02-20Combinations12Jun201430TylenolTylenol     Tylenol 
315997522013-02-20Combinations29Nov201630TylenolTylenol     Tylenolno

 

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

0 Likes
Reply

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 17 replies
  • ‎10-12-2020 08:07 PM
  • 1161 views
  • 7 likes
  • 3 in conversation