Posts Tagged ‘ data cleaning ’

Breaking Bad (data) with SAS!

March 5, 2014
By

In the Breaking Bad TV series, Walter White has an impressive lab where he secretly makes the illegal drug methamphetamine (meth). Wouldn't it be cool to use SAS to show the locations of all the clandestine meth labs in the US?!? Let's do it!... In thi...
Read more »

Tags: , , , , ,
Posted in SAS | Comments Off

5D visualiztion: from SAS to Google Motion Chart

December 12, 2010
By



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 »

Tags: , ,
Posted in SAS | Comments Off

How to predict unemployment rate in US by SAS/ETS

June 27, 2010
By
How to predict unemployment rate in US by SAS/ETS

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 »

Tags: , ,
Posted in SAS | Comments Off

How to generate ICD9 table

May 19, 2010
By

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 »

Tags: , ,
Posted in SAS | Comments Off

The top12 pharms

May 19, 2010
By
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...
Read more »

Tags: , ,
Posted in SAS | Comments Off

How to generate HCPCS 2009 long description

May 18, 2010
By

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 »

Tags: , ,
Posted in SAS | Comments Off

How to do data cleaning

April 26, 2010
By

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 »

Tags: ,
Posted in SAS | Comments Off

How many SAS programmer opens by states?

March 15, 2010
By
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 ...
Read more »

Tags: , ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.