topic Re: Prac Factor and Proc Score in Statistical Procedures

Prac Factor and Proc Score

Shakti_Sourav — Thu, 28 Oct 2021 10:27:20 GMT

Hy,

I want to calculate by formula instead of using Proc Factor and Proc Score in SAS EG.

I want CSAT score from avbailable Varibales i.e positive behaviour, positive bribe and positive service,

i have attached one examnple by the name of Example1 and Example 2

help me what will be the formula to get this score

Thank You

ShaktiExample1Example2my dataset like this, and i have to calculate CSAT Score by taking of these 3 variables and CSAT score must be under 80%

Re: Prac Factor and Proc Score

PaigeMiller — Thu, 28 Oct 2021 11:35:27 GMT

What exactly is the problem with the code you are showing? Why isn't PROC SCORE sufficient in this case?

Re: Prac Factor and Proc Score

Shakti_Sourav — Thu, 28 Oct 2021 12:01:45 GMT

Proc factor and Proc score both are not accessible in my system.

Re: Prac Factor and Proc Score

Shakti_Sourav — Thu, 28 Oct 2021 12:02:20 GMT

I just want formula instead of proc score and Proc factor

Re: Prac Factor and Proc Score

PaigeMiller — Thu, 28 Oct 2021 12:19:05 GMT

So what is wrong with the formula you typed?

Re: Prac Factor and Proc Score

Shakti_Sourav — Mon, 01 Nov 2021 03:13:32 GMT

which formula calculate the factor. I have used that Varibales-(mean(Variables)/Std). is it calculating the Factor/Score?

Re: Prac Factor and Proc Score

Zard — Mon, 01 Nov 2021 15:22:56 GMT

You probably need to center the raw data as well. See if this helps:

title 'PROC FACTOR';
proc factor data=sashelp.class method=prin nfact=2 outstat=outstat out=out ;
var height weight;
run;
proc print data=out;
run;

title 'PROC SCORE';
/*The PROC SCORE statement does not contain the NOSTD option,
so the data in the input data set are standardized before scoring.*/
proc score data=sashelp.class score=outstat out=scored;
var height weight;
run;
proc print data=scored;
run;

title 'BY HAND';
proc print data=outstat;
run;
/*
Obs _TYPE_ _NAME_ Height Weight
1 MEAN 62.3368 100.026
2 STD 5.1271 22.774
3 N 19.0000 19.000
4 CORR Height 1.0000 0.878
5 CORR Weight 0.8778 1.000
6 COMMUNAL 1.0000 1.000
7 PRIORS 1.0000 1.000
8 EIGENVAL 1.8778 0.122
9 PATTERN Factor1 0.9690 0.969
10 PATTERN Factor2 0.2472 -0.247
11 SCORE Factor1 0.5160 0.516
12 SCORE Factor2 2.0227 -2.023
*/

data scores_by_hand;
set sashelp.class;
MeanHeight= 62.3368 ;
MeanWeight=100.026 ;
StdHeight=5.1271;
StdWeight= 22.774 ;
F1_StdScoringCoeff_Height=0.51601467;
F1_StdScoringCoeff_Weight=0.51601467;
F2_StdScoringCoeff_Height=2.02266093;
F2_StdScoringCoeff_Weight=-2.02266093;
Factor1=F1_StdScoringCoeff_Height*(Height-MeanHeight)/StdHeight +
F1_StdScoringCoeff_Weight*(Weight-MeanWeight)/StdWeight ;
Factor2=F2_StdScoringCoeff_Height*(Height-MeanHeight)/StdHeight +
F2_StdScoringCoeff_Weight*(Weight-MeanWeight)/StdWeight ;
drop MeanHeight MeanWeight StdHeight StdWeight
F1_StdScoringCoeff_Height F1_StdScoringCoeff_Weight
F2_StdScoringCoeff_Height F2_StdScoringCoeff_Weight ;
run;
proc print data=scores_by_hand;
run;

Re: Prac Factor and Proc Score

Shakti_Sourav — Tue, 02 Nov 2021 10:34:39 GMT

Thank You

But How to calculate by formula of F1_StdScoringCoeff_Height and F1_StdScoringCoeff_Weight ??

Re: Prac Factor and Proc Score

Shakti_Sourav — Tue, 02 Nov 2021 10:38:39 GMT

I don't have access for SAS/STAT. that's why I am Unable to use Proc Factor and Proc score. So I want to do by Formula instead of Proc factor and proc score.

Re: Prac Factor and Proc Score

SteveDenham — Tue, 02 Nov 2021 12:26:04 GMT

I don't understand. Your first post shows output from PROC FACTOR, so someplace along the line it was available. Could you explain your situation further?

SteveDenham

Re: Prac Factor and Proc Score

Zard — Tue, 02 Nov 2021 13:59:04 GMT

I misunderstood the question. Let me regroup...

Re: Prac Factor and Proc Score

Zard — Tue, 02 Nov 2021 16:29:01 GMT

If you want to derive the factor scoring coefficients outside of SAS, you would still need a matrix algebra software package. Here is an example (which I did not write) using PROC IML:

proc corr data=sashelp.class outp=corr;
var age height weight;
run;

proc factor data=corr method=prin;
ods select eigenvalues;
run;

proc iml;
R= {1.0000 0.8114 0.7409,
0.8114 1.0000 0.8778,
0.7409 0.8778 1.000};
priors={1 1 1};
d=diag(priors);
r1 = R-i(3) +d;
print r r1;
call eigen(e1,e2,r1);
print e1;
quit;

Re: Prac Factor and Proc Score

Shakti_Sourav — Wed, 03 Nov 2021 03:25:10 GMT

Hy,

other system have access Proc factor. but in my system don't have an access of SAS/STAT. so I want to calculate by formula..

Thank you