Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SIC Codes (Industry Classification) (all)

    I would like to implement a "correct" set, or subset, of the SIC codes.

    A web search reveals a variety of sites and sets of data, amongst them <A target="_blank" HREF=http://www.census.gov/epcd/www/naics.html>http://www.census.gov/epcd/www/naics.html</A> and
    <A target="_blank" HREF=http://www.wave.net/upg/immigration/sic_index.html>http://www.wave.net/upg/immigration/sic_index.html</A> and <A target="_blank" HREF=http://fisher.osu.edu/~tomassini_1/sicAZ/sic_code.html>http://fisher.osu.edu/~tomassini_1/sicAZ/sic_code.html</A> "This page is a compilation of useful links to the standard industry codes in a variety of formats. It includes access to the 1987 Standard Industrial Codes (SIC) and the 1997 North American Industry Classification System (NAICS). I will do my best to keep this page updated. If you have any problems with the links or have any suggestions for additions to the page, please drop me a quick note here. Enjoy!"

    I'd like to know what Woody's Lounge ACCESS users are using, if at all, and why.

    Nothing complex for me. As an exercise in writing Access/VBA I am going to trawl through my existing 2500 entry name-and-address file and attempt to assign a meaningful code to each entry. I'd just as soon be using a recognised standard.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SIC Codes (Industry Classification) (all)

    Here's some crude and sloppy code to achieve a hazard at each SIC code.

    I used an SIC table with 8 columns. In the Access table ("SICaz") column 0 was the primary key, column 1 was the SIC code, and columns 2-7 were keywords (the longest SIC description was six words long).

    I dumped my old DOS PCF flat-file into an access table "Clients".

    The process loops through the client table, obtaining a single catenated string for each record.

    The record string is passed against each row of the SIC table to count how many of those 6 words appear in the record string. The SIC row with the highest score is assumed to be the SIC.

    The matching algorithm is crude, and could be greatly refined.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •