create two macro variables in proc sql

[kumarK]

Hi,

Why this code is giving error? How can we create two macro variables through into option.

Proc sql noprint outobs=1;

select name into:bname, age into:bage  from sashelp.class;

quit;

%put &bname &bage;

Thanks...

[PGStats · Accepted solution]

Because the code hasn't the proper syntax, which is :

Proc sql noprint;

select name, age into:bname, :bage  from sashelp.class;

quit;

%put &bname &bage;

Which record do you want anyway?

PG

[kumarK]

Thanks for reply. This is the generic question i have asked. i will put conditions in where clause.