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:
|
|
