topic Re: Skip last row in data file SAS DI Studio in SAS Data Management

Skip last row in data file SAS DI Studio

jdmarshg — Wed, 30 Sep 2015 19:39:25 GMT

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

Regards,

Jonathan

LinusH — Thu, 01 Oct 2015 13:15:33 GMT

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

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

jdmarshg — Thu, 01 Oct 2015 18:45:56 GMT

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 — Thu, 01 Oct 2015 20:15:05 GMT

Disregard last statement.

Testing concept.

Regards,

Jonathan