topic Re: Multiple factor analysis in Statistical Procedures

Multiple factor analysis

chetan3 — Mon, 09 Oct 2017 18:03:50 GMT

Hello,

I ran an experiment, where we need to separate products on appearance basis onto map. So each panelists ended with having x and y coordinates for samples. So, now how I can add data into sas to run MFA. So I have data attached here.

Re: Multiple factor analysis

Reeza — Mon, 09 Oct 2017 18:23:49 GMT

To Import data into SAS use PROC IMPORT or the Import Utility.

Here's a video on how to import data using the Import Utility

http://video.sas.com/detail/video/4664358166001/using-the-import-data-utility-in-sas-studio?autoStart=true&q=excel

Re: Multiple factor analysis

chetan3 — Mon, 09 Oct 2017 18:26:30 GMT

Thanks Reeza, but I am asking how to run multiple factor analysis. Like what code I have to use.

Re: Multiple factor analysis

Reeza — Mon, 09 Oct 2017 18:38:04 GMT

Sadly I'm not seeing anything under PROC FACTOR or PRINCOMP to handle the multiple part 😞

I'll move this to the Statistical Procedure forum so others can offer their suggestions.

Re: Multiple factor analysis

PaigeMiller — Mon, 09 Oct 2017 21:36:05 GMT

PROC CALIS ought to do this, perhaps this example can get you pointed in the right direction

http://documentation.sas.com/?docsetId=statug&docsetTarget=statug_calis_examples46.htm&docsetVersion=14.3&locale=en

Re: Multiple factor analysis

chetan3 — Sat, 14 Oct 2017 03:55:13 GMT

Thanks, but how would be then data entry, like.

data sensory;

input panelists $ x y x y x y x y x y; or actually how I should input. Here I have problem in input. Each x and y pair belong to 1 panelist.
datalines;
093 12 13.25 10.1 10.1 24 2.3 12 8 24 9
637 12 11 9.75 10.1 22.8 1 12 8.5 17.75 9.75
217 1.5 14.5 0.5 12 10.5 7.5 1 9 16.75 11.5
225 23.25 9.75 5 15.75 9 3.7 23 8 7 14.5

;

run;

Re: Multiple factor analysis

PaigeMiller — Sat, 14 Oct 2017 10:56:03 GMT

The example shown works with covariance matrices. So, compute covariance matrices.

Re: Multiple factor analysis

chetan3 — Fri, 20 Oct 2017 17:03:09 GMT

HelloPaigeMiller, I computed correlation matrix, so can you please let me know how I should input my data now.

data estonia;
input type$ name$ x1 y1 x2 y2 x3 y3 x4 y4 x5 y5;
datalines;
cov x1 1.00
cov y1 -0.30270 1.00
cov x2 0.13742 0.15644 1.00
cov y2 -0.24693 0.34916 0.05823 1.00
cov x3 -0.34308 0.10424 -0.15834 -0.12062 1.00
cov y3 0.09093 -0.14226 -0.16557 -0.37801 0.15527 1.00
cov x4 0.78430 -0.43878 -0.06424 -0.32105 -0.04186 0.13995 1.00

its showing error in log like -
cov y4 0.02571 -0.23155 0.09631 -0.01274 -0.19213 0.29059 0.13352 1.00
cov x5 -0.72669 0.23910 -0.13214 0.35858 0.59434 -0.35605 -0.57412 -0.35781 1.00
cov y5 0.22256 -0.02439 -0.08846 0.35013 -0.09050 -0.42388 0.20654 -0.39163 -0.09126 1.00
;
run;

If I ran this, its showing error in log,

Note: invalid data for x2 in line 66

invalid data for y3 in line 67