The raw data: hereFILENAME data URL “http://research.stlouisfed.org/fred2/data/UNRATE.txt” DEBUG LRECL=100;data one;infile data;input @1 year 4. @6 month 2. @9 day 2. uer;DATE = MDY(MONTH,DAY,YEAR);FORMAT DATE monyy7.;drop year month day;if date=. th…
Tag: filename
The top12 pharms
1. Data import: input/format/label/keep+array2. GTL can definitely be reused;data top12; input rank company & $20. country & $15. revenue comma12.2 netincome comma12.2 employee; personearn=(netincome/employee)*1000000; format revenue dolla…
Online data collecting @indeed
FILENAME test URL “http://www.indeed.com/jobs?q=sas+programmer&limit=100&fromage=0&start=0” DEBUG LRECL=700;DATA test; infile test length=len; input record $varying700. len; *****DELETE MOST LINES W/O JOB;if index(record, ‘cmpid’)=0 th…