Dear SAS Community,   Where can I find a reference for non-high performance nodes in Enterprise Miner?   Here is the high performance node reference: https://support.sas.com/documentation/onlinedoc/miner/emhp123/emhpref.pdf Is there a non-high performance node version of this document?   Thank you!   ... View more

Dear SAS Communities,   I am using PROC GMAP to create animated CHORO maps showing how county statistics change over time. I used PATTERNn to determine the colors and PROC FORMAT to establish the levels. I used a FORMAT statement in PROC GMAP to connect data to region color.   Here is my problem: When a level is absent, the map assigns the next present level the missing level's color. This gives my animation inconsistent colors.   Example: levels: low medium high colors: blue purple red If the data for the animation has levels low, medium, high; then the colors will be blue, purple, red. If the data for the animation has levels low, high; then the colors will be blue, purple (I want blue red).   Thank you, Aaron ... View more

I have 50000 time series with seasonal trends and missing values. I would like to use seasonality to impute the missing values. Please let me know if SAS has a proceedure for this.   The data is output from PROC TIMESERIES (interval = week). The data covers 15 or 16 years (depends on which time series). The seasonal patterns are all one year long (a period of one year, and correspond to spring, summer, autumn and winter). Some of the gaps cover an entire season for a year, but other years have the corresponding season data (summer 2015 is missing; but summer 2014 and summer 2016 are not missing).   Because of the missing seasons, I am unsure if PROC EXPAND's methods will give reasonable results. Would PROC MI's MCMC give solid results? Initially, I used PROC HPSUMMARY to find monthly medians and imputed. Unfortunately, a collaborator objects to the four-week stair patterns.   Thank you! ... View more

I need to find the most frequent level of character variables by group, and the sum of several numeric variables by the same group. If the most frequent level is not unique, I would like the last level with in the group (the data is sorted). Here is an example of what I want to acheive:   Original data: id city color numeric_variable 123 New York blue 4 123 LA blue 3 123 Seattle green 2 456 New York yellow 3 456 LA green 2 456 LA red 3 456 Seattle blue 5 789 Seattle yellow 2 789 New York green 3 789 Seattle yellow 5 789 Seattle yellow 2 789 Seattle green 4   Desired outcome: id city color sum 123 Seattle blue 9 456 LA blue 13 789 Seattle yellow 16   For the sum, using group by id and SUM() within PROC SQL works well.  Is there a MODE function within PROC SQL?   I am using Enterprise Guide version 5.1 (5.100.0.12019) (32-bit).   Thank you! ... View more