I have a file Nflag which looks like this. Flag 0 1 0 1 1 I also have a group of folders named: Test1.nm7 Test2.nm7 Test3.nm7 Test4.nm7 Test5.nm7 What I would like to do is to have the folder names reflect the flag values so that those with a 0 (e.g.,0Test1.nm7)  designation can be later deleted.  What I would have initially would be: 0Test1.nm7 1Test2.nm7 0Test3.nm7 1Test4.nm7 1Test5.nm7   The final  folders would be: 1Test2.nm7 1Test4.nm7 1Test5.nm7   Can someone tell me how best to do this? ... View more

options nosymbolgen nomtrace nonotes nosource noMPRINT; %macro datm4; %do i=1 %to 10; data result&I ; /*inialization of flag to 0 which will be used to find line of interest*/ retain flag_section1 0 ; infile "FOLDERS/myfolders/FINALSAS/DATA/TEST&i..nm7/TEST&i..lst" END=EOF; if index(_infile_ , 'NO. OF SIG. DIGITS IN FINAL EST.:') and scan(_infile_, -1,'') = '2.9' then flag_section1 =1; input @; if _infile_ =: 'NO. OF SIG. DIGITS IN FINAL EST.: 2.9' then flag_section1 =1; if eof then output; run; %END; TITLE ' DISTRIBUTION D DATA'; data FLAG; set %do i=1 %to 10;RESULT&i %end ;; run; %mend datm4; %datm4; PROC EXPORT DATA=flag OUTFILE= '/folders/myfolders/FINALSAS/Flag.XLSX ' DBMS=XLSX REPLACE; RUN; The program above runs ok on my laptop.  Before I ran the code on the workstation I checked the properties and the location was given as:/folders/myfolders/myfolders/finalsas/…..   I got the following error message which is listed for 7 but applies to all N=10 folders: ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/FOLDERS/Myfolders/myfolders/FINALSAS/DATA/TEST7.nm7/TEST7.lst. WARNING: The data set WORK.RESULT7 may be incomplete. When this step was stopped there were 0 observations and 1 variables. WARNING: Data set WORK.RESULT7 was not replaced because this step was stopped. ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/FOLDERS/Myfolders/myfolders/FINALSAS/DATA/TEST8.nm7/TEST8.lst.   Can anyone tell me why using the path from the pull down properties tab in SAS UE, although it has an extra myfolders, does not work?   ... View more

I have a data set named param.tbl which contains data that looks like this: ID          TIME        CMT         AGE         ETA1                          1.0000E+00 0.0000E+00 1.0000E+00 1.2000E+01 7.4460E-01 1.0000E+00 0.0000E+00 2.0000E+00 1.2000E+01 7.4460E-01 1.0000E+00 0.0000E+00 3.0000E+00 1.2000E+01 7.4460E-01  The actual data set has about 500 rows and I have presented a 3 row sample.   When I use the code below, I get the log below, and the data is not read in. Can someone tell me how to correct the code so that the data will be read into SAS?   LOG NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 2 TITLE; 3 FOOTNOTE; 4 OPTIONS LOCALE=en_US DFLANG=LOCALE; 5 DATA _NULL_; 6 RUN; 7 OPTIONS VALIDVARNAME=V7; 8 OPTIONS VALIDMEMNAME=EXTEND; 9 FILENAME _HTMLOUT TEMP; 10 FILENAME _RTFOUT TEMP ENCODING='UTF-8'; 11 FILENAME _PDFOUT TEMP; 12 FILENAME _GSFNAME TEMP; 13 FILENAME _DATAOUT TEMP; 14 %LET SYSCC=0; 15 %LET _CLIENTAPP='SAS Studio'; 16 %LET _CLIENTAPPABREV=Studio; 17 %LET _CLIENTAPPVERSION=3.8; 18 %LET _CLIENTVERSION=3.8; 19 %LET _CLIENTMODE=basic; 20 %LET _SASSERVERNAME=%BQUOTE(localhost); 21 %LET _SASHOSTNAME=%BQUOTE(localhost); 22 %LET _SASPROGRAMFILEHOST=%BQUOTE(localhost); 23 %LET _CLIENTUSERID=%BQUOTE(sasdemo); 24 %LET _CLIENTUSERNAME=%BQUOTE(sasdemo); 25 %LET CLIENTMACHINE=%BQUOTE(192.168.61.1); 26 %LET _CLIENTMACHINE=%BQUOTE(192.168.61.1); 27 %let SASWORKLOCATION="%sysfunc(getoption(work))/"; 28 FILENAME _CWD '.'; 29 DATA _NULL_; 30 CALL SYMPUT('_SASWORKINGDIR',PATHNAME('_CWD')); 31 RUN; 32 FILENAME _CWD; 33 34 %LET _SASPROGRAMFILE = %NRQUOTE(%NRSTR(/folders/myfolders/BOOTSTRAPAPTENSIO_PED/ReadFitFile.sas)); 35 %LET _BASEURL = %BQUOTE(http://192.168.61.128/SASStudio/); 36 %LET _EXECENV=SASStudio;   ______________________________________________________________________________________________________________________ 49     NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended.   37 DATA _NULL_; 38 CALL 38 ! SYMPUT("GRAPHINIT" _ 49 38 ! ,""); 39 CALL 39 ! SYMPUT("GRAPHTERM" _ 49     I have attached code written to read the data set. %do i=1% to 5; data NEW_SUBJ&i; infile "/folders/myfolders/test&i..nm7/PARAM.TBL" FIRSTOBS=2; input ID TIME CMT AGE ; RUN; DATA NEW_SUBK&i; SET NEW_SUBJ&i; IF ID=. THEN DELETE; RUN; %END; ... View more