comp.soft-sys.sas - The SAS statistics package.
I would like cap extreme observations through proc univariate as follows: proc univariate data=c.CashNonCash01PaySample noprint; weight wt; var Transc_currentbalanceNum ; output out=c.BalOutlier std=balstd pctlpts=99 pctlpres=bal; run; data c.CashNonCash01PaySamplea; set c.CashNonCash01PaySample; if (_n_ eq 1) then set c.BalOutlier(keep=balstd bal99); if balstd>2*bal99 then Transc_currentbalanceNum2=min(Transc_currentbalanceNum, (4*bal99)); else Transc_currentbalanceNum2=Transc_currentbalanceNum; run; Now for numeric variables with only positive values, the above code works ok. I would like to do the same for numeric variables with both positive and negative values. How can this be accomplished within proc univariate? Thanks, Doyle.
Missing Values issue: So far, there are no guidelines for how much missing data can be tolerated for a sample of any given size (Tabachnick & Fidell, 1996). Is it correct to analyse the potentially meaningful influences of missing values only when the amount of missings exceeded 7%??? I have seen the scales (item by item) in my study and the % of missings not exceeds 1,3 %. Outliers issue: I have notice several techniques to scan for outliers (steam-and-leaf; zscores, etc... which strategy shoulf i use? Step-by-step.
Hi, In Filter node, when I try to specify the upper and lower limits for a user-specified filtering method - the values disappear as soon as I close the Variables-Filter pop-up box! The same happens with the lower and upper limits (variables) in the Input Data node too. I am not able to restrict the values of any variable for analysis. Any ideas? Thanks, Shalini.