Hi, I have multiple sas datsets(~30) present in a directory and need to convert all these into text files. I am using the code below for same: ===================================================== LIBNAME Test "D:\"; %MACRO Convert2CSV(Libname); DATA MEMBERS; SET SASHELP.VMEMBER(WHERE=(LIBNAME = "&Libname")); RETAIN OBS 0; OBS = OBS+1; KEEP MEMNAME OBS; RUN; PROC SQL; SELECT MIN(OBS) INTO :MIN FROM MEMBERS; QUIT; PROC SQL; SELECT MAX(OBS) INTO :MAX FROM MEMBERS; QUIT; %Local D; %DO D = &MIN %TO &MAX; PROC SQL; SELECT COMPRESS(MEMNAME) INTO: Table FROM MEMBERS WHERE OBS=&D; QUIT; PROC EXPORT DATA=&Libname..&Table DBMS=dlm replace OUTFILE="D:\_today\&Table..txt"; delimiter="|"; RUN; %END; %MEND; %Convert2CSV(TEST); ================================================================== Note: I have leveraged this code from (https://communities.sas.com/t5/SAS-Programming/Export-multiple-tables-from-SAS-to-csv/td-p/27090) Issue: The generated text files have spaces in the name. For eg: 'myfile.sas7bat' gets converted to 'myfile .txt' Just a hunch but I think the generated filenames are of fixed length. Therefore to meet the length, SAS is introducing spaces. How do avoid this? Ask: I need help in removing the spaces from the generated file name. I have tried using the Trim function but it doesn't seems to be working. Thanks,
... View more