topic Re: How do I create a Data set of mulitple teams to single dates? in SAS Programming

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

mauley — Tue, 18 Dec 2018 12:24:05 GMT

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 — Tue, 18 Dec 2018 12:39:58 GMT

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 — Tue, 18 Dec 2018 12:57:00 GMT

proc sql;

create table want as

select *

from date , team ;

quit;

mauley — Tue, 18 Dec 2018 13:41:13 GMT

Thank YOU!

I was having a complete brain block!