Please, I'd also like answer to the special question: can I search the database by name (mine)? Ok, back to this. i added semicolons after the do's and the documentation shows that. I thought about adding a narrative description and didn't. Here it is. If A2LECPOS ge 1, I want the do loop to execute and then go on to execute the five computation statements and skip over the else if and else blocks. However, it A2LECPOS eq 0, only the statements in the else if block are executed. Lastly, if A2LECPOS equals anything else (here, '.'), only the statements in the else block are executed. Do loops have to have their own 'end' statement. How else does the compiler/interpreter know where the loop ends at. Maybe (probably) I misunderstood one respondent saying that the do loop 'end' statement is interpreted as the end of the if block. 'end' seems to have multiple meanings and, worse, they are contextual. 2765 array vpcl{20} A2PCL1-A2PCL20; 2766 if (A2LECPOS ge 1) then 2767 do i=1 to 20; 2768 vpcl{i}=vpcl{i}-1; 2769 end; 2770 do; 2771 A2PCLRXP=round(mean (of A2PCLP1 A2PCLP2 A2PCLP3 A2PCLP4 A2PCLP5)*5); 2772 A2PCLAVD=round(mean (of A2PCLP6 A2PCLP7)*2); 2773 A2PCLNCM=round(mean (of A2PCLP8 A2PCLP9 A2PCLP10 A2PCLP11 A2PCLP12 2774 A2PCLP13 A2PCLP14)*7); 2775 A2PCLHA=round(mean (of A2PCLP15 A2PCLP16 A2PCLP17 A2PCLP18 A2PCLP19 2776 A2PCLP20)*6); 2777 A2PCLTOT=mean (of A2PCLP1-A2PCLP20); 2778 end; 2779 else if (A2LECPOS eq 0) then do; ---- 160 ERROR 160-185: No matching IF-THEN clause. 2780 A2PCLRXP=.s; 2781 A2PCLAVD=.s; 2782 A2PCLNCM=.s; 2783 A2PCLHA=.s; 2784 A2PCLTOT=.s; 2785 end; 2786 else do; 2787 A2PCLRXP=.p; 2788 A2PCLAVD=.p; 2789 A2PCLNCM=.p; 2790 A2PCLHA=.p; 2791 A2PCLTOT=.p; 2792 end; 2793 run; ... View more

The denoument: one of our IT persons installed Microsoft access runtime 2013. Problem is now fixed. I want to thank the persons who responded. Gene Maguin ... View more

Ok. I cleared the libname. Here's the log. I don't know why the Scantext, Usedate, and Scantime subcommands are used but I assume they are there because they were needed or are needed. Also, what does the "n" following the sheetname do? That wasn't liked either. Separately from this, I went through the proc import menu system and I got the original Connect error. 17 18 FILENAME dat "N:\UBNeighborhoodFDP\UB Neighborhood Data\DATA\Data\T3 sas data\ 19 Child\Questionnaires\Peer\t3_peer_interview_part_1_lt1.xls"; 20 PROC IMPORT DATAFILE=dat 21 DBMS=XLS replace 22 OUT=work.peer1lt1; NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. 23 GETNAMES=YES; NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. 24 MIXED=YES; 25 SCANTEXT=YES; -------- 180 26 USEDATE=YES; ------- 180 27 SCANTIME=YES; -------- 180 28 SHEET="t3_peer_interview_part_1_lt1$";n; - 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 29 RUN; NOTE: The SAS System stopped processing this step because of errors. ... View more

No, we didn't try that but I did just now. Here's what came back (but maybe there are some other things that need to be changed because this syntax was likely written circa 2010): 5 PROC IMPORT OUT= work.peer1lt1 6 DATAFILE= "N:\UBNeighborhoodFDP\UB Neighborhood Data\DATA\Data\T3 sas 6 ! data\Child\Questionnaires\Peer\t3_peer_interview_part_1_lt1.xls" 7 DBMS=xls REPLACE; NOTE: The previous statement has been deleted. NOTE: The previous statement has been deleted. 8 SHEET="t3_peer_interview_part_1_lt1$"; NOTE: The previous statement has been deleted. 9 GETNAMES=YES; 10 MIXED=YES; 11 SCANTEXT=YES; -------- 180 12 USEDATE=YES; ------- 180 13 SCANTIME=YES; -------- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 14 RUN; ... View more

Respectfully, I converted an xls file to xlsx using Office 2019 and the described syntax would not read the xlsx file. And, where would a person find an installable version of excel 97 that would run on a win10 x64 machine. The alternative is to open and resave the files as csv, but we have, I guess, 3 waves * 4 respondents * 3 interview parts * 15 xls files per part. ... View more