topic set same value to all cells - proc sql in SAS Procedures

set same value to all cells - proc sql

podarum — Fri, 10 Oct 2014 19:15:55 GMT

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

Re: set same value to all cells - proc sql

stat_sas — Fri, 10 Oct 2014 19:43:32 GMT

Use Case statement.

Re: set same value to all cells - proc sql

Reeza — Fri, 10 Oct 2014 19:59:33 GMT

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.

Re: set same value to all cells - proc sql

podarum — Fri, 10 Oct 2014 20:08:32 GMT

Thank you Reeza