About Dahcilsam

Dahcilsam · ‎07-22-2015

Thanks to you all. Problem solved.

Dahcilsam · ‎07-22-2015

Thank you so much, problem is solved.

Dahcilsam · ‎07-22-2015

Here is the data step; TITLE1 'Analysis of the 2010 Pontotoc Populus Consolidated Test Ages 1-4'; FOOTNOTE1 "Potential Gains from Selection of Eastern Cottonwood and Hybrid Poplars on"; FOOTNOTE2 "Lower Mississippi Alluvial Floodplain and Upland Site"; PROC IMPORT OUT= WORK.PPpTEST2010 DATAFILE= "E:\sasmi\NiuDATA2010PontotocTestAge1to4.xlsx" DBMS=EXCELCS; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; *IF COMM11='99' THEN DELETE; *IF COMM12='99' THEN DELETE; *IF COMM21='99' THEN DELETE; *IF COMM22='99' THEN DELETE; *IF COMM31='99' THEN DELETE; *IF COMM32='99' THEN DELETE; *IF COMM41='99' THEN DELETE; *IF COMM42='99' THEN DELETE; VOL2 = ( 0.21099 + ( 0.00221 * (( AGE2D * AGE2D ) * AGE2HT )); VOL3 = ( 0.21099 + ( 0.00221 * (( AGE3D * AGE3D ) * AGE3HT )); VOL4 = ( 0.21099 + ( 0.00221 * (( AGE4D * AGE4D ) * AGE4HT )); *PROC SORT; *BY BLOCK CLONE; *PROC MEANS NOPRINT; *BY BLOCK CLONE; *VAR AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL2 VOL3 VOL4; *OUTPUT OUT=GENOTYPE MEAN=AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL2 VOL3 VOL4; PROC GLM; CLASS BLOCK CLONE; MODEL AGE1HT AGE2D AGE2HT VOL2 AGE3D AGE3HT VOL3 AGE4D AGE4HT VOL4=BLOCK CLONE BLOCK*CLONE; LSMEANS BLOCK; MEANS BLOCK/DUNCAN ALPHA=0.01; LSMEANS CLONE; MEANS CLONE/DUNCAN ALPHA=0.01; RUN;

Dahcilsam · ‎07-22-2015

Hi everyone, Please I am trying to create some new variables to a SAS data set through the use of an assignment statement within the DATA step, and the process add been coming back with an error message as shown in green color statements below. Please I will appreciate it if anyone can put me through on what the problem and the possible way to tackle the error is. The following are the log statements, showing the data step and the error messages, Thanks in anticipation of a helpful response. NOTE: SAS (r) Proprietary Software 9.4 (TS1M1) Licensed to MISSISSIPPI STATE UNIVERSITY - SFA T&R, Site 70084845. NOTE: This session is executing on the X64_7PRO platform. NOTE: Updated analytical products: SAS/STAT 13.1 SAS/ETS 13.1 SAS/OR 13.1 SAS/IML 13.1 SAS/QC 13.1 NOTE: Additional host information: X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation NOTE: SAS initialization used: real time 1.24 seconds cpu time 0.95 seconds 1 TITLE1 'Analysis of the 2010 Pontotoc Populus Consolidated Test Ages 1-4'; 2 FOOTNOTE1 "Potential Gains from Selection of Eastern Cottonwood and Hybrid Poplars on"; 3 FOOTNOTE2 "Lower Mississippi Alluvial Floodplain and Upland Site"; 4 5 PROC IMPORT OUT= WORK.PPpTEST2010 6 DATAFILE= "E:\sasmi\NiuDATA2010PontotocTestAge1to4.xlsx" 7 DBMS=EXCELCS; 8 SCANTEXT=YES; 9 USEDATE=YES; 10 SCANTIME=YES; 11 RUN; NOTE: WORK.PPPTEST2010 data set was successfully created. NOTE: The data set WORK.PPPTEST2010 has 480 observations and 15 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.42 seconds cpu time 0.12 seconds 12 VOL2 = (0.21099 + (0.00221 * ((AGE2D*AGE2D) * AGE2HT)); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 13 VOL3 = (0.21099 + (0.00221 * ((AGE3D*AGE3D) * AGE3HT)); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 14 VOL4 = (0.21099 + (0.00221 * ((AGE4D*AGE4D) * AGE4HT)); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order.

Dahcilsam · ‎06-11-2015

Thanks ballardw, the data set;WORK.PPTEST2011 did contain the named variables that were the declared missing, that was why I am so confused.

Dahcilsam · ‎06-10-2015

Thanks for the tip Chris, that works successfully, Now I have the data imported. The problem at this stage is that error message keep coming up that most of my Error: Variables were not found. Please I will appreciate it anyone can help out and give me a clue on what to do. The log result is as available below: NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M1) Licensed to MISSISSIPPI STATE UNIVERSITY - SFA T&R, Site 70084845. NOTE: This session is executing on the X64_7PRO platform. NOTE: Updated analytical products: SAS/STAT 13.1 SAS/ETS 13.1 SAS/OR 13.1 SAS/IML 13.1 SAS/QC 13.1 NOTE: Additional host information: X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation NOTE: SAS initialization used: real time 0.94 seconds cpu time 0.77 seconds 1 OPTIONS VALIDVARNAME=ANY; 2 PROC IMPORT OUT= WORK.PPTEST2011 3 DATAFILE= "E:\sasmi\DATA2011PontotocTestAges1to4.xlsx" 4 DBMS=EXCELCS; 5 SCANTEXT=YES; 6 USEDATE=YES; 7 SCANTIME=YES; 8 RUN; NOTE: WORK.PPTEST2011 data set was successfully created. NOTE: The data set WORK.PPTEST2011 has 481 observations and 24 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.46 seconds cpu time 0.14 seconds 9 10 *IF COMM1='99' THEN DELETE; 11 *IF COMM2='99' THEN DELETE; 12 13 VOL2=0.21099+(0.00221*((AGE2D*AGE2D)*AGE2HT)); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 14 VOL3=0.21099+(0.00221*((AGE3D*AGE3D)*AGE3HT)); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 15 VOL4=0.21099+(0.00221*((AGE4D*AGE4D)*AGE4HT)); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 16 17 *PROC SORT; 18 *BY BLOCK CLONE; 19 *PROC MEANS NOPRINT; 20 *BY BLOCK TAXA CLONE; 21 *PROC UNIVARIATE; 22 *VAR AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL2 VOL3 VOL4; 23 *OUT=GENOTYPE MEAN=AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL2 VOL3 VOL4; 24 25 PROC GLM; 26 CLASS BLOCK CLONE; ERROR: Variable BLOCK not found. ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 27 MODEL AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL4=BLOCK CLONE BLOCK*CLONE; ERROR: Variable AGE1HT not found. ERROR: Variable AGE2D not found. ERROR: Variable AGE2HT not found. ERROR: Variable AGE3D not found. ERROR: Variable AGE3HT not found. ERROR: Variable AGE4D not found. ERROR: Variable AGE4HT not found. ERROR: Variable VOL4 not found. NOTE: The previous statement has been deleted. 28 LSMEANS BLOCK; ERROR: Variable BLOCK not found. NOTE: The previous statement has been deleted. 29 MEANS BLOCK/DUNCAN ALPHA=0.05; ERROR: Variable BLOCK not found. NOTE: The previous statement has been deleted. 30 LSMEANS CLONE; ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 31 MEANS CLONE/DUNCAN ALPHA=0.05; ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 32 RUN; NOTE: PROCEDURE GLM used (Total process time): real time 2:19.15 cpu time 2.23 seconds 33 PROC GLM DATA=GENOTYPE; ERROR: File WORK.GENOTYPE.DATA does not exist. 34 CLASS BLOCK CLONE; 35 MODEL AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL4=BLOCK CLONE; ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. NOTE: The previous statement has been deleted. 36 LSMEANS BLOCK; 37 MEANS BLOCK/DUNCAN ALPHA=0.05; ERROR: Variable BLOCK not found. NOTE: The previous statement has been deleted. 38 LSMEANS CLONE; ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 39 MEANS CLONE /DUNCAN ALPHA=0.05; ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 40 RUN; ERROR: A MODEL statement must be given.

Dahcilsam · ‎06-10-2015

Hi everyone, I am trying to run the analysis of my school research, but I have been running into several errors in the process. Thanks to several tips from good and knowledgeable people in this support community, I have been able to over come majority of the initial errors that have to do with unsuccessful data importing. The problem at this stage is that error message keep coming up that most of my Error: Variables were not found. Please I will appreciate it anyone can help out and give me a clue on what to do. The log result is as available below: NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M1) Licensed to MISSISSIPPI STATE UNIVERSITY - SFA T&R, Site 70084845. NOTE: This session is executing on the X64_7PRO platform. NOTE: Updated analytical products: SAS/STAT 13.1 SAS/ETS 13.1 SAS/OR 13.1 SAS/IML 13.1 SAS/QC 13.1 NOTE: Additional host information: X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation NOTE: SAS initialization used: real time 0.94 seconds cpu time 0.77 seconds 1 OPTIONS VALIDVARNAME=ANY; 2 PROC IMPORT OUT= WORK.PPTEST2011 3 DATAFILE= "E:\sasmi\DATA2011PontotocTestAges1to4.xlsx" 4 DBMS=EXCELCS; 5 SCANTEXT=YES; 6 USEDATE=YES; 7 SCANTIME=YES; 8 RUN; NOTE: WORK.PPTEST2011 data set was successfully created. NOTE: The data set WORK.PPTEST2011 has 481 observations and 24 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.46 seconds cpu time 0.14 seconds 9 10 *IF COMM1='99' THEN DELETE; 11 *IF COMM2='99' THEN DELETE; 12 13 VOL2=0.21099+(0.00221*((AGE2D*AGE2D)*AGE2HT)); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 14 VOL3=0.21099+(0.00221*((AGE3D*AGE3D)*AGE3HT)); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 15 VOL4=0.21099+(0.00221*((AGE4D*AGE4D)*AGE4HT)); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 16 17 *PROC SORT; 18 *BY BLOCK CLONE; 19 *PROC MEANS NOPRINT; 20 *BY BLOCK TAXA CLONE; 21 *PROC UNIVARIATE; 22 *VAR AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL2 VOL3 VOL4; 23 *OUT=GENOTYPE MEAN=AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL2 VOL3 VOL4; 24 25 PROC GLM; 26 CLASS BLOCK CLONE; ERROR: Variable BLOCK not found. ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 27 MODEL AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL4=BLOCK CLONE BLOCK*CLONE; ERROR: Variable AGE1HT not found. ERROR: Variable AGE2D not found. ERROR: Variable AGE2HT not found. ERROR: Variable AGE3D not found. ERROR: Variable AGE3HT not found. ERROR: Variable AGE4D not found. ERROR: Variable AGE4HT not found. ERROR: Variable VOL4 not found. NOTE: The previous statement has been deleted. 28 LSMEANS BLOCK; ERROR: Variable BLOCK not found. NOTE: The previous statement has been deleted. 29 MEANS BLOCK/DUNCAN ALPHA=0.05; ERROR: Variable BLOCK not found. NOTE: The previous statement has been deleted. 30 LSMEANS CLONE; ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 31 MEANS CLONE/DUNCAN ALPHA=0.05; ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 32 RUN; NOTE: PROCEDURE GLM used (Total process time): real time 2:19.15 cpu time 2.23 seconds 33 PROC GLM DATA=GENOTYPE; ERROR: File WORK.GENOTYPE.DATA does not exist. 34 CLASS BLOCK CLONE; 35 MODEL AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL4=BLOCK CLONE; ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. NOTE: The previous statement has been deleted. 36 LSMEANS BLOCK; 37 MEANS BLOCK/DUNCAN ALPHA=0.05; ERROR: Variable BLOCK not found. NOTE: The previous statement has been deleted. 38 LSMEANS CLONE; ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 39 MEANS CLONE /DUNCAN ALPHA=0.05; ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 40 RUN; ERROR: A MODEL statement must be given.

Dahcilsam · ‎06-09-2015

Can anyone be of help to tackle this resulting issue please; PROC IMPORT OUT= WORK.PPTEST2011 9 DATAFILE= "E:\sasmi\DATA2011PontotocTestAges1to4.xlsx" 10 DBMS=EXCELCS; 11 SCANTEXT=YES; 12 USEDATE=YES; 13 SCANTIME=YES; 14 RUN; ERROR: This DBMS table or view cannot be accessed by the SAS System because it contains column names that are not unique when a SAS normalized (uppercased) compare is performed. See "Naming Conventions" in the SAS/ACCESS documentation. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.42 seconds cpu time 0.14 seconds

Dahcilsam · ‎06-09-2015

Thanks Chris. This time around,the error message is "Unable to open file" Below is the log message; NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M1) Licensed to MISSISSIPPI STATE UNIVERSITY - SFA T&R, Site 70084845. NOTE: This session is executing on the X64_7PRO platform. NOTE: Updated analytical products: SAS/STAT 13.1 SAS/ETS 13.1 SAS/OR 13.1 SAS/IML 13.1 SAS/QC 13.1 NOTE: Additional host information: X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation NOTE: SAS initialization used: real time 0.92 seconds cpu time 0.82 seconds 1 PROC IMPORT OUT= WORK.PPTEST2011 2 DATAFILE= "E:\SasWorkAndResults\DATAFORSASPROG2011PontotocTestAges1to4.xlsx" 3 DBMS=EXCELCS; 4 SCANTEXT=YES; 5 USEDATE=YES; 6 SCANTIME=YES; 7 RUN; ERROR: Unable to open file E:\SasWorkAndResults\DATAFORSASPROG2011PontotocTestAges1to4.xlsx. It does not exist or it is already opened exclusively by another user, or you need permission to view its data. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.15 seconds cpu time 0.12 seconds

Dahcilsam · ‎06-09-2015

Thank you for the info and the assistance. Following the suggestion you gave, this is the obtained result. 59 PROC IMPORT DATAFILE= 59 ! "E:\SasWorkAndResults\DATAFORSASPROG2011PontotocTestAges1to4.xlsx" 60 OUT= WORK.PPTEST2011 61 DBMS=EXCELCS; NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. 62 GETNAMES=YES; 63 MIXED=NO; ----- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 64 SCANTEXT=YES; 65 USEDATE=YES; 66 SCANTIME=YES; 67 RUN; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds My question is; do I need to do away with MIXED=NO; command

Dahcilsam · ‎06-09-2015

This question is Not Answered.(Mark as assumed answered) SAM LOLU Jun 9, 2015 12:54 PM Hi everyone, please I need an assistance in getting through my research analysis with SAS. I have the result data on excel spread sheet, but getting it imported into SAS had been a difficult issue. Import wizard is saying "Connection failed, see log for detail", and the log detail is "ERROR: Connect: Class not registered. ERROR: Error in the LIBNAME statement." I tried using the Proc Import command,it came back with "No Observation, and when I pasted the data as "Cards", there were some errors in the result ( Although I could not say if that was as a result of some missing values though represented with full stop sign). I will appreciate it anyone can help out and give me a clue of what to do, as I`ve been stocked at this point going to four weeks. Below is the log message produced: NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M1) Licensed to MISSISSIPPI STATE UNIVERSITY - SFA T&R, Site 70084845. NOTE: This session is executing on the X64_7PRO platform. NOTE: Updated analytical products: SAS/STAT 13.1 SAS/ETS 13.1 SAS/OR 13.1 SAS/IML 13.1 SAS/QC 13.1 NOTE: Additional host information: X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation NOTE: SAS initialization used: real time 0.95 seconds cpu time 0.81 seconds 1 PROC IMPORT OUT= WORK.PPTEST2011 2 DATAFILE= "E:\SasWorkAndResults\DATAFORSASPROG2011PontotocTestAges1to4.xlsx" 3 DBMS=EXCEL REPLACE; 4 GETNAMES=YES; 5 MIXED=NO; 6 SCANTEXT=YES; 7 USEDATE=YES; 8 SCANTIME=YES; 9 RUN; ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. Connection Failed. See log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.13 seconds cpu time 0.07 seconds 10 IF COMM1=99 THEN DELETE; -- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 11 IF COMM2=99 THEN DELETE; -- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 12 13 Vol2=0.21099+(0.00221*((AGE2D*AGE2D)*AGE2HT)); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 14 Vol3=0.21099+(0.00221*((AGE3D*AGE3D)*AGE3HT)); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 15 Vol4=0.21099+(0.00221*((AGE4D*AGE4D)*AGE4HT)); ---- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 16 17 18 *PROC SORT; 19 *BY BLOCK CLONE; 20 *PROC MEANS NOPRINT; 21 *BY BLOCK TAXA CLONE; 22 *PROC UNIVARIATE; 23 *VAR AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL2 VOL3 VOL4; 24 *OUT=GENOTYPE MEAN=AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL2 VOL3 VOL4; 25 26 PROC GLM; ERROR: There is not a default input data set (_LAST_ is _NULL_). 27 CLASS BLOCK CLONE; 28 MODEL AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL4=BLOCK CLONE BLOCK*CLONE; ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. NOTE: The previous statement has been deleted. 29 LSMEANS BLOCK; 30 MEANS BLOCK/DUNCAN ALPHA=0.01; ERROR: Variable BLOCK not found. NOTE: The previous statement has been deleted. 31 LSMEANS CLONE; ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 32 MEANS CLONE/DUNCAN ALPHA=0.01; ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 33 RUN; ERROR: A MODEL statement must be given. NOTE: PROCEDURE GLM used (Total process time): real time 19.30 seconds cpu time 1.21 seconds 34 PROC GLM DATA=GENOTYPE; ERROR: File WORK.GENOTYPE.DATA does not exist. 35 CLASS BLOCK CLONE; 36 MODEL AGE1HT AGE2D AGE2HT AGE3D AGE3HT AGE4D AGE4HT VOL4=BLOCK CLONE; ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. ERROR: No data set open to look up variables. NOTE: The previous statement has been deleted. 37 LSMEANS BLOCK; 38 MEANS BLOCK/DUNCAN ALPHA=0.01; ERROR: Variable BLOCK not found. NOTE: The previous statement has been deleted. 39 LSMEANS CLONE; ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 40 MEANS CLONE /DUNCAN ALPHA=0.01; ERROR: Variable CLONE not found. NOTE: The previous statement has been deleted. 41 RUN; ERROR: A MODEL statement must be given.

Dahcilsam · ‎06-08-2015

Problem with Excel spreadsheet data importing on SAS 9.4 Hi everyone, please I need an assistance in getting through my research analysis with SAS. I have the result data on excel spread sheet, but getting it imported into SAS had been a difficult issue. Import wizard is saying "Connection failed, see log for detail", and the log detail is "ERROR: Connect: Class not registered. ERROR: Error in the LIBNAME statement." I tried using the Proc Import command,it came back with "No Observation, and when I pasted the data as "Cards", there were some errors in the result ( Though I could not say if that was as a result of some missing values that represented with full stop sign). I will appreciate it anyone can help out and give me a clue of what to do, as I`ve been stocked at this point going to four weeks now. Thanks

Online Status	Offline
Date Last Visited	‎05-05-2017 11:52 PM

Re: Problem with assignment statement

Re: Problem with assignment statement

Re: Problem with assignment statement

Problem with assignment statement

Re: Error: Variables not found

Re: Problem with Excel (.xlsx) spreadsheet data importing on SAS 9.4

Error: Variables not found

Re: Problem with Excel (.xlsx) spreadsheet data importing on SAS 9.4

Re: Problem with Excel (.xlsx) spreadsheet data importing on SAS 9.4

Re: Problem with Excel (.xlsx) spreadsheet data importing on SAS 9.4

Re: Problem with assignment statement

Re: Problem with assignment statement

Re: Problem with assignment statement

Re: Problem with Excel (.xlsx) spreadsheet data importing on SAS 9.4

Re: Problem with Excel (.xlsx) spreadsheet data importing on SAS 9.4

Re: Problem with assignment statement

Re: Problem with assignment statement

Re: Problem with assignment statement

Problem with assignment statement

Re: Error: Variables not found

Re: Problem with Excel (.xlsx) spreadsheet data importing on SAS 9.4

Error: Variables not found

Re: Problem with Excel (.xlsx) spreadsheet data importing on SAS 9.4

Re: Problem with Excel (.xlsx) spreadsheet data importing on SAS 9.4

Re: Problem with Excel (.xlsx) spreadsheet data importing on SAS 9.4

Problem with Excel (.xlsx) spreadsheet data importing on SAS 9.4

Re: Usage Note 4440: Error: User does not have appropriate authorizati...