Get multiple errors with the above code - ERROR: Too many variables defined for the dimension(s) specified for the array names right below: array names {&ncols} varname name:; AND ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=. right below; output; Tried the other code, but I'm just not code-headed enough to understand how to further manipulate it to my CSV files. In that vein, here is a very small portion taken from one of the CSV files: Name SCIENCES NEUROBIOLOGICAL MARTIN MATS. Code 144672(PA) 543325(PA) 98761J(PA) Currency U$ MP C 1/4/1990 #N/A 150 #N/A 1/5/1990 15.26 #N/A #N/A 1/8/1990 15.30 155 1.05 1/9/1990 14.89 152 0.98 There are roughly 1,000 columns and roughly 6,000 date-rows in ascending order (starting at 1/1/1990 through 12/31/2011) making the CSV file roughly 1,000 columns across and 6,000 rows down. To compound the problem, there are 66 CSV files all with data in this form. Ultimately I need to get all the data across all the CSV files put together into one long list, but once I have each of the 66 imported and organized correctly, appending them is simple. What I really need help with is getting the data re-formatted Ultimately, I need to get the data in the following form: Date Code Currency Amount 1/4/1990 144672 U$ . 1/5/1990 144672 U$ 15.26 1/8/1990 144672 U$ 15.30 1/9/1990 144672 U$ 14.89 1/4/1990 543325 MP 150 1/5/1990 543325 MP . 1/8/1990 543325 MP 155 1/9/1990 543325 MP 152 1/4/1990 98761J C . 1/5/1990 98761J C . 1/8/1990 98761J C 1.05 1/9/1990 98761J C 0.98 Note: The (PA) needs to be removed from the Code, and #N/A's need to be replaced with missing - all of this I can do on my own if it simplifies helping me with the code to re-form the data. Thanks again!!
... View more