I need to group similar observations in a merge step.  This is what I mean: HAVE_1 Price     City     Name     12.55  Toronto    25KN 12.55  Toronto    56HW 12.55  Toronto    93KT 14.83  Calgary    32BD 12.63  Ottawa     23OP 18,94  Montreal   34RP HAVE_2 Price     City     Name 12.55  Toronto    66LG 14.83  Calgary    26TR 12,63  Ottawa     38KG I merge by City only. And get this: 12.55 Toronto 12.55 Toronto 12.55 Toronto 14.83  Calgary    12.63  Ottawa     18,94  Montreal   and want this WANT 12.55 Toronto 14.83  Calgary    12.63  Ottawa     18,94  Montreal  ... View more

Does anyone know how sas can read (and allow) the accent that is typically used in French names.  eg. Montreal the e has an accent on top of the letter.  Right now SAS converts it to a ? so Monreal comes up as Montr?al .. Thanks ... View more

Hi, I'm trying to delete data that's within a bracket but keep the rest.  Have: NAME Sammy (NL) Don (DP) Greg (OL) Fred Donalson (DE) St. George B (BW) Want: NAME Sammy Don Greg Fred Donaldson St. George B I tried this : do i=1 to count (NAME,'('); NAME2 = scan(NAME,i); output; end; ... View more

I'm trying to use trnspose, but may be the wrong procedure.  I'm trying to bring the top variables all into a column. Have: Area  Va1  Va2   Va3 ... Va54 NY     3.4    5.3    6.7       2.5 LA     2.3     5.4   5.3        3.7 Want: Area    Var    Price NY      Va1     3.4 NY      Va2     5.3 NY      Va3     6.7 ... NY      Va54   2.5 LA       Va1    2.3 LA       Va2    5.4 LA       Va3    5.3 ... LA       Va54  3.7 thanks ... View more

Hi, is there a way to cluster within subgroups ?  I have variables (A1J , A1H, A1T, A1L) and (B1Y, B1R, B1S), and (G38, G2U, G5T, G8X).. is there a way to cluster witihn A1's and B1's and G3's, etc ??remember each one is a separate variable.  Thanks ... View more

Hi,  I am doing a time series (Autoreg) model, which I have over 100 models with 10 years of monthly data.  I have auto prices to over 100 FS's (FS are the 2 digits of a Canadian postal code eg. D2).  I don't want to make 100 models so I need to find what FS's have prices movements in common that I can group them all, but also some cases where it is important to leave some open FS's to more granularity such as FSA's (the first 3 letters of the postal code, eg. D2Y)....so for example leave M5R, M5T, M5H..  hope I've made it simple enough for a good answer.  I basically need a procedure in SAS that allows me to close up some FS (commonality) and leave some open (more detail)..  I was wondering if VARCLUS could work, or any other.   Thanks sample data FS       FSA M5       M5R M5       M5T M5       M5H M4       M4R M4       M4E D2        D2K D2        D2L D4        D4G D3        D3F look something like this FS       FSA M5       M5O    <- was M5 and M4      D2        D2K D2        D2L D4        D4O    <- was D4 and D3 ... View more

I received a code from an outside source and can't get in my own format:  I got (HAVE) and I want it to look like (WANT): HAVE: data temp1; infile cards dlm=',' missover ; input COL1 COL2 COL3 COL4 COL5; rename COL1=Ref_Date; rename COL2=GEO; rename COL3=AREA; rename COL4=STR; rename COL5=Value; datalines ; 199001,"Canada","All areas","Residential (x 1000)",2400224 199602,"Newfoundland and Labrador","All areas","Residential (x 1,000)",16567 run; WANT it cleaned up, you  know what I mean once you run it.  Thanks.. Also I don't know why I can't just insert the sas code neatly in this post.. ... View more

I need some guidance.  I need to forecast retail prices in certain geographical areas, so my dependent variable would be the prices itself, the independent variables could be factors such as 1) # of residents, 2) home prices, 3) unemployment rates 4) GDP .. etc. (the actual variables are just used as examples, not real variables) My question is, if I want to forecast the prices, then MUSt I also forecast the independent variables if I want to use them in the model.. so eg. forecast the unemployment rate also for the next 12 months?  and question number 2 is using PROC ARIMA, how can I 1) determine which independent variables make sense to use in the model and 2) how and where in the proc arima statement do I insert these independent variables? Thanks in advance. ... View more

I have over 100 distributions (Auto dealerships) and I need to use a time series to forecast each dealership's sale for the next 12 months with monthly data I have for the past 10 years.  I want to develop a time series model, but first I want to compare dealerships to see if any have the dependent variable (which in this case is the prices) in common (perhaps Proc corr, I don't know) and see if I can group some so that I don't have to model 100 stores, but instead model only on say 60 or 50, or whatever the results show.. I can say 4 stores show similar trends and cycles, seasonality and increase/decrease in price, that I can group Sore 1/2/3/4 together.. How can this be done?  Is proc corr the right tool or perhaps a proc glm ?? ... View more