If the filename statement works without problems you can use the data import wizard as a start indicating teh fileref SITE1 as the source and name the output, Library and dataset as desired.
If that works at all then the datastep code in the Log can be copied and modified to provide a bit more control of the resulting data set.
... View more