Hi, as you can see I'm not that familiar with proc sql, but how can I subtract the results from one table from another table?  using minus.? If I have table A with 20,000 records and table B a subsidiary of A with 12,000, I want to get Table C with the remaining 18,000 recods.. in PROC SQL Thanks ... View more

Hi, woul dthis be possible ?, I'm trying to use distinct on a field but view all the fields in the table ..using proc sql.. I have a large dataset with lots of fields, so the example below is for simplicity only. Ex. use distinct on Acct. but view the remaining fields with it.. HAVE: Acct    F1    F2    F3 234      w      5      6 234      w      5      6 234      w      5      6 345      m      2     8 564      f        6     3 356      w       5     9 WANT: Acct    F1    F2    F3 234      w      5      6 345      m      2     8 564      f        6     3 356      w       5     9 Thanks ... View more

Hi, i'm sure this is such a simpel task, and I'm sure I've done before, amny years back.  But for the life of me, I can't seem to remember how I can view all the observations after a proc univariate.. Ex. A   5 A   6 A   7 B  10 B  12 B  14 after getting median in proc univarite I want to see A   5   6 A   6   6 A   7   6 B  10  12 B  12  12 B  14  12 rather than A    6 B  12 thank you. ... View more

Hi, is anyone able to provide any code for calculating the Median Absolute Deviation.  I'm trying to find outliers based on MAD.  Thanks, Michael ... View more

Hi, is there a procedure of code in SAS where I can get reference ranges? For example I have 20 cities with home prices for each month for 2 years for each city. I do have the standard Deviation and the Coefficient of Variation, but am looking to see if a range of the Prices are more in an optimal range then others.. almost like identifying outliers.  So for example if the range of City-A is between 300,000 and 500,00, is optimal, anyhting outside of that range is considered an outlier, or whatever term you may call it.   Thanks ... View more

Hi, If I have a dataset by City, and date and price. How can I get a count of consecutive months that the price is missing by City. Have City     Month   Price Tor       01          345 Tor       02           . Tor       03           . Tor       04          367 Tor       05          678 Mon     01           . Mon     02         235 Mon     03          . Mon     04          . Win      01        234 Win      02       456 Win      03         . Win      04         . Win      05         . Want City     ConsMonth Tor             2 Mon           1 Win           5 Thanks ... View more

Hi,  I'm trying to see if a data set (or multiple of them) which are in a data set forma are highly volatile and if they show large variances.  So one way I am doing this through is getting the price and it's lag of one month... example below.. the I ran a proc corr between Price and Lag_Price to see if there are highly correlated, if they are, then the difference in price from last month to current month, and so on, are correlated and therefore not a high variance between the 2.... The question I have is, if I have a time series of say 20 months and I get the lag month of that series, 19 months.. and run a proc corr, since I'm only seeing 1 number for the CORRELATION,  is this fine ?, or I was hoping to see 19 numbers of correlation between prioce and price_lag for each of the months.. Example Date    Price   Lag_Price Jan       29 Feb      32          29 Mar      40          32 Apr       46         40 May      53         46 Jun       90         53 Jul        92         90 I was hoping to see a high volatility between May and Jun, or even if I use a bY statement for the Cities, if one city is considered highly volatile and another not.. Thanks ... View more