Proc Sql Select clause query

[alwaz_searching]

Hi,

I want to create a variable incrementing with the value 1 in the Proc Sql Select clause Select statement....

Can anyone help me out in this...?

[SPR]

Hello Alwaz,

You can use an undocumented SQL function MONOTONIC() but use it with caution:
[pre]
proc SQL;
create table class as
select MONOTONIC() as n,*
from SASHELP.CLASS
;quit;
[/pre]
Sincerely,
SPR

[alwaz_searching]

Thank you SPR...!!!

It's working...!