What am I doing wrong?
I figure that I must be overlooking something painfully obvious, as there must be valid unit concepts in DRUG_STRENGTH.
I get the same results for amount_unit_concept_ID, numerator_unit_concept_ID, and denominator_unit_concept_ID.
2513 proc sql ;
2514 create table test as
2515 select distinct
2519 v5.drug_strength as ds inner join
2520 v5.concept as c
2522 ds.amount_unit_concept_ID = c.concept_ID;
NOTE: Table WORK.TEST created, with 0 rows and 2 columns.