topic Non Existing Column in SAS Programming

Non Existing Column

Gluttony — Wed, 11 Mar 2020 18:04:35 GMT

Hi everyone,
I need help for this case :

I have a dataset DATA with columns A, B and C

I want to create a new column D = A + C + G

G does not exist in DATA, thus it will create blank for D. But is there a way to set non existing column (G) default values to 0 and then D will be equal to A + C ?

Thank you,

Gluttony

Re: Non Existing Column

PaigeMiller — Wed, 11 Mar 2020 18:06:41 GMT

@Gluttony wrote:

Hi everyone,
I need help for this case :

I have a dataset DATA with columns A, B and C

I want to create a new column D = A + C + G

G does not exist in DATA, thus it will create blank for D. But is there a way to set non existing column (G) default values to 0 and then D will be equal to A + C ?

Thank you,

Gluttony

D = A + C + 0;

D = A + C;

Re: Non Existing Column

novinosrin — Wed, 11 Mar 2020 18:07:54 GMT

retain g 0;

d=sum(a,c,g);

Re: Non Existing Column

Reeza — Wed, 11 Mar 2020 18:35:40 GMT

The SUM() statement will ignore missing values.

The SUM operator (+) will not ignore missing values and sets everything to missing when it's blank.

d_operator = a+c+g;
d_statement= sum(a, c, g);

@Gluttony wrote:

Hi everyone,
I need help for this case :

I have a dataset DATA with columns A, B and C

I want to create a new column D = A + C + G

G does not exist in DATA, thus it will create blank for D. But is there a way to set non existing column (G) default values to 0 and then D will be equal to A + C ?

Thank you,

Gluttony

Re: Non Existing Column

Gluttony — Thu, 12 Mar 2020 09:32:25 GMT

Thank you all for your answers !

Gluttony