the only reason I added the dataset was because I received an error saying:Syntax error, expecting one of the following: ;, DATA, DBLABEL, DBMS, DEBUG, FILE, LABEL, OUTFILE, OUTTABLE, REPLACE, TABLE, _DEBUG_. What I am trying to achieve is the following, it is a bot complex: Have a main text file which contains a list of all 5 text files in a directory, lets call it main.txt. Thereafter text files need to be created using SAS with naming convention Program1_todaysdatetime.I am allowed to create up to 5 of these files thus up to Program5_todaysdatetime and everytime this file gets created, it needs to be recorded in main.txt. What needs to happen is I need to count number of records in main.txt. If this count is less than 5 then we must create a new text file and populate the name of this new text file into the main text file. This loop needs to continue. So far I got to the point where is counts the number of records in main.txt and now I am trying to automate the rest. /*Count records*/ data files; length fname $256 lines 8 cmd $300; infile "ls &path.&pattern" pipe truncover ; input fname $100.; cmd = catx(' ','wc -l',fname); infile cmd pipe filevar=cmd truncover; input lines @; run; proc sql; select lines into :linecount from files; quit;
... View more