I am reading in a CSV file with several hundred comma separated items on each text line. I need to get all of the individual values for each text line into an array to work with. At the moment I am using the SCAN function to step through the text line and extract each item however with up to 300 items per line and more than 30,000 lines to scan I am finding that this is taking much longer to run than I would like.
Is there any SAS function which I am overlooking that could be used to perform this without having to loop through the text records for each item. For example in some of the EXCEL VBA work that I have done I have used the SPLIT function which separates each of the items in a text line into individual array items.
I have worked with arrays quite extensively over the past 15 years, although it is always good so see some alternative was of doing things. It was really the splitting of items into an array with the least possible amount of CPU processing that I was after.
While I agree this was not an ODS or Base Reporting Procedure question, I also don't see a forum for general SAS questions that really relate to SAS Base.