topic adding a new column to a table in SAS Procedures

adding a new column to a table

Osebeyo — Tue, 19 Jul 2011 12:56:38 GMT

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 — Tue, 19 Jul 2011 13:06:28 GMT

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;

data mydata;

set mydata;

retain newcolumn 1;

run;

Are you getting an error of some kind?

art297 — Tue, 19 Jul 2011 13:08:33 GMT

How about:

data want;

set sashelp.class;

retain newcolumn 1;

run;

HTH,

Art

Osebeyo — Tue, 19 Jul 2011 13:10:22 GMT

Thanks DF, your response helped me spot my error.

It is fine now.