data have; modify have new; by name; if _iorc_ = %sysrc(_DSENMR) then do; output; _error_=0; end; run; ... View more

Proc Freq! Of course! Thank you. I wish i knew how to use sql. I keep on bumping to it. It is on my list! ... View more

worked thanks for the timely feedback ... View more

In 2004 I wrote a conference paper "Help, I've Received a Spreadsheet File from StarOffice Calc.....!", which described how to extract data from SXC files (the predecessor of ODS files).  This paper may help you read the XML files inside the ODS zip file. ... View more

Use array. data test1; length hcc_code $4.; set test; hcc_code=""; * you will need to list all 18 variables; array dx_cd (18) dx_1_cd dx_2_cd ... dx_18_cd; do i=1 to 18; if hcc_code = "" then do; if indexw(input(dx_cd(i),$testfmt.),'80') ne 0 then HCC_CODE = input(dx_cd(i),$testfmt.); end; end; drop i; run; ... View more