cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
lakshmishree
‎10-13-2020
  • 7 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Reading excel file into SAS

by Fluorite | Level 6 in SAS Programming
‎10-12-2020 03:24 AM
‎10-12-2020 03:24 AM
Still getting the same error, variable type here is a categorical  datatype and if i am renaming it as type$ it throws an error there too. So i just had to convert it into CSV file and there it worked well   Thanks ... View more

Re: 95% confidence intervals for the eigenvalues

by Fluorite | Level 6 in SAS/IML Software and Matrix Computations
‎10-12-2020 03:00 AM
‎10-12-2020 03:00 AM
Now i am able to print the Confidence interval values. Whereas, eigenvalues seems to be different from what i obtained. i Shall copy that code and the output i obtained from both: SAS code: proc princomp data=THC; var chem1 chem2 chem3 chem4 chem5 chem6 chem7 chem8 chem9 chem10 chem11 chem12 chem13; run; SAS output: Eigenvalue 1 4.70585025 2 2.49697373 3 1.44607197 4 0.91897392 5 0.85322818 Whereas when i am trying to run your code i obtain different eigenvalues which is actually of correlation matrix again, since i have "varieties" as another variable in the data and by reading all here, i assume it's including even that variable in it. Could you help me with what changes i would read only selected variables? that is if i want to read only variables : chem1 chem2 chem3 chem4 chem5 chem6 chem7 chem8 chem9 chem10 chem11 chem12 chem13 ... View more

Reading excel file into SAS

by Fluorite | Level 6 in SAS Programming
‎10-11-2020 06:16 AM
‎10-11-2020 06:16 AM
Hey all,   I tried importing excel file into SAS which has no variables declared and then i had renamed it into the variables and when i tried performing the following command to : 1. Prepare the dataset for input for a Discriminant analysis via SAS.  2. Generate the means and the variance-covariance matrix of the data for the genuine note(Genuine = 1 and Fake =2 indicator column in the dataset). Dataset contains six variables measured on 100 genuine and 100 forged (counterfeit/fake).      proc import datafile = '/home/u49442084/sasuser.v94/Swiss Bank data as excel-2.xlsx' out = SwissBank dbms = xlsx replace; GETNAMES=NO; run; proc print data=SwissBank (rename=(a=length b=left c=right d=bottom e=top f=diag g=type)); run;   proc corr data=SwissBank cov; Where type="1"; run;     when checking for genuine notes I got the following error:   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc corr data=SwissBank cov; 74 Where type="1"; ERROR: Variable type is not on file WORK.SWISSBANK. 75 run; ... View more

Re: 95% confidence intervals for the eigenvalues

by Fluorite | Level 6 in SAS/IML Software and Matrix Computations
‎10-11-2020 05:53 AM
‎10-11-2020 05:53 AM
ERROR: (execution) Matrix has not been set to a value. operation : CORR at line 75 column 7 operands : THC THC 0 row 0 col (type ?, size 0) statement : ASSIGN at line 75 column 1 76 77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 89 ... View more

Re: 95% confidence intervals for the eigenvalues

by Fluorite | Level 6 in SAS/IML Software and Matrix Computations
‎10-11-2020 05:47 AM
‎10-11-2020 05:47 AM
you are right, I am here trying to find the eigenvalues of a correlation matrix which is 179*14 matrix.  Tried running following command as you said, but got same errors.   proc princomp data=THC; run; /* 95% confidence intervals for the first to fifth eigenvalues */ proc iml; reset print; R=corr(THC); eig=eigval(R); E=eigvec(R); alpha=0.05; zright=quantile("Normal", 1-alpha/2); CI_1_lower=eig[1]/(1+zright*sqrt(2/179)); CI_1_upper=eig[1]/(1-zright*sqrt(2/179)); CI_2_lower=eig[2]/(1+zright*sqrt(2/179)); CI_2_upper=eig[2]/(1-zright*sqrt(2/179)); CI_3_lower=eig[3]/(1+zright*sqrt(2/179)); CI_3_upper=eig[3]/(1-zright*sqrt(2/179)); CI_4_lower=eig[4]/(1+zright*sqrt(2/179)); CI_4_upper=eig[4]/(1-zright*sqrt(2/179)); CI_5_lower=eig[5]/(1+zright*sqrt(2/179)); CI_5_upper=eig[5]/(1-zright*sqrt(2/179));         ERROR: (execution) Matrix has not been set to a value.   operation : CORR at line 75 column 7 operands : THC   THC 0 row 0 col (type ?, size 0)     statement : ASSIGN at line 75 column 1 76 77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 89 ... View more

95% confidence intervals for the eigenvalues

by Fluorite | Level 6 in SAS/IML Software and Matrix Computations
‎10-09-2020 09:10 AM
‎10-09-2020 09:10 AM
Hey all, I need to find 95% confidence intervals of correlation matrix for the first to fifth eigenvalues of a dataset (n=178). Where, I tried giving it using proc iml as below:   proc iml; reset print; eig=eigval(THC); E=eigvec(THC); alpha=0.05; zright=quantile("Normal", 1-alpha/2); CI_1_lower=eig[1]/(1+zright*sqrt(2/178)); CI_1_upper=eig[1]/(1-zright*sqrt(2/178)); CI_2_lower=eig[2]/(1+zright*sqrt(2/178)); CI_2_upper=eig[2]/(1-zright*sqrt(2/178)); CI_3_lower=eig[3]/(1+zright*sqrt(2/178)); CI_3_upper=eig[3]/(1-zright*sqrt(2/178)); CI_4_lower=eig[4]/(1+zright*sqrt(2/178)); CI_4_upper=eig[4]/(1-zright*sqrt(2/178)); CI_5_lower=eig[5]/(1+zright*sqrt(2/178)); CI_5_upper=eig[5]/(1-zright*sqrt(2/178));   I get only the following output but not intervals. alpha 1 row 1 col (numeric) 0.05 zright 1 row 1 col (numeric) 1.959964   Can anyone tell me where am i going wrong?   Thanks, lakshmi ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-13-2020 12:37 PM
Likes given to
View All
Quick links