Hello, I have a database who looks like this: Years pf1 pf2 pf3 pf4 pf5 pf6 pf7 pf8 … pf119 2006 0,99995 0,99984 0,99969 0,99954 0,99939 0,99924 0,99909 0,99894 0,99864 2007 0,90419475 0,86805513 0,95407293 0,8676255 0,9106782 0,89055109 0,99534984 0,82628474 0,85245713 2008 0,9547502 0,86854718 0,80312147 0,94014155 0,92665103 0,97910746 0,95293207 0,94262974 0,86068283 2009 0,84331363 0,81522629 0,98906643 0,88725626 0,94812541 0,85975439 0,93789548 0,98424024 0,82137827 2010 0,83663445 0,84507837 0,91888898 0,95447863 0,87323238 0,98027643 0,93558909 0,85553856 0,97474632 2011 0,86543087 0,9058221 0,80951478 0,97289518 0,80704643 0,94382676 0,89678733 0,93423198 0,89965292 2012 0,91703081 0,88559104 0,8006615 0,89746979 0,96224727 0,93283978 0,99704944 0,95622047 0,92032314 … 2056 0,91923551 0,98895088 0,94733737 0,88924355 0,84496988 0,88136723 0,86645268 0,88707045 0,9918978 I would like to create a single database for each line (without the first column, which is the name of the file), i.e.: 2006.sas7bdat: pf1 pf2 pf3 pf4 pf5 pf6 pf7 pf8 … pf119 0,99995 0,99984 0,99969 0,99954 0,99939 0,99924 0,99909 0,99894 0,99864 2007.sas7bdat: pf1 pf2 pf3 pf4 pf5 pf6 pf7 pf8 … pf119 0,90419475 0,86805513 0,95407293 0,8676255 0,9106782 0,89055109 0,99534984 0,82628474 0,85245713 etc. Is there a way to do this with a macro or something. Otherwise, it's not very efficient to do it manually. Thanks
... View more