How do I create a Data set of mulitple teams to single dates?

[mauley]

Hello!

I have a list of dates, lets say:

01Jan2017

01Feb2017

01Mar2017

And I have a list of teams, lets say:

Team_1

Team_2

Team_3

I am trying to create a data set that I can 'hang' further data from that would look like this:

Date                Team

01Jan2017      Team_1

01Jan2017      Team_2

01Jan2017      Team_3

01Feb2017      Team_1

01Feb2017      Team_2

01Feb2017      Team_3

etc.......

[Astounding · Accepted solution]

Let's say you have this information in SAS data sets named DATE_DATA and TEAM_DATA:

proc sql;

create table want as select * from date_data, team_data;

quit;

[Ksharp]

proc sql;

create table want as

select *

 from date , team ;

quit;

[mauley]

Thank YOU!

I was having a complete brain block!