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.
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.
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: