topic Re: I want to find the latest file and wanted to move it in a different folder. in SAS Programming

How to find the latest file and how to move it in a different folder.

annypanny — Wed, 15 Apr 2020 07:00:42 GMT

Hi, suppose I have multiple external files e,g.onlineuser20200414.txt , onlineuser20200415.txt, Userxyz.txt in a input folder location "/loc/sasdataset/lev1" now the latest file i.e., onlineuser20200415.txt from that location I have to extract into a dataset and will be moved to different archived folder location "/loc/sasdataset/xyz" and if any file aged more than 30 days e.g onlineuser20200314.txt will be automatically deleted from the location "/loc/sasdataset/xyz". How can I find the latest file and extract it into a dataset in sas EG? Please if anybody give a code example.

Thanks in advance

Edited

Re: I want to find the latest file and wanted to move it in a different folder.

Kurt_Bremser — Tue, 14 Apr 2020 11:22:41 GMT

In SQL, query DICTIONARY.TABLES to find the latest. Note that if you always MOVE files, you will (in the long run) only find one dataset (the most recently added) anyway.

Re: I want to find the latest file and wanted to move it in a different folder.

annypanny — Tue, 14 Apr 2020 11:28:03 GMT

hi, I used DICTIONARY.TABLES but it did'nt work for me, I just wanted to move the latest file in to the folder, how can I, can MACROS makes my life easier?

Re: I want to find the latest file and wanted to move it in a different folder.

Kurt_Bremser — Tue, 14 Apr 2020 11:33:06 GMT

How did you query DICTIONARY.TABLES? Please post your code, using the "little running man" button.

Re: I want to find the latest file and wanted to move it in a different folder.

Patrick — Tue, 14 Apr 2020 11:35:22 GMT

Are these SAS tables or some external files on disk?

Re: I want to find the latest file and wanted to move it in a different folder.

annypanny — Tue, 14 Apr 2020 11:36:25 GMT

sas tables

Re: How to find the latest file and how to move it in a different folder.

kelxxx — Tue, 14 Apr 2020 13:39:06 GMT

/*Where the files in*/
%let repfic=H:\;

/*Where to move*/
%let repmove=H:\Batch;

/*ficrep contains all files name in the &refic*/
FILENAME ficrep PIPE "dir /b &repfic";

/*create table SAS = ficrep, it is necessary if in ficrep have the other file*/
data toto;
infile ficrep end=eof;
length x $50;
input x;
run;


/*traitement*/
data tata;  /*data _null_;*/
set toto(where=(x like "online%"));
length _repname _repmove $200;

_y=put(date(),yymmddN.); /*date today 20200414*/
_over30=put(date()-30,yymmddN.); /*date aged 30day 20200315*/
_datex=substr(x,11,8);			/*date in filename*/
_repname=cats("&repfic",x);		/*H:\onlineuseryyyymmdd.txt*/
_repmove=catx(" ",x,"&repmove");	/* onlineuseryyyymmdd.txt H:\batch*/

if _datex le _over30 then do;
delete=1;						/*if file aged over 30 days */
Call system(catx(" ","del /Q",_repname));	/*execute a command line windows del /q H:\onlineuseryyyymmdd.txt */
end;										/*    = suppress the file*/
if _datex = _y then do;
move=1;
call system(cats("move /Y &repfic\",_repmove));	/*move /y h:\onlineuseryyyymmdd.txt H:\batch*/
end;												/* move the file to the path spécified*/
drop _:;
run;

I'm not sure thit is what you want but i hope this can help you.

Re: I want to find the latest file and wanted to move it in a different folder.

Tom — Tue, 14 Apr 2020 13:43:46 GMT

@annypanny wrote:
sas tables

Why did your original post use .txt extension on the file names if they are SAS datasets? SAS datasets use .sas7bat as the extension. DICTIONARY.TABLES will not show text files. Just datasets (and then only for places pointed to by active librefs).

Re: I want to find the latest file and wanted to move it in a different folder.

Kurt_Bremser — Tue, 14 Apr 2020 14:06:12 GMT

It did not have the .txt, that's why I suggested using the dictionary tables. But we seem to have a goalpost-mover here.

To the OP: please add a line declaring the edit if you have to edit one of your posts (except if it's just correcting a typo).

If I had known that you were talking about external text files, I would not have suggested the dictionary tables at all.

Re: I want to find the latest file and wanted to move it in a different folder.

annypanny — Wed, 15 Apr 2020 04:58:37 GMT

sorry for that, it was confusing

Re: I want to find the latest file and wanted to move it in a different folder.

Kurt_Bremser — Wed, 15 Apr 2020 05:53:16 GMT

So what are we really talking about, datasets or external files?

Re: I want to find the latest file and wanted to move it in a different folder.

annypanny — Wed, 15 Apr 2020 06:13:39 GMT

datasets

Re: I want to find the latest file and wanted to move it in a different folder.

Kurt_Bremser — Wed, 15 Apr 2020 06:15:58 GMT

Then dictionary.tables is the way to go. Show the SQL code that you tried, post the log from it using the </> button.

Re: I want to find the latest file and wanted to move it in a different folder.

annypanny — Wed, 15 Apr 2020 06:26:55 GMT

</filename file "/sas/sasdataset/lev1/";

data latest;

set file.latest;

run;

create view file as select * from dictionary.tables;

Re: I want to find the latest file and wanted to move it in a different folder.

Kurt_Bremser — Wed, 15 Apr 2020 06:50:21 GMT

To find SAS datasets, define a libname for the directory, then use DICTIONARY.TABLES:

libname file "/sas/sasdataset/lev1/";

proc sql;
create table datasets_in_file as
  select *
  from dictionary.tables
  where libname = 'FILE' /* always use uppercase for libnames and memnames */
;
quit;

Re: I want to find the latest file and wanted to move it in a different folder.

annypanny — Wed, 15 Apr 2020 06:57:06 GMT

and what if it is a extrnal file not sas dataset? just asking for curiosity then we can't use libname then how can I do that?

Re: I want to find the latest file and wanted to move it in a different folder.

Kurt_Bremser — Wed, 15 Apr 2020 07:03:57 GMT

See my answer in your other thread.

@annypanny wrote:
and what if it is a extrnal file not sas dataset? just asking for curiosity then we can't use libname then how can I do that?

Re: I want to find the latest file and wanted to move it in a different folder.

annypanny — Wed, 15 Apr 2020 07:08:19 GMT

sure, how can I move a dataset in to different location?
By using X command?

Re: I want to find the latest file and wanted to move it in a different folder.

Kurt_Bremser — Wed, 15 Apr 2020 07:14:53 GMT

SAS provides a function for copying files:

FCOPY Function

Re: I want to find the latest file and wanted to move it in a different folder.

annypanny — Wed, 15 Apr 2020 07:27:20 GMT

And how can I delete a file if it's age is more than 30 days?