topic Re: Define value to be filled in the empty created created while using "firstobs" function in SAS Programming

Define value to be filled in the empty created created while using "firstobs" function on a column.

Saurabh_Rana — Mon, 14 Dec 2020 10:40:31 GMT

When using "firstobs" function on a column it creates a lookahead column because of which empty cells are created(Number depends on the argument used in the lookahead function) at the end of the column. Is there any way I can define the value to be filled in that empty cell?

Re: Define value to be filled in the empty created created while using "firstobs" function

PeterClemmensen — Mon, 14 Dec 2020 10:41:31 GMT

Show us your code.

Re: Define value to be filled in the empty created created while using "firstobs" function

Saurabh_Rana — Thu, 17 Dec 2020 08:05:11 GMT

data WORK.test;
merge
WORK.sample_table
WORK.sample_table (firstobs=2 keep=SerialNumber rename=(SerialNumber=_SerialNumber));
/* further processing */
run;

After executing the above code 1 empty cell will get created in the last row of the column, now I want to define a certain value to be filled in that empty/null cell. How can I achieve that?

Re: Define value to be filled in the empty created created while using "firstobs" function

PeterClemmensen — Mon, 14 Dec 2020 11:55:51 GMT

See if you can use this as a template

data have;
input x @@;
datalines;
1 2 3 4 5
;

data want;
   merge have end=z
         have(firstobs = 2 rename=x=_x);
   if z then _x = 999;
run;

Re: Define value to be filled in the empty created created while using "firstobs" function

ballardw — Mon, 14 Dec 2020 17:29:41 GMT

I think you need to provide example data AND full code.

The code you show will basically duplicate the value for all rows and nothing should be "blank" unless you reset the variable values.

I suspect you may actually be running code with OBS=1 on a data set with two rows of data like this:

data have;
input x @@;
datalines;
1 2 
;

 data want;
   merge have
         have(obs = 1 rename=(x=y));
run;

There is functionally no difference between

data want;
   merge have
              have (rename=(var=newvar))
   ;
run;
/*or*/
data want;
   merge have
              have (firstobs=1 rename=(var=newvar))
   ;
run;

From the documentation:

Firstobs Specifies the first row in a data source that SAS processes.

So when you say Firstobs=1 then you are defaulting to using all observations starting with the first, in other words the default behavior of using all the values.

Re: Define value to be filled in the empty created created while using "firstobs" function

Saurabh_Rana — Thu, 17 Dec 2020 08:06:01 GMT

My bad. I am using firstobs=2 in my code

Re: Define value to be filled in the empty created created while using "firstobs" function

PeterClemmensen — Thu, 17 Dec 2020 08:08:00 GMT

Did you try my code above?