topic Re: Nth dataset in a library in SAS Programming

Nth dataset in a library

BrahmanandaRao — Wed, 09 Dec 2020 16:40:19 GMT

How to delete last nth dataset
In a library

Re: Nth dataset in a library

Reeza — Wed, 09 Dec 2020 16:49:30 GMT

PROC DATASETS - more details are required to identify the nth/last data set. Is that the last created data set or with largest N or a date stamp?

Re: Nth dataset in a library

RichardDeVen — Wed, 09 Dec 2020 19:28:45 GMT

Do your data set names have a numeric suffix, say IMPORT1 to IMPORT100 and if N=25 you want to delete either IMPORT1-25 or IMPORT76-100 ?
Do you want the delete the N newest data sets by modification date ?
Do you want the delete the N oldest data sets ?

Re: Nth dataset in a library

ChrisNZ — Thu, 10 Dec 2020 09:07:05 GMT

Nth by alphabetical order?

Re: Nth dataset in a library

BrahmanandaRao — Thu, 10 Dec 2020 10:23:42 GMT

Which procedure or dictionary tables have to use

Re: Nth dataset in a library

Kurt_Bremser — Thu, 10 Dec 2020 10:28:26 GMT

You said it: DICTIONARY.TABLES.

And PROC DATASETS was already mentioned.

@BrahmanandaRao wrote:
Which procedure or dictionary tables have to use

Re: Nth dataset in a library

BrahmanandaRao — Fri, 11 Dec 2020 14:21:40 GMT

Give solution

Re: Nth dataset in a library

Tom — Fri, 11 Dec 2020 17:18:42 GMT

@BrahmanandaRao wrote:
Give solution

To get a solution you need to define the problem in more detail. Example would help. What is the criteria for ordering? Alphabetical by name? Numeric by something else? If so what? So part of the filename? Creation timestamp?

Show an example with 3 or 4 files and tell which one is the Nth and why.

Re: Nth dataset in a library

Reeza — Fri, 11 Dec 2020 18:29:24 GMT

@BrahmanandaRao wrote:
Give solution

You shouldn't expect an answer or response longer than your question.

Re: Nth dataset in a library

Kurt_Bremser — Fri, 11 Dec 2020 19:07:57 GMT

@BrahmanandaRao wrote:
Give solution

Solution.