Posts Tagged ‘ data cleaning ’

Three dimensions are usually regarded as the maximum for data presentation. With the opening of ODS from SAS 9.2 and its graph template language, 3D graphing is no longer a perplexing problem for SAS programmers. However, nowadays magnificent amount of data with multi-dimension structure needs more vivid and simpler way to be...
Read more »

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...
Read more »

data icd; infile 'http://within.dhfs.state.wi.us/helpfiles/dlookupbrowse.html' truncover; input star code $5. description $100.; if anyalpha(substr(code, 5, 1))=1 then addon=substr(code, 5, 1);run;data icd1; set icd nobs=nobs; code=compress(code, addo...
Read more »

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...
Read more »

data two; infile 'https://www.cms.gov/HCPCSReleaseCodeSets/Downloads/INDEX2009.pdf' truncover; input @1 code $5. @7 description $200.; if code='Page ' then delete; if code=' ' then delete;run;proc sort data=two; by code;run;proc tr...
Read more »

1) How to use SAS to merge base and look-up tables ? pro and con?1. array 2. sort-sort-merge;3. proc sql; 4. proc format; 5. hash objectCoding efficiency: 3>2>4>1>5I/O resource: 5>4>1>3>2flexibility: 3>>others2) What are the common methods for large...
Read more »

1. Data by state is obtained manually from indeed.com (14 days range @15Mar2010);2. Conclusion: SAS programmer opens most occur on the east and west coastdata sites;length stcode $ 2;input stcode $ region sites;state=stfips(stcode);datalines;AR 6 ...
Read more »