topic Re: keep data subset for merging in SAS Studio

keep data subset for merging

RebeccaJW — Mon, 15 Apr 2019 17:51:51 GMT

Hello,

I have a problem about subsetting data.

I need to keep the observations where the variable A equals to "speech" from a dataset. Then I need to merge this new dataset with another dataset and keep the observations that are in both datasets.

It is appreciated if anyone can help me. Thank you!

Re: keep data subset for merging

Reeza — Mon, 15 Apr 2019 18:11:04 GMT

Which step are you having problems with? It would probably help if you showed the code you tried with an explanation of what isn't working. You may need to provide sample data, but starting with the code is a good first step.

Re: keep data subset for merging

Tom — Mon, 15 Apr 2019 18:12:17 GMT

Sounds like you know what to do.

Post the code you created for each of those steps and if it generates errors the log from your attempt to run it.

Remember to use the Insert Code button {i} on the gui to get a pop-up window to paste/edit the lines from the log. Otherwise the forum editor will re-flow the lines and make the log harder to read.

Re: keep data subset for merging

RebeccaJW — Mon, 15 Apr 2019 18:21:28 GMT

data orig;
	infile "/home/Projects/Project2/A/B_clean.csv" dsd missover firstobs=2;
	informat title name $10000. date MMDDYY10. ;
	format date DDMMYY10.;
    input title name date;
    
    if title = "NEW" then date = '31OCT12010'd;
    if title = "OLD" then date = '15JUN2008'd;	

run;

data orig.sub;
	set orig;
	where name="speech";
run;

This is what I have written. The first part works well, but in the orig.sub step, there is an error shown below:

ERROR: Libref ORIG is not assigned.

Thank you for replying!

Re: keep data subset for merging

Tom — Mon, 15 Apr 2019 18:23:20 GMT

Names cannot contain periods. By using ORIG.SUB you told SAS to create a dataset named SUB in library pointed to by the libref ORIG.

Names can use letter, digits and underscores. They must NOT start with a digit.

Re: keep data subset for merging

Reeza — Mon, 15 Apr 2019 18:28:03 GMT

data orig.sub;
	set orig;
	where name="speech";
run;

Did you create the ORIG library?

If not, just remove that portion of the name or declare the library first. The remainder of your code looks fine.

Re: keep data subset for merging

RebeccaJW — Mon, 15 Apr 2019 18:28:50 GMT

Thank you! It works now!

Re: keep data subset for merging

RebeccaJW — Mon, 15 Apr 2019 18:29:18 GMT

Thank you for replying! It works now!