OK I know how to export a table to csv and I have found BAT way to split the csv into 5000 rows, but it does not keep the header for each file. Just the first file. SO I am looking for a do loop that will export proc export DATA=clean_table OUTFILE="C:\Table_2019_04_02.csv" DBMS=DLM REPLACE; DELIMITER=','; run; Depending on the day, the source file could contain between 3000 and 200000 rows of data. I would love to get the files to be exported like clean_table 14654 rows Table_2019_04_02-01.csv (5000 rows) Table_2019_04_02-02.csv (5000 rows) Table_2019_04_02-03.csv (4654 rows) Any help would be appreciated! Thanks!
... View more