topic How to find even records ,odd records using only proc sql ? in SAS Programming

How to find even records ,odd records using only proc sql ?

Saikiran_Mamidi — Wed, 13 May 2020 03:45:41 GMT

Re: How to find even records ,odd records using only proc sql ?

ChrisNZ — Wed, 13 May 2020 05:53:04 GMT

SQL has no concept of row order, and the order is never guaranteed.

Use a data step instead.

For SQL, this not-recommended code might help:

proc sql;
  select monotonic() as M, mod(calculated M, 2) as ODD
  from SASHELP.CLASS;
quit;

Re: How to find even records ,odd records using only proc sql ?

Jagadishkatam — Wed, 13 May 2020 06:00:11 GMT

Please try the below code with mod function to generate the odd and even row tables by proc sql

proc sql;
create table odd as SELECT * FROM (select *, monotonic() as row from sashelp.class ) where mod(row,2)<>0;
create table even as SELECT * FROM (select *, monotonic() as row from sashelp.class ) where mod(row,2)=0;
quit;

Re: How to find even records ,odd records using only proc sql ?

ballardw — Wed, 13 May 2020 18:31:10 GMT

What does your input look like, or an example, and what should the output look like?

There can be more than one interpretation of your subject line.

It could be "is the record order value even/odd"

It could be the record number is even/odd (not always the same thing with deleted information)

Is the value of some variable, or combination of variables even/odd.

Is the explicit value of some variable (or variables) the text "even" or "odd".

And I suspect that if I spent some time I might come up with a few more. So something specific might be a good idea.