Hi ,   I am trying to read a JSON file which looks like this: {"ID":12825406,"Score":0,"IP":"MTExOTk5ODE5MA==","CREATED AT":1515519833,"COUNTRY CODE":"US","REGION":"north carolina"}                                                  {"ID":12825464,"Score":10,"IP":"ODU4MDU1OTY=","CREATED AT":1515519960,"COUNTRY CODE":"IL","REGION":"tel aviv"}                                                   {"ID":12825476,"Score":2,"IP":"MzIx,jc4MzgxMA==","CREATED AT":1515519974,"COUNTRY CODE":"BR","REGION":"sao paulo"}                                                   {"ID":12825503,"Score":7,"IP":"MTIz,DE3MjM0OQ==","CREATED AT":1515520026,"COUNTRY CODE":"US","REGION":"massachusetts"}                                                   {"ID":12825548,"Score":7,"IP":"MjE3,Tg3MDEw","CREATED AT":1515520125,"COUNTRY CODE":"US","REGION":"illinois"}                                                  {"ID":12825588,"Score":8,"IP":"MTUw,jYw,jE1,g==","CREATED AT":1515520222,"COUNTRY CODE":"IE","REGION":"tipperary"}                                                   {"ID":12825628,"Score":10,"IP":"MTY1ODgw,Dcy,A==","CREATED AT":1515520309,"COUNTRY CODE":"US","REGION":"illinois"}                                                   {"ID":12825646,"Score":10,"IP":"MzE4,DI0MzA5Mg==","CREATED AT":1515520352,"COUNTRY CODE":"MX","REGION":"puebla"}                                                   {"ID":12825711,"Score":8,"IP":"MTIz,jUz,Tcx,Q==","CREATED AT":1515520495,"COUNTRY CODE":"US","REGION":"oregon"}                                                  {"ID":12825725,"Score":10,"IP":"MzAwOTU1,jg4Mg==","CREATED AT":1515520525,"COUNTRY CODE":"BR","REGION":"sao paulo"}                                                  {"ID":12825742,"Score":7,"IP":"MTY3,zY0,DY3OA==","CREATED AT":1515520552,"COUNTRY CODE":"CA","REGION":"ontario"}                                                   {"ID":12825746,"Score":10,"IP":"MzA5OTMzMDQxMg==","CREATED AT":1515520560,"COUNTRY CODE":"US","REGION":"virginia"}                                                   Tried with scan & infile but not much luck.   Thanks in advance. ... View more

Hi ,   I have monthly data sets which look like this:   dismonth pross Actual JUL15 AUG15 4415822.77 JUL15 SEP16 33578.75 JUL15 NOV15 408408.93 JUL15 JUL15 3347038.23 JUL15 JUN16 59340 JUL15 OCT17 5526.5 JUL15 MAR16 112341.58 JUL15 JUL17 4363 JUL15 SEP15 1611128.75 JUL15 APR17 4426 JUL15 JAN16 140840.5 JUL15 JAN17 11595.75 JUL15 OCT16 21883.75 JUL15 JUL16 61080.5 JUL15 OCT15 696127.06 JUL15 DEC17 2350 JUL15 APR16 89935.1 JUL15 SEP17 2544.5 JUL15 JUN17 4731.5 JUL15 MAR17 15919 JUL15 DEC16 13774 JUL15 DEC15 300524.3 JUL15 AUG16 58034.25 JUL15 MAY16 80908.5 JUL15 NOV17 9548.4 JUL15 AUG17 7095.36 JUL15 FEB16 157373.5 JUL15 MAY17 3204 JUL15 FEB17 8664.25 JUL15 NOV16 15808   I want to forecast for the next 5 years but when I use proc arima few of the forecasts are negative & look incorrect & there are a few warnings :   Warning: There are gaps in the interval for observation 2 according to ID variable PROSS_DATE.   Can some one help out?   Thanks in advance.     ... View more

Hi ,   I have a macro defined as follows saved as a code:   %macro new (dsn1,start_month1,END_month1,months1); proc sql; CREATE TABLE Total AS select _NAME_, &months1. FROM Total; QUIT; %mend new;   I am calling this macro code as : %let dsn=AI_DB_MASTER; %let start_month="01-JUL-2016"d; /*Starting month of 2016 the dashboard*/ %let END_month="31-JUL-2017"d; %let months =Jul16,Aug16,Sep16,Oct16,Nov16,Dec16,Jan17,Feb17,Mar17,Apr17,May17,Jun17,Jul17;   %Include "&path.\new4.sas"/source2; %new(&dsn,&start_month,&END_month,&months);   But when I run the above statement I get the following error:   SYMBOLGEN: Macro variable DSN resolves to AI_DB_MASTER SYMBOLGEN: Macro variable START_MONTH resolves to "01-JUL-2016"d SYMBOLGEN: Macro variable END_MONTH resolves to "31-JUL-2017"d SYMBOLGEN: Macro variable MONTHS resolves to Jul16,Aug16,Sep16,Oct16,Nov16,Dec16,Jan17,Feb17,Mar17,Apr17,May17,Jun17,Jul17 MLOGIC(NEW): Parameter DSN1 has value AI_DB_MASTER MLOGIC(NEW): Parameter START_MONTH1 has value "01-JUL-2016"d MLOGIC(NEW): Parameter END_MONTH1 has value "31-JUL-2017"d MLOGIC(NEW): Parameter MONTHS1 has value Jul16 ERROR: More positional parameters found than defined.   If you notice the months1 macro only takes the first value.   Can any one help? ... View more

Hi,   When I try to connect the gradient boosting node to the apply file in order to score I am getting the following error:   cannot have more than 0 preceding nodes sas miner   I am new to Miner can any one help?     ... View more

Hi,   I have the following sample dataset   ID Purchase Date Age Sales 3621901 04/01/2010 21 990 6271017 04/01/2010 29 642 3914676 02/01/2010 26 955 3888167 04/01/2010 32 834 3888167 04/01/2010 30 616 3888167 04/01/2010 38 657 3289156 04/01/2010 33 322 3621901 30/11/2011 27 855 6271017 31/05/2012 40 381 3914676 11/06/2012 29 915 3888167 11/06/2012 40 972 3015141 28/05/2012 26 755 4518247 28/05/2012 31 415 4518247 13/06/2012 30 652   having 3 years of data for different customers & as seen the customers ids may repeat over 2 different point in time.How is it best possible to run a predictive model given there are different point of time involved with same customer ids?   Would be great if you can advice. ... View more