I've got a data set that looks something like this:     data pair_data; infile datalines missover; input var_id $ parent_var_id $; datalines; 1 2 1 3 2 4 20 20 21 4 15 3 ; run;   Ideally, I want to end up with a data set that combines all nested combinations, including the original ID (which has a blank parent_var value). So, it should look something like this:   data combined_pair_data; infile datalines missover; input combo_id $ var_id $ parent_var_id $; datalines; 1 1 1 1 2 1 1 3 2 2 4 20 2 20 20 2 21 4 1 15 3 ; run; Notice that any original ID has its own ID filled in as the parent, but all linked combinations are given a sequential combo_id to differentiate chains of pairs.   I've used do loops up to this point, but that seems inefficient. I imagine there's gotta be a simple way to do this, but I can't put my finger on it. Any help would be greatly appreciated!     Looked elsewhere in the forums and didn't see anything like this. ... View more

Playing around with proc template, I accidentally overwrote a couple of the base SAS styles (HTMLBlue and BarrettsBlue), basically applying the parent style printer to both, which replaced everything in them.   Aside from a re-installation of the program, is there some easy way to restore the set of factory-issued SAS ODS styles?   Feel like a dunce for having done this, but I'm hoping there's an easy fix that's just lost on me.   Thanks in advance! Ian ... View more

Is it possible to make a map like the one below in SAS? I can't find any examples of such a map online nor any SUGI proceedings on it.     Looks like it'd be a contour plot by coordinates overlaid on a projected map. But how do you go about doing that? Is it possible?   Any help would be greatly appreciated. ... View more

I'm trying to pull data from an ODBC connection (SQL Server), and whenever I pull a date variable, it's coming into SAS as character rather than as numeric. Here's the code I'm using: PROC SQL; CONNECT TO ODBC(DSN='SQL Server'); CREATE TABLE demogs AS SELECT * FROM CONNECTION TO ODBC ( SELECT customer_id, convert(date,birthdate) as birthdate ); QUIT; The birthdate field comes into SAS as a character variable (e.g., "1986-10-08"). How can I get the imported character date value to be numeric? The reason the "convert" statement is used in the SQL code is that the original date value is in DATETIME, but there is NO time on any of the date values. Thus, I'd prefer to just pull in the month, day, and year and drop the time element (which is always 00:00:00:000) altogether. I'm sure this is probably a common enough problem, but after searching through the forums (and elsewhere online), I wasn't able to find an issue that touched on this specific ODBC connection problem. Any help would be greatly appreciated. Thanks! ... View more