I would like to delete the folder folderToDelete, which contains subfolders and those folders might contain subfolders, and so on. I do not have permission to do the x command. I have the following code (after looking at the following post Delete folder (directory) and all files in it😞 %macro delete_folder(folderToDelete);
data work.FilesToDelete;
length Name $ 100;
keep Name;
rc = filename("folder", "&folderToDelete.");
dirId = dopen("folder");
do i = 1 to dnum(dirID);
Name = dread(dirId, i);
output;
end;
rc = dclose(dirId);
run;
data _null_;
set work.FilesToDelete end=lastDeleted;
put "Deleting " Name;
rc = filename("delfile", cats("&folderToDelete./", Name));
rc = fdelete("delfile");
put "del file " rc=;
rc = filename("delfile");
if lastDeleted then do;
put "Deleting the folder '&folderToDelete.'";
rc = filename("folder", "&folderToDelete.");
rc = fdelete("folder");
put "del folder " rc=;
rc = filename("folder");
end;
run;
%mend; However, since my folder contains subfolders, only the tables are delete and not the subfolders, resulting in the main folder not being deleted. In that sense, what I would like was to apply a function recursively to delete every file inside any subfolder (or any other suggestion you might have). As an example, if my folder has the following structure: > folder > subfolder_1 > T_1_1.sas7bdat > T_1_2.sas7bdat > T_1_3.sas7bdat > subsubfolder_1 > T_1_1_1.sas7bdat > subfolder_2 > T_2_1.sas7bdat > T_1.sas7bdat > T_2.sas7bdat > T_3.sas7bdat > T_4.sas7bdat after running the first data step, which reads the folder, I get Name subfolder_1 subfolder_2 T_1.sas7bdat T_2.sas7bdat T_3.sas7bdat T_4.sas7bdat and then in the second data step, only the tables are deleted. However, I would like to delete the entirety of the folder. Can someone help?
... View more
Due to an unusual specification, I need to make a connection between SAS VIYA4 and MS Power BI. I have found solutions to create this type of connection between SAS 9.4 Unfortunately, on the forum and on the Internet I do not see any valuable materials on this type of connection from the VIYA system. An additional complication is that the connection must be made by downloading data from IN-Memory tables, but if this is impossible I would like to get any connection. In summary, the in-memory tables sas VIYA4 is the source of the data and Power BI analyzes it. I was wondering if it is possible to use SAS OLPA SERVER for this, to integrate the data contained in SAS VIYA with MS Power BI. Moreover, OLAP SERVER is a desktop tool. I do not hide the fact that ideally there would be an alternative tool running in an on premise solution on the browser side. I am aware of the differences between VIYA and SAS 9.4, and how this idea sounds. The question is do you have any ideas on how to get around any associated inconvenience?
... View more
A new update is available for SAS/IML , version 15.3 : Hot Fix: N4R001 - Published 06MAY2024 , Download link for N4R001 Component name: SAS/IML Related SAS release: 9.4 Issues addressed in N4R001 SAS Note 70773 The IML procedure incorrectly stops processing and issues a memory error This list of notes might be incomplete. For a complete list of issues addressed by this hot fix, visit the hot fix page for N4R001 Note: A comprehensive list of all SAS hot fixes is available from support.sas.com. You can use the SAS Hot Fix Analysis, Download, and Deployment (SASHFADD) tool to manage your SAS hot fixes.
... View more
A new update is available for SAS/IML , version 15.2 : Hot Fix: N4Q001 - Published 06MAY2024 , Download link for N4Q001 Component name: SAS/IML Related SAS release: 9.4 Issues addressed in N4Q001 SAS Note 70773 The IML procedure incorrectly stops processing and issues a memory error This list of notes might be incomplete. For a complete list of issues addressed by this hot fix, visit the hot fix page for N4Q001 Note: A comprehensive list of all SAS hot fixes is available from support.sas.com. You can use the SAS Hot Fix Analysis, Download, and Deployment (SASHFADD) tool to manage your SAS hot fixes.
... View more
A new update is available for SAS Workload Orchestrator , version 9.48 : Hot Fix: N3W002 - Published 06MAY2024 , Download link for N3W002 Component name: SAS Workload Orchestrator Related SAS release: 9.4 Issues addressed in N3W002 SAS Note 70741 The Host status in SAS ® Workload Orchestrator might enter an INACTIVE state unexpectedly This list of notes might be incomplete. For a complete list of issues addressed by this hot fix, visit the hot fix page for N3W002 Note: A comprehensive list of all SAS hot fixes is available from support.sas.com. You can use the SAS Hot Fix Analysis, Download, and Deployment (SASHFADD) tool to manage your SAS hot fixes.
... View more