topic Re: how to join a number of columns with same observation in each row with another dataset? in SAS Programming

how to join a number of columns with same observation in each row with another dataset?

Shradha1 — Mon, 01 Feb 2021 08:07:04 GMT

I have a dataset with 2 columns and 10 rows like this:

student marks
a 10
b 40
c 39
d 45
e 78
f 65
g 38
h 87
i 98
j 29

I have another single row dataset with 5 columns-

col1 col2 col3 col4 col5
m k g h s

Now I want to merge both the datasets in such a way that the single row of dataset 2 is joined alongside each row of dataset 1 .The final dataset may look like this:

student marks col1 col2 col3 col4 col5
a 10 m k g h s
b 40 m k g h s
c 39 m k g h s
d 45 m k g h s
e 78 m k g h s
f 65 m k g h s
g 38 m k g h s
h 87 m k g h s
i 98 m k g h s
j 29 m k g h s

How do I achieve this. I am working on base sas. Please help

Re: how to join a number of columns with same observation in each row with another dataset?

PeterClemmensen — Mon, 01 Feb 2021 08:10:55 GMT

Here is one way

data a;
input student $ marks;
datalines;
a  10
b  40
c  39
d  45
e  78
f  65
g  38
h  87
i  98
j  29
;

data b;
input (col1-col5)(:$);
datalines;
m k g h s
;

data want;
   set a;
   if _N_ = 1 then set b;
run;

Re: how to join a number of columns with same observation in each row with another dataset?

LinusH — Mon, 01 Feb 2021 09:55:56 GMT

Or a SQL cartesian join:

proc sql;
   select a.*, b.*
      from a, b
   ;
quit;