I don't get that error when I run this SQL to create this procedure - probably because this is the only SQL in my query window. You probably have some other code above this.
Try putting GO before the create procedure
Create procedure [STGRPT].[PROC_DOH_CURRENT_CENSUS]
@unit varchar (max)
As to the semi-colon before the
- you only "need" that semi-colon if there is code precding the CTE definition that has not been terminated with a semi-colon - I took this as further evidence that you had been experimenting with code and then wrapped it into a Stored Procedure create