Can't speak for NSA, but CIA bans all illegal substances in the last 365 days. That may have changed in the past 10 years though. If you have any history of substances, you'll have to do the waiver.
That is the standard for DOD clearances in general. No illegal substance use in the past year, and any at all needs to be adjudicated (to use their terminology).
