Thanks for the input fellas. It seems this table is pretty much a lost cause as I've been told by the current teacher that the table we're after is being created by a Query. Though i did have a look at the table in SASMC and the current teacher seems to know how to remake that table based on the columns i provided so we're back on track.   Alex: your solution would also prevent this issue arrising in the future as i have now exported loaded tables that were also created by the current teacher. ... View more