How do you create variables in proc sql?
For example, in SQL server, I can start my code with:
"
DECLARE @SD AS INT, @ED AS INT, @LD as int
SELECT @SD = 201501, @ED = 201512, @LD = 201603..."
and when I do my code, instead of typing the dates, I can just type in the variables.
I,e
select * from table
where dates between @SD and @ED
For example, in SQL server, I can start my code with:
"
DECLARE @SD AS INT, @ED AS INT, @LD as int
SELECT @SD = 201501, @ED = 201512, @LD = 201603..."
and when I do my code, instead of typing the dates, I can just type in the variables.
I,e
select * from table
where dates between @SD and @ED