p**********l 发帖数: 1160 | 1 I need to make two files togeter, the first file contains for example a b c
d four columns and there are more than 40 records.
Let say it looks like this:
a1 b1 c1 d1
a2 b2 c2 d2
...
a6 b6 c6 d6
and I have a second file that has just one column e and this column has more
than 10 records,
Let's say it looks like this:
e1
e2
...
e9
My questions if I want the output to show that every record in the fisrt
file needs to have e1, e2, ..e9like this:
a1 b1 c1 d1 e1
a1 b1 c1 d1 e2
...
a1 b1 c1 d1 e9
a2 b2 c2 d2 e1
a2 b2 c2 d2 e2
...
a2 b2 c2 d2 e9
...
a6 b6 c6 d6 e9
This is not a homework problem. I want to write a sas code because this type
of process has been done manualy in the past.Could anybody kindly give me
some suggestions?
Thanks, | l******n 发帖数: 9344 | 2 proc sql;
select A.*, B.* from firsttable A, secondtable B;
quit;
c
more
【在 p**********l 的大作中提到】 : I need to make two files togeter, the first file contains for example a b c : d four columns and there are more than 40 records. : Let say it looks like this: : a1 b1 c1 d1 : a2 b2 c2 d2 : ... : a6 b6 c6 d6 : and I have a second file that has just one column e and this column has more : than 10 records, : Let's say it looks like this:
|
|