Left Join for uneven dataset

[sas_apprenant]

Hello, I am trying to left join two datasets but it is failing miserably! Can someone help rectify this? I attached the pics of before and after in a pdf format. In the pics, you can see the simple log reg output and the other is for multiple log reg. The issue comes when I try to combine the dataset to generate one output and my rows don't merge properly resulting in missing values for adjusted odd ratios and p-values.

Thank you for the help rendered.

proc sql;
	create table logit_table as
	select a.*, b.M_OddsRatios_CI , b.M_p_value, b.M_global_P_value
	from simplelog1 a left join  multilog1 b
	on a.Category=b.Category and 
	a.Demographic_Characteristics=b.Demographic_Characteristics
	order by f_order; quit;

[Kurt_Bremser]

Post log text like you posted your code. DO NOT post pictures. Post example data as code (data steps with datalines), so we can quickly, easily and accurately recreate your datasets for testing.

To rectify your problem, follow Maxim 3: Know Your Data. Inspect your datasets for variable types, attributes and content. Be aware that leading blanks or non-displayable characters in or after the string values might throw off your intended matches.

[sas_apprenant]

Thank you for the reply. I am aware of knowing my data, even though I'm relatively new to sas compared to R. I am using sas studio, Where can I print the log file to? I tried using the code below, but there was no file.

proc printto log=file.log;
run;

[Kurt_Bremser]

Just copy/paste the log from SAS Studio to a window opened with the {i} button.

---

@sas_apprenant wrote:

Thank you for the reply. I am aware of knowing my data, even though I'm relatively new to sas compared to R. I am using sas studio, Where can I print the log file to? I tried using the code below, but there was no file.

proc printto log=file.log;
run;

---

[SASKiwi]

You will have to manually edit the variables Demographic_Characteristics and Category in the two input datasets so they match correctly. Then the join will work properly

[sas_apprenant]

How do you reckon I go about doing that?

[SASKiwi · Accepted solution]

@sas_apprenant  - By ensuring each of the two columns that you use to join the two tables have identical values for the rows that you want to match with each other. For example one of your columns contains missing values - these need to populated with the right values to match to the required column in the other table.

[sas_apprenant]

Thanks I see what you meant. I had to go in my code and remove one line to make it all compatible. 

Appreciate your rendered thoughts.