Wide Dataset

GS2 — Tue, 26 Sep 2023 17:30:27 GMT

Hello,

Using SAS 9.4, I am running the following code to try and create a wide data set for a matched analysis. I have 1 linking variable "subclass". I have renamed all variables from the 2nd data set with the suffix "_wide". The goal is to create 1 data with set all variables and their _wide counterpart (i.e. sex and sex_wide) from both observations with the same subclass. When I run the merge statement at the end, all of the data from "_wide" data set is missing. Any help on how I can correct this issue would be greatly appreciate. Thank you

data wide1;
	set ing.analysis;
	if subclass in: ('1') then output;
run;*NOTE: The data set WORK.WIDE1 has 181 observations and 84 variables.;

data wide2;
	set ing.analysis;
	if subclass in: ('2') then output;
run;*NOTE: The data set WORK.WIDE2 has 362 observations and 84 variables.;

*add suffix to end of matched variables;
proc sql;
 select cats(name,'=',name,'_wide') AS  wide2
          into :list
          separated by ' '
          from dictionary.columns
          where libname = 'WORK' and memname = 'WIDE2';
quit;

data  wide2;
	set wide2 (rename = (&list));
	rename subclass_wide = subclass;
run;*NOTE: The data set WORK.WIDE2 has 362 observations and 84 variables.;

proc sort data= wide1;	
	by subclass;
run;
proc sort data= wide2;	
	by subclass;
run;

data ing.wide_analysis;
	merge wide1 wide2;
	by subclass;
run;*NOTE: There were 181 observations read from the data set WORK.WIDE1.
NOTE: There were 362 observations read from the data set WORK.WIDE2.
NOTE: The data set ING.WIDE_ANALYSIS has 543 observations and 167 variables.;

Re: Wide Dataset

Tom — Tue, 26 Sep 2023 17:44:22 GMT

181 + 362 = 543

So none of the values of SUBCLASS that are in WIDE1 are in WIDE2.

If you want the values to merge they have to match.

Re: Wide Dataset

GS2 — Tue, 26 Sep 2023 18:10:24 GMT

Thank you. That was an oversight on my part.

topic Re: Wide Dataset in SAS Programming

Wide Dataset

Re: Wide Dataset

Re: Wide Dataset