If he wanted to do that sort of blanket pardon, he could assign someone to go through the court records. I think he could then sign something that was like, "I hereby pardon everyone who has been convicted of drug-related offenses, the list of names is below" where "below" was umpteen thousand sheets of paper listing names and possibly a little detail, e.g. "John Doe of Anytown, convicted on $date."
no subject