I'm importing some data that includes several columns that uses the YYMMDD8. informat. Most of the data is formatted correctly (eg 20090125), but some fields are just a series of zeros (00000000). I'd like a missing value for the records that have zeros. I can make it work by importing it as a character variable and then using a statement like:      if char_field ^= '00000000' then date_field = input(char_field, YYMMDD8.) This seems clunky and is a bit tedious when there are several columns. Is there a way to use informats to check for a zero value? Or is there a better way to approach this? thanks for your help, Rob ... View more

Hi all, I'm trying to convert some html that has company listings into a data set that has the company name and address. The general format for each company is something like this: <p class="search-1">1.</p> <p class="search-2"><strong>Company Name</strong> <br /> 1 Test St <br /> Suite 1<br /> Test City, CA, 91763<br /> (555) 555-5555</p> The input statement I'm using is: input @'<p class="search-1">' ID 2.          @'<p class="search-2"><strong>' Name $40.          Address1 $40.          Address2 $40.          City $40.          Phone $40.     ; This comes close but has extra html in some fields and provides some erratic results, especially with the name and address fields. I've tried a few different things but I can't quite get it to work. Any input is greatly appreciated. thanks in advance, Rob ... View more