data have ; input ISIN $ NAME $ Y2000 Y2001 Y2002 Y2003 Y2004 ; CARDS; UK123 ABC 5000 4030 3500 2070 1050 UK124 DEF 6000 4330 3550 654 5678 UK125 GHI 5070 5030 390    683    345 UK126 JKL 5040 4030 390    45    567 ; RUN; PROC PRINT DATA = HAVE;RUN; PROC TRANSPOSE DATA = HAVE OUT = WANT(RENAME = (_NAME_ = YEAR )) ;by name ISIN ;run; proc print data = want;run; The Variable names must begin with a character or '_' , so I added a 'Y' at the beginning , you can process it in a datastep to the way you want. Work.Have: Obs ISIN NAME Y2000 Y2001 Y2002 Y2003 Y2004 1 UK123 ABC 5000 4030 3500 2070 1050 2 UK124 DEF 6000 4330 3550 654 5678 3 UK125 GHI 5070 5030 390 683 345 4 UK126 JKL 5040 4030 390 45 567 Work.Want: Obs NAME ISIN YEAR COL1 1 ABC UK123 Y2000 5000 2 ABC UK123 Y2001 4030 3 ABC UK123 Y2002 3500 4 ABC UK123 Y2003 2070 5 ABC UK123 Y2004 1050 6 DEF UK124 Y2000 6000 7 DEF UK124 Y2001 4330 8 DEF UK124 Y2002 3550 9 DEF UK124 Y2003 654 10 DEF UK124 Y2004 5678 11 GHI UK125 Y2000 5070 12 GHI UK125 Y2001 5030 13 GHI UK125 Y2002 390 14 GHI UK125 Y2003 683 15 GHI UK125 Y2004 345 16 JKL UK126 Y2000 5040 17 JKL UK126 Y2001 4030 18 JKL UK126 Y2002 390 19 JKL UK126 Y2003 45 20 JKL UK126 Y2004 567 Thanks ... View more

If you need to refer a permanent dataset  created sometime back , you should use the libname statement to point the the dataset librarary and then you can access the dataset by two level name. Eg: If my dataset library is "BAS0000.XXX.YY.DATA" and the Dataset name is HAVE. libname Mydata 'BAS0000.XXX.YY.DATA'; Data WANT ; Set Mydata.HAVE ; Run; If you want to refer a Dataset created in the same SAS session  but you have to derive the Dataset name dynamically , you can do something like DATA WANT ; SET HLQ.SLQ.TLQ.A&YYMMDD ; RUN; FILENAME should be used only when we had to access the OS files like reading or writing to a file. Thanks Karthik ... View more