SAS Support Communities

timkill1982 · ‎12-01-2015

Great thanks so much i can use this work around

timkill1982 · ‎12-01-2015

Correlations y1 y2 y1 Pearson Correlation 1 .08795657670102520 Sig. (2-tailed) .85635055753627600 N 7 7 y2 Pearson Correlation .08795657670103 1 Sig. (2-tailed) .856350557536276 N 7 7 Spss Output Variable y1 y2 Py1 Py2 y1 1 0.08796 _ 0.8882 y2 0.08796 1 0.8882 _ sas output The correlations are the same but the P values differ!

timkill1982 · ‎11-30-2015

I had the same problem with TTEST last week that the WEIGHT/FREQ statement doesn't work correctly. Most of the testweights range from 0.3-2.89

timkill1982 · ‎11-30-2015

the spss code applies a weight. *Weight data. WEIGHT BY testweight. *Correlation Matrix. CORRELATIONS /VARIABLES=A B C D E F G /PRINT=TWOTAIL NOSIG /MISSING=PAIRWISE. So if i add the weight statement in SAS, i would expect the same answer as spss but it stays the same as previous!! ODS OUTPUT PearsonCorr=TEST1 /*; PROC CORR DATA=TEST OUTP=CORRS; weight testweight; VAR A B C D E F G; RUN; ODS LISTING;

timkill1982 · ‎11-30-2015

Using that simple example the outputs match...i better take a closer look to see whats happening with my data.

timkill1982 · ‎11-30-2015

I am looking to replicate code from Spss..to SAS *Correlation Matrix. CORRELATIONS /VARIABLES=A B C D E F G /PRINT=TWOTAIL NOSIG /MISSING=PAIRWISE. ODS OUTPUT PearsonCorr=TEST1 /*; PROC CORR DATA=TEST OUTP=CORRS; VAR A B C D E F G; RUN; ODS LISTING; When i run the above code in spss and sas. Although the Correlations are the same the signifiance levels differ..How do you specify the twotail method in SAS.

timkill1982 · ‎11-25-2015

FREQ Statement FREQ variable ; The variable in the FREQ statement identifies a variable that contains the frequency of occurrence of each observation. PROC TTEST treats each observation as if it appears times, where is the value of the FREQ variable for the observation. If the value is not an integer, only the integer portion is used. If the frequency value is less than 1 or is missing, the observation is not used in the analysis. When the FREQ statement is not specified, each observation is assigned a frequency of 1. The FREQ statement cannot be used if the DATA=data set contains statistics instead of the original observations. This would there for exclude a lot of my variables if the weight is less than 1....

timkill1982 · ‎11-25-2015

ods output Statistics=Statistics1 TTests=TTests Equality=Equality; proc ttest data=&lib..&d ci=none; freq weight1; /*weight weight1*/ where BRAND in ("Overall",&company) ;; class &condition; var &outcome; run; ods output close; So my solution should be as above?

timkill1982 · ‎11-25-2015

Yes Statistics1 remains unchanged. By appliying the weights I would have assumed that the N values would have changed, and result in a change in the Mean values.

timkill1982 · ‎11-25-2015

ods output Statistics=Statistics1 TTests=TTests Equality=Equality; proc ttest data=&lib..&d ci=none; weight weight1; where BRAND in ("Overall",&company) ;; class &condition; var &outcome; run; ods output close; When i run the following code, my output in the Statistics1 dataset is not weighted even though i have specified the weight option? Is there a work around for this?

Online Status	Offline
Date Last Visited	‎02-01-2017 04:07 AM

SAS Support Communities

Re: proc corr two sided

Re: proc corr two sided

Re: proc corr two sided

Re: proc corr two sided

Re: proc corr two sided

proc corr two sided

Re: PROC TTEST WEIGHT NOT WORKING

Re: PROC TTEST WEIGHT NOT WORKING

Re: PROC TTEST WEIGHT NOT WORKING

PROC TTEST WEIGHT NOT WORKING

Re: proc corr two sided

Re: proc corr two sided

Re: proc corr two sided

Re: proc corr two sided

Re: proc corr two sided

Re: proc corr two sided

proc corr two sided

Re: PROC TTEST WEIGHT NOT WORKING

Re: PROC TTEST WEIGHT NOT WORKING

Re: PROC TTEST WEIGHT NOT WORKING

PROC TTEST WEIGHT NOT WORKING

Follow Us

What is...