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 transpose data=two out=four;
by code;
var description;
run;
data five (keep=description code);
set four;
sp=' ';
description=trim(left(col1)) || sp || trim(left(col2)) || sp || trim(left(col3))|| sp || trim(left(col4))|| sp || trim(left(col5)) ;
run;
Tuesday, May 18, 2010
How to generate HCPCS 2009 long description
Labels:
data cleaning
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment