Create a new variable to a merged dataset

jamieflynn — Sat, 23 Nov 2019 17:21:50 GMT

Hello everyone,

I'm trying to merge 2 datasets and then create a new variable in the merged dataset.

The new variable is Status where if any model in Inventory dataset does not appear in Purchase dataset, Status would be "Not Sold", otherwise Status is "Sold".

So I wrote it as if Quantity is missing, then Status ="Not Sold", else Status = "Sold".

Here is what I have:

/*Sort Inventory and Purchase datasets by Model*/
proc sort data=BSTA445.inventory out=invt_sorted;
by Model;
run;

proc sort data=BSTA445.purchase out=pur_sorted;
by Model;
run;


/*Merge 2 sorted datasets*/
data notpurch;
	merge invt_sorted (in=InInvent) pur_sorted (in=inPurch);
	by Model;
	if missing(Quantity) then Status = "Not Sold";
	else Status = "Sold";
	keep Model Price;
run;

title "List of unpurchased Models and respective Prices";
proc print data=notpurch noobs;
run;
title;

I don't know why in the merged dataset, there is no new variable created.

Can anyone please explain what has gone wrong in my code?

Thanks a lot!

Re: Create a new variable to a merged dataset

ballardw — Tue, 26 Nov 2019 00:23:34 GMT

data notpurch;
	merge invt_sorted (in=InInvent) pur_sorted (in=inPurch);
	by Model;
	if missing(Quantity) then Status = "Not Sold";
	else Status = "Sold";
	keep Model Price;
run;

Your KEEP statement says not to keep the STATUS variable.

topic Re: Create a new variable to a merged dataset in SAS Programming

Create a new variable to a merged dataset

Re: Create a new variable to a merged dataset