topic Create new dataset in SAS Programming

Create new dataset

Raj21 — Wed, 27 Jul 2016 18:29:25 GMT

I have two data sets. One of which is a master data set with 965 observations and then i want to take the second data set which is 95 values and take every value and add it to each observation in the first data set. Could someone point me in the correct direction to a command that can do this. It should become 91675 observations by doing this, and then i can just weed out duplications with a if-then delete statement.

Re: Create new dataset

Raj21 — Wed, 27 Jul 2016 18:39:42 GMT

A little more information for this one.

I would want these observations (master data set)

EquipmentTypeID	CommodityCodeA	SolverInclude	CompartmentID
C45CD	NONPRO 28-30	Yes	<No_Compartment_Specified>
C45CD	NONPRO 34-38	Yes	<No_Compartment_Specified>
C45CD	NONPRO 38-42	Yes	<No_Compartment_Specified>
C45CD	NONPRO 45-50	Yes	<No_Compartment_Specified>

To have these observations added to each one of the aboves observations.

CommodityCodeB

*DFT

3RD-PARTY

CHEMICALS

DRY

DRY CHEMICAL

DRY EE

DRY ES

DRY FAK

DRY FOOD

DRY GENERAL

DRY HAZMAT

DRY NORIDEFD

DRY PET FOOD

DRY SCENTED

EE 28-30

EE 34-38

EE 38-42

Then I would just look for when commodityA and commodityB are the same and delete those observations and i would be set, so this would become 17 X 4 = 68 observations.

Re: Create new dataset

TomKari — Wed, 27 Jul 2016 18:41:57 GMT

How close is

proc sql noprint;

create table combined as

select * from table a, table b;

quit;

Re: Create new dataset

Raj21 — Wed, 27 Jul 2016 18:44:22 GMT

Pretty sure that worked perfect! Thank you!