declare variabe in PROC SQL (SAS)

Question

I am trying to use a variable on PROC SQL but i cannot find a proper way through the internet. I just want to apply the following code of T-SQL on PROC SQL:

 declare @example as int;
set @example=2;
select * from {table} where {column}=@example;
go

How can i apply this code on PROC SQL?

Answer 1

The translation to SAS SQL is to use a macro variable, the code looks pretty similar, need to wrap it in a PROC SQL block though.

%let example=2;

proc sql;
select *
from table
where variable=&example;
quit;

EDIT: my original reference to the macro variable was incorrect, use an ampersand in SAS not @ symbol.