topic Re: How do I merge five permanent sas data sets? in SAS Programming

How do I merge five permanent sas data sets?

JUMMY — Tue, 02 Oct 2018 23:55:29 GMT

I have five permanent sas data sets I want to merge together by the ID. The data sets are Y(5 variables), YY(12 variables), YYY(47 variables), YYYY(36 variables) and YYYYY(24 variables). Some of the variables start with the letter "i" and needs to be formatted using the indicators (1='yes' and '0'=no) and gender variable - female (1='yes', 0='no'). Here is my sas:

Libname in "E:\locationofdata";

data raw;

set in.Y in.YY in.YYY in.YYYY in.YYYYY;

run;

proc sort data=raw;

by ID;

run;

proc print data=raw;

run;

data merge;

merge Y YY YYY YYYY YYYYY;

by ID;

run;

proc print data =merge;

run;

Is the sas data step right? How do I format to include the indicators as stated above?

Re: How do I merge five permanent sas data sets?

ChrisNZ — Wed, 03 Oct 2018 01:11:57 GMT

Your two data steps are radically different, and we have no idea what result you want.

Please post a small example of BEFORE and AFTER data.

How to convert datasets to data steps
How to post code

Re: How do I merge five permanent sas data sets?

Astounding — Wed, 03 Oct 2018 01:32:47 GMT

Agreeing with @ChrisNZ, you really have not described the problem. You say you want to merge permanent data sets, but use a SET statement to accomplish that. When you finally get around to using a MERGE statement, you refer to data sets that don't exist. You absolutely will have to clarify what your objective is.

Re: How do I merge five permanent sas data sets?

Reeza — Wed, 03 Oct 2018 01:41:08 GMT

A bit simplistic, but in general,

SET appends data sets - so when you're trying to add rows to a data set.

MERGE combines data sets side by side - so you add columns.

You're doing both which does not seem correct. Without more details though not sure we can help you here.

@JUMMY wrote:

I have five permanent sas data sets I want to merge together by the ID. The data sets are Y(5 variables), YY(12 variables), YYY(47 variables), YYYY(36 variables) and YYYYY(24 variables). Some of the variables start with the letter "i" and needs to be formatted using the indicators (1='yes' and '0'=no) and gender variable - female (1='yes', 0='no'). Here is my sas:

Libname in "E:\locationofdata";

data raw;

set in.Y in.YY in.YYY in.YYYY in.YYYYY;

run;

proc sort data=raw;

by ID;

run;

proc print data=raw;

run;

data merge;

merge Y YY YYY YYYY YYYYY;

by ID;

run;

proc print data =merge;

run;

Is the sas data step right? How do I format to include the indicators as stated above?

Re: How do I merge five permanent sas data sets?

ballardw — Wed, 03 Oct 2018 17:11:02 GMT

@JUMMY wrote:

I have five permanent sas data sets I want to merge together by the ID. The data sets are Y(5 variables), YY(12 variables), YYY(47 variables), YYYY(36 variables) and YYYYY(24 variables). Some of the variables start with the letter "i" and needs to be formatted using the indicators (1='yes' and '0'=no) and gender variable - female (1='yes', 0='no'). Here is my sas:

Libname in "E:\locationofdata";

data raw;

set in.Y in.YY in.YYY in.YYYY in.YYYYY;

run;

proc sort data=raw;

by ID;

run;

proc print data=raw;

run;

data merge;

merge Y YY YYY YYYY YYYYY;

by ID;

run;

proc print data =merge;

run;

Is the sas data step right? How do I format to include the indicators as stated above?

What indicators? You did not use any.

Are the names of the data sets involved n two different libraries?: in.Y would be a dataset belonging to the IN library and Y to WORK library. So merge Y YY YYY YYYY YYYYY; refers to different data sets