adding a new column to a table

[Osebeyo]

hi,

I am trying to add a column to an existing table and I want al, the rows in the column to have a value 1

i used this syntax, but it didn't work;

newcolumn = 1

any help?

[DF]

Your suggestion sounds like it should have worked (although using RETAIN to set a default value is probably more efficient), e.g.

data mydata;

set mydata;

newcolumn = 1;

run;

or

data mydata;

set mydata;

retain newcolumn 1;

run;

Are you getting an error of some kind?

[Osebeyo]

Thanks DF, your response helped me spot my error.

It is fine now.

[art297 · Accepted solution]

How about:

data want;

  set sashelp.class;

  retain newcolumn 1;

run;

HTH,

Art