Re: Skip last row in data file SAS DI Studio

jdmarshg · Posted 09-30-2015 03:39 PM

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

Regards,

Jonathan

LinusH · Posted 10-01-2015 09:15 AM

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).

Data never sleeps

jdmarshg · Posted 10-01-2015 02:45 PM

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 · Posted 10-01-2015 04:15 PM

Disregard last statement.

Testing concept.

Regards,

Jonathan