SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Skip last row in data file SAS DI Studio

Reply
Contributor
Posts: 70

Skip last row in data file SAS DI Studio

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

 

 

Regards,

Jonathan

Super User
Posts: 5,260

Re: Skip last row in data file SAS DI Studio

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

Data never sleeps
Contributor
Posts: 70

Re: Skip last row in data file SAS DI Studio

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

Contributor
Posts: 70

Re: Skip last row in data file SAS DI Studio

Disregard last statement. 

Testing concept. 

 

Regards,

Jonathan

Ask a Question
Discussion stats
  • 3 replies
  • 304 views
  • 0 likes
  • 2 in conversation