set same value to all cells - proc sql

[podarum]

Hi,  I'm merging 2 tables in proc sql and I want the new  table to have a forced value in one field.

So mergin Table A and Table B to create Table C, and I want to force a field called MG_typ found in Table A to be all = 'Residential'.. how can I do that..

similar to simply assigning MG_typ = 'Residential' in base SAS. 

Thanks

[stat_sas]

Use Case statement.

[Reeza · Accepted solution]

Depends on if the variable exists in the other table at all or in both already.

If in neither table then the following will work:

select 'Residential' as MG_typ

If it's missing in all of table B, but present in All of Table A you could use the coalesce function:

select coalesce(MG_type, "Residential") as MG_Type

Otherwise some sort of Case Statement is required.

[podarum]

Thank you Reeza