I want to make a flag 2 lines from the last line

[sasviyajunior]

Hello. I tested with sashelp.class data
In the process. From class last line
I want to make this rule YY NN YY NN.
Is there a good way?
For example, you want to create a new column N YY NN YY NN in the class dataset.

[mkeintz]

I have absolutely no idea of what you are asking for.   Please provide (in the form of a DATA step with actual sashelp.class data) what you want the resulting data set to look like.  We all know what the 19 observations in sashelp.class looks like, so please show the (presumably) 19 rows of new variables.  And help us understand what rules you want to implement.

[sasviyajunior]

I want the rules like YY, NN, YY, NN to be created as new columns by two rows from the last row.

[mkeintz]

Yeah, you said that before but I'm too dense to know what you mean.  Why not make it completely apparent and show us what the 19 rows resulting from sashelp.class would look like?  Are us just saying to make one new variable, which has character values "YY" for rows 1,3,5,,...19.   And value "NN" for rows 2,4,6,8,...18?

[ballardw]

---

@sasviyajunior wrote:

Hello. I tested with sashelp.class data
In the process. From class last line
I want to make this rule YY NN YY NN.
Is there a good way?
For example, you want to create a new column N YY NN YY NN in the class dataset.

---

Are N YY NN YY NN supposed to be variable names? Values? If values for how many variables? Of what names? If the values are YY or NN what is the rule in determining which is which.

Here is an example of executing some code only 2 records prior to the end of a given data set using SASHELP.CLASS.

data junk;
   set sashelp.class nobs=nn;
   if _n_ = nn-2 then do;
      var1='YY';
      var2= 3;
   end;
run;

But I don't see a lot of utility in this approach.