This question is building off of a solution from ballardw(Super User) regarding building a proc informat approach to labeling employment titles.   I have many, many lines of type_firm descriptions a sampling will look something like in Excel   Agricultural_worker                         = 2003 Apparel_Manufacturing                   = 2004 Beverage_Manufacturing                = 2002 Cabinets_Woodworking                   = 2005 Construction_Homes_Residential    = 3002 (the codes are what I am using to delineate the different firm types) and so on I guess I have two questions   1) can I just copy and paste these rows into my data step - actually the Proc format (and I have ~ 940 rows and Services will have well over 1500)   and 2   Once step number 1 is successful the should look like   Proc format invalue Firm_type (upcase) Agricultural_worker                         = 2003 Apparel_Manufacturing                   = 2004 Beverage_Manufacturing                = 2002 Cabinets_Woodworking                   = 2005 Construction_Homes_Residential    = 3002   and so on   how would I code so that " " can be added to the start and end of the type firm to look like   "Agricultural_worker"                         = 2003 "Apparel_Manufacturing"                   = 2004 "Beverage_Manufacturing"                = 2002 "Cabinets_Woodworking"                  = 2005 "Construction_Homes_Residential"    = 3002   Another thing just occurred to me the codes on the excel spread sheet look like '= then the no so the ' before the = needs to be removed too.   This is a long convoluted question, but I appreciate your help and assistance.   wlierman ... View more

I have been working on a contact tracing data set to provide any info that would be helpful to Public Health now that SARS-Cov-2 is becoming more endemic. I have classified about 29000 obs using the NAICS Industrial Classification used by the Bureau of Labor Statistics.  It is easy to separate on the basis of either a Good or a Service business.  There is a field called Type_Firm which is a bit more descriptive of the survey and the resultsand I have included just a small number of Type_Firm descriptions in the data window.  This is just for Goods Construction (and not all of it) - Services is even more varied. CONSTRUCTION_AGRICULTURE_MINING CONSTRUCTION_BUILDINGS CONSTRUCTION_BUILDINGS CONSTRUCTION_BUILDINGS_CNTRACTOR CONSTRUCTION_BUILDINGS_COMMERCIAL CONSTRUCTION_BUILDINGS_COMMERCIAL_INDUSTRIAL CONSTRUCTION_BUILDINGS_CONTRACTOR CONSTRUCTION_BUILDINGS_CUSTOM_HOMES CONSTRUCTION_BUILDINGS_GENERAL_CONTRACTOR CONSTRUCTION_BUILDINGS_GENERAL_CONTRACTORS CONSTRUCTION_BUILDINGS_HEAVY_CONSTRUCTION CONSTRUCTION_BUILDINGS_HOMES CONSTRUCTION_BUILDINGS_HOME_BUILDERS CONSTRUCTION_BUILDINGS_MANUFACTURED_HOMES CONSTRUCTION_BUILDINGS_METAL_BUILDINGS_CONTRACTORS CONSTRUCTION_BUILDINGS_MOBILE_HOMES CONSTRUCTION_BUILDINGS_MODULAR_HOMES CONSTRUCTION_BUILDINGS_NEW_HOMES_REMODELING CONSTRUCTION_BUILDINGS_NEW_HOME_AND_REMODELING CONSTRUCTION_BUILDINGS_PREFABRICATED_HOMES CONSTRUCTION_BUILDINGS_PREFAB_HOMES CONSTRUCTION_BUILDINGS_PUBLIC_PRIVATE_CLIENTS CONSTRUCTION_BUILDINGS_REMODELING CONSTRUCTION_BUILDINGS_REMODELING_CONTRACTORS CONSTRUCTION_BUILDINGS_REMODELING_NEW_CONSTRUCTION CONSTRUCTION_BUILDINGS_REMODELS CONSTRUCTION_BUILDINGS_REMODELS_RENOVATIONS CONSTRUCTION_BUILDINGS_RESIDENTIAL CONSTRUCTION_BUILDINGS_RESIDENTIAL_COMMERCIAL CONSTRUCTION_BUILDINGS_RESIDENTIAL_COMMERCIAL_REMODELING CONSTRUCTION_BUILDINGS_RESIDENTIAL_HOMES CONSTRUCTION_BUILDINGS_RESIDENTIAL_MULTI_FAMILY CONSTRUCTION_BUILDINGS_RESIDENTIAL_NEW_REMODELS CONSTRUCTION_BUILDINGS_RESIDENTIAL_REMODELING CONSTRUCTION_BUILDINGS_RESTORATION_SERVICES_WATER_DAMAGE CONSTRUCTION_BUILDINGS_ROOFING_CONTRACTORS CONSTRUCTION_BUILDINGS_SOCIAL_ASSISTANCE CONSTRUCTION_BUILDINGS_STEEL_STRUCTURAL_CONCRETE CONSTRUCTION_BUILDING_COMMERCIAL_GENERAL_CONTRACTORS CONSTRUCTION_BUILDING_CUSTOM_HOMES CONSTRUCTION_BUILDING_MASONRY CONSTRUCTION_BUILDING_RESIDENTIAL_HOMES CONSTRUCTION_BUILKDINGS_RESIDENTIAL CONSTRUCTION_BUUILDINGS_MANUAFCTURED_HOMES CONSTRUCTION_CLEANING_SERVICES CONSTRUCTION_CONTRACTOR CONSTRUCTION_CONTRACTORS CONSTRUCTION_EXCAVATION CONSTRUCTION_GENERAL_CONTRACTOR CONSTRUCTION_LANDSCAPING CONSTRUCTION_MATERIALS_SERVICES CONSTRUCTION_MOBILE_HOMES CONSTRUCTION_NONRESIDENTIAL_BUILDINGS CONSTRUCTION_OF_BUILDINGS CONSTRUCTION_OTHER CONSTRUCTION_REMODELING CONSTRUCTION_REMODEL_SERVICES CONSTRUCTION_REPAIR_RETROFITTING_TUGS_BARGES What approach would you apply so that these titles could be put into only 3 maybe 4 containers.  Just hypothetically, may Construction_Heavy_Construction; Construction_Residential; Construction_Remodeling; Construction_Other?  Maybe a few more containers might be better - and Services would definitely require more than 4 or 5.  And there are typos in some of these descriptions I've noticed.   Your suggestions to hopefully making this categorization step less onerous than it looks will be very appreciated.   Thanks.   wlierman       ... View more

I am looking for the best way to pipe tables (like from proc freq) in the Results screen into some other more usable format for additional analysis. Forms like an output SAS data set for further manipulation or an Excel worksheet.   I've looked at SAS Documentation on the SAS website but it is a bit obfuscated (at least for me).   Thank you.   wlierman ... View more