This example creates a schema called report if it does not exist.

DECLARE @schemaName VARCHAR(50) = 'report'

IF NOT EXISTS (SELECT 1 
               FROM sys.schemas 
               WHERE name = @schemaName)
BEGIN
    EXECUTE('CREATE SCHEMA ' _p_l_u_s_ @schemaName)
END
GO