This was indeed what I intended. But I couldn't ask for the whole solution without searching more by myself . And your solution is shorter than what I have so far, Thanks data scannedStrings; infile data3 lrecl=32760 scanover; do cases=1 to 1001 /*until(value='')*/; input @'new Date(' dateString $11. @; input @'},{"v":' valueString $4. @; output; *put '---' cases ' ---' valueString; end; drop cases; stop; run; data GoogleTrends; format date IS8601DA10. ; set scannedStrings; year=scan(dateString,1,','); month=scan(dateString,2,',')+1; day=scan(scan(dateString,3,','),1,')'); date=mdy(month,day,year); value=input(scan(valueString,1,','),best5.); search="&search"; diff=date-lag(date); keep date value search; run; I still havn't found a solution to google's request limit. I could not run your code twice.
... View more