topic Choosing a variable from the next row in SAS Programming

Choosing a variable from the next row

Lupacante — Tue, 24 Sep 2013 11:32:07 GMT

Suppose you've got a dataset with variables var1 and var2. When var1 is equal to a certain value, you want to take the value of var2 in the next row down.

How do you do that?

Thanks in advance,

Marco

Re: Choosing a variable from the next row

Amir — Tue, 24 Sep 2013 11:49:38 GMT

Hi,

Here's an example way to do it:

data _null_;

set sashelp.class(rename=(height=var1 weight=var2));

if get_var2 then

do;

call symputx('var2_value',var2);

stop;

end;

if var1=57.3 then

get_var2+1;

run;

%put var2_value=&var2_value;

regards,

Amir.

Re: Choosing a variable from the next row

data_null__ — Tue, 24 Sep 2013 11:51:35 GMT

data next;
   set sashelp.class end=eof;
   if not eof then set sashelp.class(firstobs=2 keep=weight rename=(weight=_weight));
   if sex eq 'F' and not eof then weight=_weight;
   run;

Re: Choosing a variable from the next row

Keith — Tue, 24 Sep 2013 11:55:26 GMT

data ds_view / view=ds_view;

merge ds1

ds1 (firstobs=2 keep=var2 rename=(var2=nextvar2));

run;

data want (drop=nextvar2);

set ds_view;

if var1=1 then var1=nextvar2;

run;

Re: Choosing a variable from the next row

Lupacante — Tue, 24 Sep 2013 12:33:49 GMT

Amir:

it successfully creates a dataset, but how do I then get the value for var2 for a particular one of var1? The dataset just has an extra column 'var2' which is zero everywhere except for that particular value of var1.

Re: Choosing a variable from the next row

Amir — Tue, 24 Sep 2013 12:43:49 GMT

Hi,

Do you want to create:

A) A data set with one row showing the var1 value and the next var2 value

B) A macro variable holding the value

C) Something else, please specify with an example.

I saw a post from you that has since been deleted saying that SAS did not recognise the macro variable reference, in that case try replacing:

call symputx('var2_value',var2);

with

call symputx('var2_value',var2,'G');

to make the scope of the variable global, if, for example, it is being created in a macro function, and is being referenced outside of that macro function.

Regards,

Amir.