Hi all,

I have a database made as follows, where there are basically Molecules observed for a set of countries every year from 1996 to 2020. Each observation has an associated price.
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input float Year str25 Country str43 Molecule float(price id_mol)
1996 "AUSTRIA R&H" "ACETYLCYSTEINE"  .4157137 1
1997 "AUSTRIA R&H" "ACETYLCYSTEINE"  .3727205 1
1998 "AUSTRIA R&H" "ACETYLCYSTEINE"  .3773433 1
1999 "AUSTRIA R&H" "ACETYLCYSTEINE"  .3831513 1
2000 "AUSTRIA R&H" "ACETYLCYSTEINE"  .3823847 1
2001 "AUSTRIA R&H" "ACETYLCYSTEINE"  .4448054 1
2002 "AUSTRIA R&H" "ACETYLCYSTEINE" .49274895 1
2003 "AUSTRIA R&H" "ACETYLCYSTEINE"  .4917107 1
2004 "AUSTRIA R&H" "ACETYLCYSTEINE" .55233395 1
2005 "AUSTRIA R&H" "ACETYLCYSTEINE"  .3655448 1
2006 "AUSTRIA R&H" "ACETYLCYSTEINE"  .3495277 1
2007 "AUSTRIA R&H" "ACETYLCYSTEINE"  .3377936 1
2008 "AUSTRIA R&H" "ACETYLCYSTEINE"   .301784 1
2009 "AUSTRIA R&H" "ACETYLCYSTEINE"  .1599057 1
2010 "AUSTRIA R&H" "ACETYLCYSTEINE" .16360366 1
2011 "AUSTRIA R&H" "ACETYLCYSTEINE"   .163047 1
2012 "AUSTRIA R&H" "ACETYLCYSTEINE"  .1655935 1
2013 "AUSTRIA R&H" "ACETYLCYSTEINE"  .1666526 1
2014 "AUSTRIA R&H" "ACETYLCYSTEINE" .16726673 1
2015 "AUSTRIA R&H" "ACETYLCYSTEINE"  .1675701 1
2016 "AUSTRIA R&H" "ACETYLCYSTEINE" .16710077 1
2017 "AUSTRIA R&H" "ACETYLCYSTEINE" .16877614 1
2018 "AUSTRIA R&H" "ACETYLCYSTEINE" .16882323 1
2019 "AUSTRIA R&H" "ACETYLCYSTEINE" .16957738 1
2020 "AUSTRIA R&H" "ACETYLCYSTEINE"  .1719242 1
1996 "BELGIUM R&H" "ACETYLCYSTEINE"  .2893498 1
1997 "BELGIUM R&H" "ACETYLCYSTEINE" .29018003 1
1998 "BELGIUM R&H" "ACETYLCYSTEINE"  .3059801 1
1999 "BELGIUM R&H" "ACETYLCYSTEINE"  .3049526 1
2000 "BELGIUM R&H" "ACETYLCYSTEINE"  .2898359 1
2001 "BELGIUM R&H" "ACETYLCYSTEINE" .26924512 1
2002 "BELGIUM R&H" "ACETYLCYSTEINE" .24852555 1
2003 "BELGIUM R&H" "ACETYLCYSTEINE" .24799144 1
2004 "BELGIUM R&H" "ACETYLCYSTEINE" .23944776 1
2005 "BELGIUM R&H" "ACETYLCYSTEINE" .23523575 1
2006 "BELGIUM R&H" "ACETYLCYSTEINE"  .2255104 1
2007 "BELGIUM R&H" "ACETYLCYSTEINE"   .228167 1
2008 "BELGIUM R&H" "ACETYLCYSTEINE"  .2090917 1
2009 "BELGIUM R&H" "ACETYLCYSTEINE"  .1669789 1
2010 "BELGIUM R&H" "ACETYLCYSTEINE"  .1611543 1
2011 "BELGIUM R&H" "ACETYLCYSTEINE" .15574604 1
2012 "BELGIUM R&H" "ACETYLCYSTEINE"    .15242 1
2013 "BELGIUM R&H" "ACETYLCYSTEINE" .15054916 1
2014 "BELGIUM R&H" "ACETYLCYSTEINE" .14821963 1
2015 "BELGIUM R&H" "ACETYLCYSTEINE"  .1644117 1
2016 "BELGIUM R&H" "ACETYLCYSTEINE" .18789282 1
2017 "BELGIUM R&H" "ACETYLCYSTEINE" .19258536 1
2018 "BELGIUM R&H" "ACETYLCYSTEINE" .19615185 1
2019 "BELGIUM R&H" "ACETYLCYSTEINE" .19684924 1
2020 "BELGIUM R&H" "ACETYLCYSTEINE" .19247077 1
1996 "FINLAND R&H" "ACETYLCYSTEINE" .25428084 1
1997 "FINLAND R&H" "ACETYLCYSTEINE" .26102293 1
1998 "FINLAND R&H" "ACETYLCYSTEINE" .26538986 1
1999 "FINLAND R&H" "ACETYLCYSTEINE"  .2598349 1
2000 "FINLAND R&H" "ACETYLCYSTEINE" .25879398 1
2001 "FINLAND R&H" "ACETYLCYSTEINE" .26003125 1
2002 "FINLAND R&H" "ACETYLCYSTEINE" .25887492 1
2003 "FINLAND R&H" "ACETYLCYSTEINE"  .2617417 1
2004 "FINLAND R&H" "ACETYLCYSTEINE" .26013848 1
2005 "FINLAND R&H" "ACETYLCYSTEINE" .28077456 1
2006 "FINLAND R&H" "ACETYLCYSTEINE" .29302105 1
2007 "FINLAND R&H" "ACETYLCYSTEINE" .29209185 1
2008 "FINLAND R&H" "ACETYLCYSTEINE" .26453534 1
2009 "FINLAND R&H" "ACETYLCYSTEINE"  .2197161 1
2010 "FINLAND R&H" "ACETYLCYSTEINE" .23960052 1
2011 "FINLAND R&H" "ACETYLCYSTEINE" .24772166 1
2012 "FINLAND R&H" "ACETYLCYSTEINE" .24772178 1
2013 "FINLAND R&H" "ACETYLCYSTEINE" .25290293 1
2014 "FINLAND R&H" "ACETYLCYSTEINE" .25612336 1
2015 "FINLAND R&H" "ACETYLCYSTEINE" .25494066 1
2016 "FINLAND R&H" "ACETYLCYSTEINE"  .2500443 1
2017 "FINLAND R&H" "ACETYLCYSTEINE" .25493976 1
2018 "FINLAND R&H" "ACETYLCYSTEINE" .25494185 1
2019 "FINLAND R&H" "ACETYLCYSTEINE" .25494125 1
2020 "FINLAND R&H" "ACETYLCYSTEINE" .25494233 1
1996 "GERMANY"     "ACETYLCYSTEINE"  .9930684 1
1997 "GERMANY"     "ACETYLCYSTEINE"  .8607007 1
1998 "GERMANY"     "ACETYLCYSTEINE"  .8087717 1
1999 "GERMANY"     "ACETYLCYSTEINE"  .7546561 1
2000 "GERMANY"     "ACETYLCYSTEINE"  .7608463 1
2001 "GERMANY"     "ACETYLCYSTEINE"  .7947596 1
2002 "GERMANY"     "ACETYLCYSTEINE"  .7622804 1
2003 "GERMANY"     "ACETYLCYSTEINE"  .7398452 1
2004 "GERMANY"     "ACETYLCYSTEINE"  .7029018 1
2005 "GERMANY"     "ACETYLCYSTEINE"  .6774241 1
2006 "GERMANY"     "ACETYLCYSTEINE"  .6377584 1
2007 "GERMANY"     "ACETYLCYSTEINE"  .5989892 1
2008 "GERMANY"     "ACETYLCYSTEINE"  .2166901 1
2009 "GERMANY"     "ACETYLCYSTEINE"  .1602655 1
2010 "GERMANY"     "ACETYLCYSTEINE" .16640347 1
2011 "GERMANY"     "ACETYLCYSTEINE" .17116722 1
2012 "GERMANY"     "ACETYLCYSTEINE" .17944063 1
2013 "GERMANY"     "ACETYLCYSTEINE" .18523474 1
2014 "GERMANY"     "ACETYLCYSTEINE" .19792032 1
2015 "GERMANY"     "ACETYLCYSTEINE" .21397085 1
2016 "GERMANY"     "ACETYLCYSTEINE" .21987206 1
2017 "GERMANY"     "ACETYLCYSTEINE" .23084398 1
2018 "GERMANY"     "ACETYLCYSTEINE" .24874364 1
2019 "GERMANY"     "ACETYLCYSTEINE" .27717045 1
2020 "GERMANY"     "ACETYLCYSTEINE"  .2954198 1
end
The idea is to export in excel n files where n is the number of countries each made as follows:
E.g. Country = Italy

1996 1997. 1998 ... 2020
Molecule

Mol.a0 pr_0_1996 pr_0_1997 pr_0_1998 pr_0_2020
Mol.a1 pr_1_1996 pr_1_1997 pr_1_1998 pr_1_2020
...
Mol.ak pr_k_1996 pr_k_1997 pr_k_1998 pr_k_2020

where of course the price is the price of molecule I in country c at year j. The same should be done for all countries so that I end up with num of countries files.

Is it possible?


Thank you very much,

Federico