Skip last row in data file SAS DI Studio

[jdmarshg]

Is there a way to skp the last row of data within a data file using SAS DI Studio? 

Regards,

Jonathan

[LinusH]

If the source data is in a flatfile, you can tweak the User Written file object to do this:

https://communities.sas.com/t5/SAS-Data-Management/How-to-get-rid-of-the-last-record-while-reading-a...

For tables/SAS data sets, you probably nee to do a user written code (transformation, or in a pre/post code).

[jdmarshg]

That sounds like a good solution but we do not have write access to the file to change it. 

The file reader is being used to read in the data. 

I will look into using the user written code to remove the last row from the data source.

Regards,

Jonathan

[jdmarshg]

Disregard last statement. 

Testing concept. 

Regards,

Jonathan