cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
gtchambers3
‎09-22-2020
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Assistance needed to input a static observation if it does not exi...

by Calcite | Level 5 in New SAS User
‎07-23-2019 11:22 AM
‎07-23-2019 11:22 AM
Thank you for your reply!   A few quick questions -   in this example, if I create a dummy or skeleton list (which I have a pre-determined list that I can identify and use), when I merge, will I create two observations for cities where the business name exists - e.g., two Olaf's or Mercury in Miami in the new data set?   ... View more

Assistance needed to input a static observation if it does not exist a...

by Calcite | Level 5 in New SAS User
‎07-23-2019 10:40 AM
‎07-23-2019 10:40 AM
Hello -   I am trying to condition and manipulate some data that is focused on locality and then company name.  An example is below.   In the example below, the business "Olaf's Boat Cleaning Supplies" is not observed for Tampa.  I want to have SAS auto-create an observation for this company when this instance occurs.  I need this company to appear in each City.  I'm tapping my soon to be wrinkling forehead trying to figure this out.  Your help is appreciated!       country - state - county - city - business_name - var5 - var6 - var7 (and so on) USA - Florida - Miami_Dade - Miami - Olaf s Boat Cleaning Supplies - - USA - Florida - Miami_Dade - Miami - Mercury Boat Repair and Maintenance - - USA - Florida - Citrus - Orlando - Olaf's Boat Cleaning Supplies - - USA - Florida - Citrus - Orlando - Mercury Boat Repair and Maintenance - - USA - Florida - Hillsborough - Tampa - Mercury Boat Repair and Maintenance - - USA - Florida - Pinellas - Clearwater - Olaf's Boat Cleaning Supplies USA - Florida - Pinellas - Clearwater - Mercury Boat Repair and Maintenance     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-22-2020 02:56 PM
Quick links