topic Re: SQL in SAS Programming

SQL: Combine And Aggregate Two Data Sets

gaurav85 — Tue, 25 Jan 2022 07:14:24 GMT

I have two tables Country Name(Country and Name) & Export/Import table ( Buyer or Importer and Seller or Exporter) and I want a third table or result set having export value or import value created from "value" column based on the buyer or seller name present group by country. The two tables and the result set is given below.

Re: SQL

japelin — Mon, 24 Jan 2022 17:20:40 GMT

Please present the data in not an image but a form that can be reproduced in the data step like text or sas code with datalines.

Re: SQL

gaurav85 — Mon, 24 Jan 2022 17:23:50 GMT

Name Year
Raj 1999
Rahul 2000
Rahul 2001
Rahul 2002
Sachin 2003
Suraj 2004
Harish 2005
Nihal 2006
Jim 2007
Jack 2008
Jack 2009
Jack 2010
Madan 2011
Madan 2012
Madan 2013

Name
Jack
Madan
Rahul

Re: SQL

japelin — Mon, 24 Jan 2022 17:32:08 GMT

That would be the one in the other post.
Why don't you change the subject to something that completes the question so you don't make a mistake?

Re: SQL

Reeza — Mon, 24 Jan 2022 17:43:09 GMT

Not possible as not all data is present.
Kim is listed in the Buyer column but not listed in the Country table. So your WANT data set does not have the correct inputs to be generated.
Also, please explain explicitly how the country is calculated - is it the buyers or sellers?
And how is Import Value or Export value determined? Why do some have values in both columns and others do not. What are the rules?

As already mentioned you need to present data as text.