Getting : 'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.

Create procedure [STGRPT].[PROC_DOH_CURRENT_CENSUS]
(
	@facility varchar(200),
	@unit varchar (max)
)

AS 

;WITH census as 
(
SELECT Distinct FCY.FCY_NM as [Facility]
,Cast(CS.CSS_TS as Date) as Date
,RTRIM(CASE WHEN Len(u.LVL_CD) > 1 Then u.LVL_CD
		    ELSE Substring(
			u.UNIT_ABR_CD, 
			CHARINDEX('-',u.UNIT_ABR_CD) + 1
			, 25
			) End) as [Unit]
, cs.CSS_TS_DIM_ID as [Hour], CS.TOT_PERM_BED_CNT + cs.TOT_ASGN_BED_CNT as CENSUS
FROM PTM_DMART.dbo.CSS_SMY CS WITH (NOLOCK)
JOIN PTM_DMART.dbo.FCY_LKP FCY WITH (NOLOCK) ON CS.SRC_FCY_ID = FCY.SRC_FCY_ID
JOIN PTM_DMART.dbo.UNIT_LKP U WITH (NOLOCK) ON CS.UNIT_LKP_ID = U.UNIT_LKP_ID
Where Cast(CS.CSS_TS as Date) = DateAdd(day,-1,Cast(GetDate() as Date))
and cs.CSS_TS_DIM_ID IN ('0000', '0800','1600')
)

,datapivot as 
(
SELECT Facility, [Date], Unit, [0000], [0800], [1600]
FROM Census
PIVOT
(
		
		Min(Census)
		FOR [Hour] 
		IN ([0000], [0800], [1600])
) AS PT
--Where Facility = 'LONG ISLAND JEWISH HOSPITAL'
)

SELECT Facility, [Date], Unit, IsNULL([0000],0) as [00:00], IsNull([0800],0) as [08:00], IsNull([1600],0) as [16:00]
FROM datapivot
Order by 1,3

GO