Sorting Pitfalls

SAS Proc sort is probably one of the easiest procs to use. And sorting in other programs/software is generally pretty straightforward. However, there are a few things I always remind myself when sorting.When you use proc sort you don’t know who is do…

How to generate ICD9 table

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…

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…

Cloud App

Oh man it has been a long time since I have updated this blog. So what’s new?I have a new son! The band I am playing in recently played a gig at the Whisky A Go Go in Hollywood. We’re playing at The Cat Club in Hollywood this Thur come one come all,…

How to generate HCPCS 2009 long description

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…