The U.S. president not openly declared his support of a united Canada in the run-up to the Alberta vote