topic data merge in data step / source indicator variables not created in SAS Programming

data merge in data step / source indicator variables not created

Cruise — Tue, 05 May 2020 14:45:31 GMT

Hi folks;

I'd like to analyze mis-matched rows in the resulting data set, thus, creating indicator variables such as ref, ar, car ...et.c. My code runs fine. But these indicator variables: ref, ar, car ...et.c are not found in the resulting dataset temp_alldate_id except 'ho'. What's going wrong here?

data temp_alldata_id; /*325*/ 
length id1name idname $20;
merge 
m.reference_columns       (in=ref)
Apt_rent_id               (in=ar)          
Car_per_pp_id             (in=car)
Hh_type_id                (in=hh)
N_manufact_id             (in=m)
N_service_comp_id         (in=serv)
N_students_per_class_id   (in=st)
N_welfare_facility_id     (in=w)
Ratio_health_welfare_id   (in=hw)
Urbanicity_id             (in=u)
Workers_per_pp_id         (in=wo)
Disability_id             (in=d)
Gdp_id                    (in=g)
Insured_pop_id            (in=i)
N_employees_id            (in=e)
Retail_workers_id         (in=r)
Vac_rate_id               (in=v); 
by id1name idname; 
ref=ref; ar=ar; car=car; hh=hh; ho=ho; m=m; serv=serv; st=st;
w=w; hw=hw; u=u; wo=wo; d=d; g=g; i=i; e=e; r=r; v=v; 
run;

Re: data merge in data step / source indicator variables not created

ed_sas_member — Tue, 05 May 2020 14:51:38 GMT

Hi @Cruise

The issue is due to the fact that you put the same names : ref=ref; etc.

The variable to be created needs to be different : e.g. ref1 = ref.

best,

Re: data merge in data step / source indicator variables not created

Kurt_Bremser — Tue, 05 May 2020 15:12:32 GMT

By using a variable in the IN= option, you declare it as temporary; you can't even force it to be output with a KEEP statement.