Welcome SmallTown, I think if you read around here and check out the stickies, learn as much as you can about addiction and addict behavior it will help you understand that you did not fail your sister.
Where is her child when she is at drug houses? Does she have a history of any drug related arrests? Has child protective services ever been involved?