topic Re: Getting the path where a .sas file is located. in SAS Enterprise Guide

Getting the path where a .sas file is located.

alepage — Fri, 28 Aug 2020 20:47:31 GMT

Hello,

I am using SAS EG 7.13 on a unix server. I was able to put the list of all the folders in a macro variable.

(see the code below).

%let home = %sysget(HOME);
filename _folder_ "%bquote(/)";
data filenames(keep=memname);
handle=dopen( '_folder_' );

if handle > 0 then do;
count=dnum(handle);
do i=1 to count;
memname=dread(handle,i);
output filenames;
end;
end;
rc=dclose(handle);
run;
filename _folder_ clear;
proc sort data=filenames out=FolderList;
by memname;
run;
data FolderList;
set FolderList;
where memname not contains '.log';
run;
proc sql noprint;
select memname into :list separated by ' '
from work.FolderList;
quit;
%put &list;

From there, I would like to make a macro tha will search for a specific file type in each subfolder (those of the &list) and give me the name and the path of a file having the extension .sas or .log or .spds9

For example,

%macro Path_Name (path=&list, FileName=.sas);

??????????????

%mend;

%Path_Name (path=&list, FileName=.sas);

So If I execute the above mentionned macro which is not complete, I would like to get a listing of all the file ending by .sas as well as there location.

We could execute the same macro to find the file ending by .log or .spd9 and so on as well as there path.

Does someone know how to get this info on a unix server.

regards

Re: Getting the path where a .sas file is located.

Kurt_Bremser — Fri, 28 Aug 2020 20:56:57 GMT

If XCMD is enabled, it is much easier to use the UNIX find command.

Re: Getting the path where a .sas file is located.

SASKiwi — Fri, 28 Aug 2020 21:02:23 GMT

Another way is to get your server administrator to set up folder shares so you can view the folders from your PC.

Re: Getting the path where a .sas file is located.

Reeza — Fri, 28 Aug 2020 21:40:35 GMT

See the first two macros in the macro appendix.

https://communities.sas.com/t5/SAS-Communities-Library/SAS-9-4-Macro-Language-Reference-Has-a-New-Appendix/ta-p/291716

Example 1: Import All CSV Files That Exist within a Directory

Example 2: List All Files within a Directory Including Subdirectories

Re: Getting the path where a .sas file is located.

alepage — Mon, 31 Aug 2020 18:45:53 GMT

Hello,

I have very little experience with Unix. First, how can we check if the xcmd command is enabled.

how do we use it. is it a command line that we execute from putty or is it also possible to execute it from a SAS environment and if so, how do we do that.

Regards,

Re: Getting the path where a .sas file is located.

Kurt_Bremser — Mon, 31 Aug 2020 18:49:28 GMT

First, run this:

proc options option=xcmd;
run;

If XCMD is enabled, run this:

filename findfile "find /path_to_your_programs -name \*.sas 2>&1";

data programs;
infile findfile truncover;
input program $200.;
run;

Re: Getting the path where a .sas file is located.

alepage — Mon, 31 Aug 2020 19:53:50 GMT

Hello,

I have checked if the xcmd is enable. it is the case.

However, IF I am not wrong, you are trying to genate the unix command Find / path - name /*.sas 2>&1

but it not what we get. Any idea how to solve that issue.

Please see the log file

Re: Getting the path where a .sas file is located.

Tom — Mon, 31 Aug 2020 20:07:20 GMT

You need to tell SAS to use the PIPE engine to get it to treat that string as a command and not the name of a file.

filename findfile PIPE "find /dwh_actuariat/sasprocess/prodmens/Cer5/saspgm/ - name  /*.sas 2>&1";

Re: Getting the path where a .sas file is located.

alepage — Mon, 31 Aug 2020 20:52:39 GMT

Hello,

I have added the PIPE and it works better.

However, if I want to go at a previous level, let's say from /dwh_actuariat/sasprocess/prodmens/Cer5/saspgm/

to /dwh_actuariat/sasprocess/prodmens/

it gives me everything, the txt file, sas file and so on. It is like it does not interpret properly the extension.

Also, if I want to look at all the subfolder from /dwh_actuariat/, do I need to add more parameters with the find command.

Regards

Re: Getting the path where a .sas file is located.

Kurt_Bremser — Tue, 01 Sep 2020 04:43:27 GMT

My bad about the missing PIPE keyword. But you have to use the UNIX command as I posted it. No extra blanks, no changing of characters, only insert your path.

filename findfile pipe "/dwh_actuariat/sasprocess/prodmens/Cer5/saspgm -name \*.sas 2>&1";

The backslash has a very special meaning in UNIX and is necessary here, and

-name

is one if the subcommands of find.

Re: Getting the path where a .sas file is located.

alepage — Tue, 01 Sep 2020 13:16:02 GMT

Good morning,

You code is very fast and works but it bring everything. It is like it does not recognize the .sas extension.

I have made some tests with:

filename findfile PIPE "find /dwh_actuariat/sasprocess/prodmens/ - name \*.sas 2>&1";

filename findfile PIPE "find /dwh_actuariat/sasprocess/prodmens/ - name /*.sas 2>&1";

filename findfile PIPE "find /dwh_actuariat/sasprocess/prodmens/ - name *.sas 2>&1";

filename findfile PIPE "find /dwh_actuariat/sasprocess/prodmens/ - name .sas 2>&1";

and it does not make any difference. I am getting around 68000 records instead of 11000 records

Do you have an idea why.

Regards

Re: Getting the path where a .sas file is located.

Kurt_Bremser — Tue, 01 Sep 2020 14:28:43 GMT

PLEASE PAY ATTENTION TO DETAILS!

- name

is different from

-name

!!!

Re: Getting the path where a .sas file is located.

alepage — Tue, 01 Sep 2020 14:51:35 GMT

Hello,

Thank you very much for the precision on the difference between -name and - name for Unix.

The following code works perfectly. Thank you very much

proc options option=xcmd;
run;

filename findfile PIPE "find /dwh_actuariat/sasprocess/prodmens/ -name \*.sas 2>&1";

data programs;
infile findfile truncover;
input path $200.;
run;