topic Re: How to get a new variable that iterates by 1 in SAS Programming

How to get a new variable that iterates by 1

teg_76 — Sat, 19 May 2012 05:33:57 GMT

Hi,

I have a data set:

LEVEL

I Need:

TIME LEVEL

1 4

2 5

3 23

4 64

5 3

6 4

How do i read in the "time" variable that iterates by one with each "level" observation?

Thanks in Advance!

Re: How to get a new variable that iterates by 1

Haikuo — Sat, 19 May 2012 11:48:19 GMT

There will be many ways to do that, the simplest way that I can think of:

/*data step*/

data have;

input LEVEL;

cards;

;

data want;

time=_n_;

set have;

run;

/*Proc SQL*/

proc sql;

select monotonic() as time, * from have;

quit;

Haikuo

Re: How to get a new variable that iterates by 1

teg_76 — Sun, 20 May 2012 11:09:22 GMT

Thanks Haikuo. That did it!

Re: How to get a new variable that iterates by 1

Ksharp — Mon, 21 May 2012 04:30:24 GMT

I prefer to ODS.

ods _all_ close;
ods output sql_results=want;
proc sql number;
select * from sashelp.class;
quit;
ods listing;

Ksharp

Re: How to get a new variable that iterates by 1

Linlin — Mon, 21 May 2012 12:54:52 GMT

Hi Ksharp,

what is the advantage to use ODS?

Thanks - Linlin

Re: How to get a new variable that iterates by 1

Haikuo — Mon, 21 May 2012 13:00:51 GMT

Linlin,

I think what Ksharp mean is that he prefer ODS to monotonic(), not data step. This has be discussed before, and Ksharp was involved. The main reason is that monotonic() is not officially supported by SAS.

Haikuo

Re: How to get a new variable that iterates by 1

Linlin — Mon, 21 May 2012 13:20:31 GMT

Thank you Haikuo. - Linlin