I have addresses that I need to separate as street address. The last two words in the address field is usually the region and city. Any ideas? Before Hillcrest Avenue Hillcrest Auckland After Hillcrest Avenue ... View more

I am trying to create  an expense report where I am categorizing transactions based on certain keywords (e.g. if a transaction line contains STARBUCKS, categorize it as EATING-OUT). I am using the following but notice that the command does not always work (as in does not assign transactions to categories all the time. Is there a better way to do this other than the following?   if prxmatch ("m/BAKE & BEANS|Smart Sushi |Columbus Coffee|Coffee Club|Mozaic|Menulog|Kyoto|Baxters| NZ Natural|Rio|yoway|yoghurt||Dogmatic|Donut|Thanya|Nol|Bean/i",details) > 0 then Category = "Eat-Out"; ... View more

I am trying to plot a chart with multiple scenarios. The code currently used to display it is as follows:   title 'Unemployment Rate Scenario'; proc sgplot data=ifrs_econ_scnr; series x=ReportingDate y=Raw_UMP/group = Iteration; format ReportingDate yyqc4.; yaxis label= 'Unemployment Rate'; refline '30Jun2017'd / axis = x; run;   The chart is grouped by 'Iteration' and I wanted to know if I could highlight 1 particular iteration (e.g. 1) in the plot and make it a bit more prominent (e.g. change weight of the line). Any ideas? ... View more

i am trying to simulate multiple scenarios from a VAR model using proc varmax. The idea is that proc varmax provides a forecast series and then multiple scenarios are generated around that series. I am currently running the following model:     ods graphics on; proc varmax data=in(firstobs = 2) covout Outest = estin Outstat = s plot = (residual model forecast); id ReportingDate interval=quarter align = end ; model cpi ump gdp hpi / nseason = 4 /* cointtest=(johansen)*/ Dif = (cpi(1) ump(1) gdp(1) hpi(1)) p=4 dftest print=(estimates diagnose); output out=in_fct lead=12; run; This gives me a 12 period forecast.   I wanted to know if it is possible using Proc Varmax to generate multiple paths? My understanding is that you can create paths by generating a normally distributed residual distribution and then adding it back to the model estimates. But I am unclear as to how that works out in the procedure or how we can do this in SAS altogether.   ... View more