topic Re: Add observation in SAS Programming

Add observation

aditya1 — Mon, 10 Apr 2017 20:05:33 GMT

Hi i want to create observation GENDER in a row above characteristic how do i do that.

thanks in advance

Re: Add observation

ballardw — Mon, 10 Apr 2017 20:12:44 GMT

data want;
   input characteristic $ ;
datalines;
F
M
;
run;

Is this in an existing data set or are you creating set from scratch?

If the later then

Re: Add observation

Kurt_Bremser — Mon, 10 Apr 2017 20:14:16 GMT

Since "characteristic" seems to be a variable (column) name, you can't add a row "above" it.

To clarify, post your example data in a data step, or use a sashelp dataset to illustrate your issue.

Re: Add observation

Reeza — Mon, 10 Apr 2017 20:14:29 GMT

You have a dataset so what are you trying to do?

Customize a report layout is my guess and there are probably better ways to do this - a label for the variable is one way to start off.

Re: Add observation

art297 — Mon, 10 Apr 2017 20:18:47 GMT

Do you want to insert a row or simply rename the variable? If it's the latter, then (assuming you dataset is called have), when opening the dataset simply use something like:

set have (rename=(characteristic=gender);

Otherwise, if you really want to insert a row, you may first have to use a length statement (before the set statement) and then include code (after the set statement):

data want;
  length characteristic $6;
  set have;
  if characteristic='F' then do;
    hold=characteristic;
    characteristic='Gender';
    output;
    characteristic=hold;
    output;
  end;
  else output;
run;

Art, CEO, AnalystFinder.com