US President Barack Obama has said smoking marijuana is no more dangerous than alcohol, but still called it a "bad idea".