Dahcilsam Tracker

Re: Problem with assignment statement

Dahcilsam — Wed, 22 Jul 2015 21:33:02 GMT

Thanks to you all. Problem solved.

Re: Problem with assignment statement

Dahcilsam — Wed, 22 Jul 2015 21:32:27 GMT

Thank you so much, problem is solved.

Re: Problem with assignment statement

Dahcilsam — Wed, 22 Jul 2015 19:55:38 GMT

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;

Problem with assignment statement

Dahcilsam — Wed, 22 Jul 2015 19:18:03 GMT

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";

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.

Re: Error: Variables not found

Dahcilsam — Thu, 11 Jun 2015 18:42:31 GMT

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

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

Dahcilsam — Wed, 10 Jun 2015 18:22:28 GMT

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: 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

10 *IF COMM1='99' THEN DELETE;

11 *IF COMM2='99' THEN DELETE;

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.

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;

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.

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.

Error: Variables not found

Dahcilsam — Wed, 10 Jun 2015 18:17:24 GMT

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: 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

10 *IF COMM1='99' THEN DELETE;

11 *IF COMM2='99' THEN DELETE;

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.

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;

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.

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.

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

Dahcilsam — Tue, 09 Jun 2015 20:01:08 GMT

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

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

Dahcilsam — Tue, 09 Jun 2015 17:44:35 GMT

Thanks Chris. This time around,the error message is "Unable to open file" Below is the log message;

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

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

Dahcilsam — Tue, 09 Jun 2015 17:16:27 GMT

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.

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

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

Dahcilsam — Tue, 09 Jun 2015 17:01:09 GMT

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: 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.

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.

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;

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.

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.

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.

Re: Usage Note 4440: Error: User does not have appropriate authorization level for library WORK

Dahcilsam — Mon, 08 Jun 2015 15:57:23 GMT

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