topic Re: Problem running Sheard Principal Analysis code in SAS Studio

Problem running Sheard Principal Analysis code

hbartjr — Fri, 05 Jan 2018 18:34:39 GMT

I'm encountering an execution error when analyzing some seasoned SAS code for something called "Sheared Principal Components Analysis" on fish proportional measurements. The error statement reads "ERROR: (execution) Invalid argument or operand; contains missing values" and references line 136 in my code (I think), which reads: "Q = (X`*X - C`*C*NIND)/(NIND-{1}); ". I've successfully run this code hundreds of times in SAS University Edition and earlier versions of SAS. I'm attaching the code and the dataset I'm using in case this sounds like something someone can help me with. Many thanks, Hank

Re: Problem running Sheard Principal Analysis code

ballardw — Fri, 05 Jan 2018 18:42:32 GMT

Run Proc contents on your imported data set. It is very likely that due to the nature of Excel files that a variable that was previously numeric is character this time or possibly the names of the variables changed. Either might result in missing values for the variables.

Look at the variable type for the variables mention on that referenced line 136 of code: X C NIND.

Re: Problem running Sheard Principal Analysis code

hbartjr — Fri, 05 Jan 2018 19:47:55 GMT

The variables you mention are defined in "MAIN" code. NIND = number of individuals (43) and C = grand centroid. I imported the data set and all data points are numeric in output.

Re: Problem running Sheard Principal Analysis code

Reeza — Fri, 05 Jan 2018 20:26:53 GMT

Can you post a PROC CONTENTS of your input data set?

Re: Problem running Sheard Principal Analysis code

Reeza — Fri, 05 Jan 2018 20:32:12 GMT

And you didn't include the data set so we can't run your code either.

Re: Problem running Sheard Principal Analysis code

hbartjr — Fri, 05 Jan 2018 21:09:03 GMT

The data table from Proc Contents is attached.

Re: Problem running Sheard Principal Analysis code

hbartjr — Fri, 05 Jan 2018 21:10:30 GMT

Here's the data file.

Re: Problem running Sheard Principal Analysis code

Reeza — Fri, 05 Jan 2018 21:12:31 GMT

That's PROC PRINT, Not PROC CONTENTS.

Re: Problem running Sheard Principal Analysis code

hbartjr — Fri, 05 Jan 2018 21:20:48 GMT

Oops. How's this?

Re: Problem running Sheard Principal Analysis code

Reeza — Fri, 05 Jan 2018 21:28:19 GMT

Your original error

ERROR: (execution) Invalid argument or operand; contains missing values

Row 13, DoFL value is missing in the Excel file. It runs fine once you fix the data to not have missing values.

@hbartjr wrote:

I'm encountering an execution error when analyzing some seasoned SAS code for something called "Sheared Principal Components Analysis" on fish proportional measurements. The error statement reads "ERROR: (execution) Invalid argument or operand; contains missing values" and references line 136 in my code (I think), which reads: "Q = (X`*X - C`*C*NIND)/(NIND-{1}); ". I've successfully run this code hundreds of times in SAS University Edition and earlier versions of SAS. I'm attaching the code and the dataset I'm using in case this sounds like something someone can help me with. Many thanks, Hank

Re: Problem running Sheard Principal Analysis code

hbartjr — Fri, 05 Jan 2018 21:43:14 GMT

Row 13 of DoFL is assigned a "." (period) value in the results table (attached), which I thought meant missing value, and would be skipped. Does SAS no longer work this way? I could delete the entire row and see if that fixes it. I've got to run, so it'll be a while before I can respond to any more posts. Thanks!

Re: Problem running Sheard Principal Analysis code

Reeza — Fri, 05 Jan 2018 21:51:58 GMT

@hbartjr wrote:

Row 13 of DoFL is assigned a "." (period) value in the results table (attached), which I thought meant missing value, and would be skipped. Does SAS no longer work this way? I could delete the entire row and see if that fixes it. I've got to run, so it'll be a while before I can respond to any more posts. Thanks!

It does in data steps, not in PROC IML. Matrices math can't handle missing values in this case.

Re: Problem running Sheard Principal Analysis code

hbartjr — Sat, 06 Jan 2018 01:04:18 GMT

Rezza, Deleting that line of data fixed it! Many thanks!