Hey,
Thank you. Let me be more specific about my request ;
I have a dataset called A like this :
ID year
1 2013
2 2015
...
I need to add for each ID, a variable "quantity". Yet, this variable is in different datasets based on the year date : I have datasets with the year in their name B_2010, B_2011,B_2013,...
These datasets B_year are like this :
ID quantity
1 553
2 789
...
I want this in dataset A :
ID year quantity
1 2013 553
2 2015 789
...
But how can i tell SAS to search the information in the right table ?
My point is to not merge dataset B_2013, B_2015,... because i have many many tables depending on the year.
Hope it's clear
... View more