I have a very simple program that reads in the contents of all the .csv files in a Windows directory. That part of the program works fine. I would like to add the file name to each record. The problem I have is the variable fullfilename contains only 'C:\Users' rather than the full name. I have verified this with PUT statements. In the log, SAS correctly identifies the full path and name and the proper data is imported but the ticker field (to wihich I tried to assign the parsed filename) is blank, as is the fullfilename field. Thanks for your help! Using Windows 10 and SAS 9.4 in Enterprise Guide data ticker_files; infile 'c:\Users\tparrent\Documents\SandP 500 Stock History\daily\table_*.csv' FILENAME=fullfilename DELIMITER=',' FIRSTOBS=1; put fullfilename; do until(last); input dateint unknown open high low close volume; ticker = scan(scan(fullfilename,-1,'_'),1,'.'); output; end;
... View more