03-03-2017 05:21 PM
I have one dataset which has one variable, containing a person's name and another dataset with a list of training courses and I was wondering if there is a quick way to create a third dataset which would contain a record for each possible person and training combination. The two datasets do not have a common variable. Keep in mind that we may not know how many of each we have at any time, and the data can change constantly. For example:
Abby Training #1
Abby Training #2
Bobby Training #1
Bobby Training #2
Chris Training #1
Chris Training #2
03-03-2017 05:37 PM
Thanks! That worked perfectly! It did give me a "NOTE: The execution of this query involves performing one or
more Cartesian product joins that can not be optimized." message, but it did seem to create all of the desired records.
03-03-2017 06:02 PM
data a; input name $; cards; abby bobby chris ; run; data b; length training $ 11; input training &; cards; training #1 training #2 ; run; data c; set a; do _n_=1 to nobs; set b nobs=nobs point=_n_; output; end; run;
Need further help from the community? Please ask a new question.