Tag: Data Integration

Labeling variables by a macro in SAS

To rename the variables of a dataset in SAS is a daily routine. SAS or the programmer s would give an arbitrary name for any variable at the initial stage of data integration. Those names have to be modified afterward. Weisui [Ref.1] developed a macro …

SAS and Revolution R for GB size data

R surpassed Matlab and SAS on recent Tiobe Programming index for popularity. I agree with this ranking[1], since R could largely replace Matlab and SAS for MB size data, and it is getting hot. The fast growing sectors, finance, biology, bioinformatics …

SAS vs R in data mining (1): challenges for SAS

The past three years witnessed the rise of R, an open source statistical software. Search R related books in Amazon, and tons of recent titles show up ranging from graphics to scientific computation. Thanks to those graduates sprang out of school that …

New DI Admin Course from SAS

Back in September I wrote about seeing some New Targeted Admin Courses from SAS. Today I saw that the list of admin courses has been further extended to add a new SAS Data Integration Studio: Administration course. There’s more information about this new training course, including the course outline, on the SAS web site at […]

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…

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…

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 …