topic Re: Proc Sql Select clause query in SAS Procedures

Proc Sql Select clause query

alwaz_searching — Fri, 27 May 2011 05:13:00 GMT

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...?

Re: Proc Sql Select clause query

SPR — Fri, 27 May 2011 13:48:09 GMT

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

Re: Proc Sql Select clause query

alwaz_searching — Thu, 02 Jun 2011 03:28:04 GMT

Thank you SPR...!!!

It's working...!