topic Re: I want to make a flag 2 lines from the last line in New SAS User

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

sasviyajunior — Fri, 31 Jan 2020 01:51:57 GMT

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.

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

mkeintz — Fri, 31 Jan 2020 02:10:48 GMT

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.

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

sasviyajunior — Fri, 31 Jan 2020 02:16:21 GMT

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

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

mkeintz — Fri, 31 Jan 2020 02:19:46 GMT

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?

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

ballardw — Fri, 31 Jan 2020 17:46:29 GMT

@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.