I have a series of similar infile macros for various CSV file directories. They all follow the same pattern. I create a table of file names that I pass to a macro variable using proc sql. I then run the infile macro to loop through the directory and ingest the data. The macro looks like this:   %macro ingest; data ingest_data; length field1 $50 field2 $50 field3 $50 ; %do i = 1 %to &num_obs; infile "&&file&i" dlm = ',' dsd firstobs=2 missover lrecl=32767 encoding="wlatin1"; input field1 :$ field2 :$ field3 :$ ; %end; run; %mend; The latest program I'm working on is doing something odd and I'm not sure why. I think I know why, but not sure the cause.   When I ingest the data from a new directory, the record count of the first file is being set for all subsequent files, even if those files have more records. So all CSV files are ingested, but its only ingesting, for example, 1700 records per file instead of how ever many records are in the file.   My &num_obs is only calculating total file counts. Is the system obs variable being set somehow? I havent encountered this in any of the previous macros I've put together. Would appreciate any insight. Thanks.       ... View more

Hello,   I'm trying to parse a column called LINE that is delimited by spaces(' '). Example records: somedata1 somedata2 somedata1 somedata2 somedata3 somedata1 somedate1 somedate2 somedate3 somedate4   The number of delimiters is unknown. To handle this I'm taking the max count of spaces:   proc sql noprint; select max(countc(LINE,' ')) + 1 into: nums from testdata; quit;     I would like to create additional columns with a prefix of col_ for the max number of delimiters found in the LINE column. So far I have the following code but it's not quite working.   data test; set mydata; %macro cols; %do i = 1 %to &nums; col_&i = scan(LINE, &nums, ' '); %end; %mend cols; %cols; run; I would expect the Test dataset to contain 4 additional columns called Col_1, Col_2, Col_3, and Col_4; each containing the delimited values from LINE. Put another way: Col_1 will contain the values equal to somedata1 Col_2 will contain the values equal to somedata2 Col_3 will contain the values equal to somedata3 Col_4 will contain the values equal to somedata4   The results are getting close to the requirements but I'm missing something; its not quite right. I havent coded in SAS in a few years beyond simple CRUD stuff and am quite rusty.   Appreciate any help with this, thanks!   ... View more