[R] Help with R loop for URL download from FRED to create US time series

2013-06-10 Thread arum
I am downloading time series data from FRED. I have a working download, but I do not want to write out the download for all 50 states likes this: IDRGSP <- read.table('http://research.stlouisfed.org/fred2/data/IDRGSP.txt', skip=11, header=TRUE) IDRGSP$DATE <- as.Date(IDRGSP$DATE, '%Y-%m-%d') IDRGS

[R] Data Cleaning -New user coming from SAS

2012-11-29 Thread arum
Hello, this is my first post. I have a large CSV file where I need to fill in the 1st and 2nd column with a Loan # and Account name that would be found in a line of text : like this: ,,Loan #:,ML-113-07,Account Name:, Quilting Boutique,,, I would like to place the Loan #: ML-113-07 in the f