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…
Tag: data cleaning
How to do data cleaning
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…
How many SAS programmer opens by states?
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 …