topic Re: counter in proc sql; in SAS Procedures

counter in proc sql;

deleted_user — Thu, 19 Jun 2008 15:57:20 GMT

Hello dears sas users
in france it's sad because we went back to home in football...

data allez_france;
format un $20.;
un="on est nuls";
output;
un="domenech demission";
output;
run;

if i want to create an counter of lines with a data step i can do
data count;
set allez_france;
i=_n_;
run;

i just want to know the equivalent code in proc sql please
thank you

Re: counter in proc sql;

deleted_user — Thu, 19 Jun 2008 21:28:22 GMT

You can get the row number using monotonic() function within proc sql.

Re: counter in proc sql;

Cynthia_sas — Fri, 20 Jun 2008 14:17:36 GMT

Hi:
For simple queries, monotonic() may work. However, see this Tech Support note:
http://support.sas.com/kb/15/138.html
which says:
"Using the MONOTONIC() function in PROC SQL can cause missing or non-sequential values to be returned."

You may want to check with Tech Support or switch to using PROC PRINT's obs numbers or use a DATA step program to create an obs number variable.

cynthia

Re: counter in proc sql;

deleted_user — Fri, 20 Jun 2008 15:55:54 GMT

Thank you, Cynthia.

Re: counter in proc sql;

deleted_user — Mon, 23 Jun 2008 12:33:11 GMT

Thank you cynthia and vasile