The problem with ending a sentence with "at" is usually not because it's a preposition, but because it's already been either stated or implied. Example: "Where is he at?" The word "where" means "at what place".