Repeat a set of values for each ID and treatment phase

[mariko5797]

Is there a simple way to repeat the following values for each distinct ID and phase combination? Note: Not all subjects went through all phases.

* Values to Repeat;
data _param00_;
 input paramcd $ paramn @@;
 cards;
	MALINPCR	1	MALINTHK	2	PCRDNS		3
	THKDNS		4	PKPCRDNS	5	PKTHKDNS	6
	FPDNSPCR	7	FPDNSTHK	8	DURPCR		9
 ;
run;

* ID Variables to Add Values to;
proc sql;
 create table _param0_ as
 	select distinct usubjid, aphase
		from phase
		where not missing(avalc) or not missing(aval);
quit; 

I want the resulting dataset to be like:

1  PHASE1   MALINPCR   1

1  PHASE1   MALINTHK   2

1  PHASE1   PCRDNS      3

1  PHASE1  etc.

1  PHASE2   MALINPCR   1

1  PHASE2  etc.

2  PHASE1   MALINPCR   1

2  PHASE1  etc.

[PaigeMiller · Accepted solution]

Cartesian join in PROC SQL

UNTESTED CODE (because no example data has been provided)

proc sql;
    create table want as select a.*,b.paramcd,b.paramn
    from _param0_,param00_;
quit;