topic I'm trying to inner join two tables imported from excel both tables have the same SIN data set in SAS Procedures

I'm trying to inner join two tables imported from excel both tables have the same SIN data set

AlonzoT — Mon, 22 May 2023 22:29:53 GMT

Re: I'm trying to inner join two tables imported from excel both tables have the same SIN data set

Tom — Mon, 22 May 2023 23:20:36 GMT

Pasting text as pictures makes it very hard to read.

You define table aliases using different two letter abbreviations than the aliases you use in the WHERE clause.

Re: I'm trying to inner join two tables imported from excel both tables have the same SIN data set

A_Kh — Wed, 24 May 2023 22:13:27 GMT

Your ON clause has a typo: It shouldn't be on sc.SIN=ct.SIN, but ON ST.SIN=CT.SIN

Re: I'm trying to inner join two tables imported from excel both tables have the same SIN data set

Reeza — Wed, 24 May 2023 22:02:08 GMT

FYI - the fact that the data from Excel is really only minimal relevant. Once you've imported it, it's a SAS data set. You should take the time to review this to make sure it's occurred correctly, ie variable names, labels and types are correct and values were read in correctly.