topic Re: SAS E miner projects list in a phyisical folder in Administration and Deployment

SAS E miner projects list in a phyisical folder

sathya66 — Thu, 30 Jul 2020 13:22:54 GMT

Hi,

is there any way we can get the SAS E miner projects list from a Physical folder.

ex:if we use %mdsecgo, membertypes="MiningProject" then it will give all miner projects in metadata. but I am looking for Physical E miner projects list.

Thanks,

Re: SAS E miner projects list in a phyisical folder

Kurt_Bremser — Thu, 30 Jul 2020 13:32:11 GMT

If your miner projects storage location is on the SAS server, you can use data step functions to retrieve your filenames:

data projectfiles;
length fref $8 pname $200;
did = filename(fref,"path_to_your_project_files");
did = dopen(fref);
if did
then do;
  do i = 1 to dnum(did);
    pname = dread(did,i);
    if scan(pname,-1,'.') = 'emp' then output;
  end;
  did = dclose(did);
end;
did = filename(fref);
run;

Re: SAS E miner projects list in a phyisical folder

sathya66 — Thu, 30 Jul 2020 13:46:58 GMT

Thanks for this,
Table has 0 records.
I think it is not checking the sub folders and also I need path for the "project.emp"

Re: SAS E miner projects list in a phyisical folder

Kurt_Bremser — Thu, 30 Jul 2020 13:59:10 GMT

In order to scan a physical folder, you have to know the complete path to it. That is essential.

Once you know that, @Tom has a very nice method to traverse a whole directory tree in a single data step.