data merge in data step / source indicator variables not created

[Cruise]

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;  

[ed_sas_member · Accepted solution]

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,

[Kurt_Bremser]

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.