I have below sample data and need output as mentioned. Can you please suggest.    Input XYZ,DATA,G:\Data\XYZ\DATA\Test1.txt,1234,01/01/2025 14:17:14 XYZ,DATA,G:\Data\XYZ\DATA\Test2.txt---bkp,sfsfsf---,12345,01/01/2025 14:17:14 XYZ,DATA,G:\Data\XYZ\DATA\Test3.txt@#ttabd--.txt,123456,01/01/2025 14:17:14 XYZ,DATA,G:\Data\XYZ\DATA\Test4.txt,1234777,01/01/2025 14:17:14 XYZ,DATA,G:\Data\XYZ\DATA\Test5.txt,123479878,01/01/2025 14:17:14   Output XYZ,DATA,1234 XYZ,DATA,12345 XYZ,DATA,123456 XYZ,DATA,1234777 XYZ,DATA,123479878 Note : 3rd column is path and file name but file name is having different extra character like , @-- etc, so I am getting blank and output is coming correctly.  ... View more

Hi folks, I am losing my mind over something that I thought should be really straightforward. I've searched online for about 3 hours now and can't find any answers. I'm trying to create a macro function that uses some variable value from a prompt to run a set of other programs sequentially. I have tried a dozen or so variations, but the heart of my code comes down to this:   %macro choose_progs(which_progs);      %if &which_progs = set1           %then %do;                %include "mypath\folder1\program1.sas";                %include "mypath\folder1\program2.sas";           %end;        %else      %if &which_progs = set2 or              &which_progs = set3           %then %do;                %include "mypath\folder2\program1.sas";          /* The program names are the same for both sets but the filepath is slightly different */                %include "mypath\folder2\program2.sas";           %end; %mend choose_progs;   %choose_progs(set1);   If I run this, the first file in set1 runs fine but then ends with a final log entry "NOTE: Extraneous text on %END statement ignored." and the second file never even starts. If I have the audacity to try and run again to test a change, I just get the following: "NOTE: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks." There are definitely no unbalanced quotes, but my file paths are fairly long. All four of these programs will run fine on their own, I just for the life of me can't figure out how to automate this. I've also tried to use %include filePath("folder1\program1.sas", folder1\program2.sas"), but that doesn't work either. It still just runs the first program and stops.   Do any of you know what I'm doing wrong here? ... View more

SAS is installed on a new server and I am facing some issues. I have some other questions about keyboard shortcut for SAS on SAS server but I will ask about them soon.    Currently, the issue is that when I double click a SAS programme file, it opens in SAS Universal Viewer instead of opening in SAS 9.4. I need to right click the file, then need to click 'show more options', then need to click 'open with SAS 9.4' and then file opens in SAS for each file each time.    I have tried to change the default programme by going in properties but I am not able to find out how to locate the SAS file (SAS programme) on the server so that the default option can be changed.    Thanks in advance.   Thanking you, Yours sincerely,   - Dr. Abhijeet Safai ... View more

How can I save the output data from a SAS code step so that it can be used as input in the next node  I can save it to a table, but what I want is to continue using the new dataset as a input in the next node for machine learning. ... View more