turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- General Programming
- /
- Principal components for 10000 variable dataset

Topic Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-15-2014 07:18 AM

Hi all,

I have a dataset which i need to run a clustering algorithm on. First step is to reduce the dataset's dimensions as it has 10400 variables. I use PROC PRINCOMP but the resulting files are so huge they wont open in SAS Results Viewer

Does anyone have a suggestion on how i can access the eigenvalues/eigenvectors tables resulting from the PRINCOMP procedure.

Thanks in advance

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to gagagu

07-15-2014 07:59 AM

Not sure if I understood your question properly, but if you are simply looking for a way to check where the result data is use "ods trace on" to find out the name (SAS(R) 9.2 Output Delivery System: User's Guide) and "ods output" to get the data.

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to user24feb

07-15-2014 08:06 AM

Thank you. I will try your suggestions. Sorry my question wasnt very clear. I think due to the size of the result data, SAS output just fails to open the results which are over 1GB is size.

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to gagagu

07-15-2014 08:58 AM

Try:

ods listing close;

ods html close;

ods output eigenvalues=eigenvalues eigenvectors=eigenvectors;

proc princomp ....

run;

ods listing;

ods html;

You can dispense with the html stuff if you are doing this in batch.

Steve Denham

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to SteveDenham

07-15-2014 11:33 AM

Thanks Steve,

This worked worked. Managed to read the eigenvectors/eigenvalues data from the temp library.

Much appreciated,

R

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to gagagu

07-15-2014 09:55 AM

or try Cronbach's coefficient Alpha of proc corr , Check the example 5 in its documentation.

or try** proc varclus**

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to gagagu

07-15-2014 10:11 AM

Do you want to run clustering algorithm on original variables or on principal components?

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to gagagu

07-15-2014 11:40 AM

@ stat@sas ... i want to run clustering on principal components

Just want to say thanks to you all for your responses. I have managed to access the proc princomp results now.

Many thanks guys,

R