1                                                          The SAS System                            13:37 Thursday, January 5, 2017

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='Program (4)';
4          %LET _CLIENTPROJECTPATH='E:\VA_Projects\RF\RF_Bounce_Final.egp';
5          %LET _CLIENTPROJECTNAME='RF_Bounce_Final.egp';
6          %LET _SASPROGRAMFILE=;
7          
8          ODS _ALL_ CLOSE;
9          OPTIONS DEV=ACTIVEX;
10         GOPTIONS XPIXELS=0 YPIXELS=0;
11         FILENAME EGSR TEMP;
12         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
13             STYLE=HtmlBlue
14             STYLESHEET=(URL="file:///E:/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
15             NOGTITLE
16             NOGFOOTNOTE
17             GPATH=&sasworklocation
18             ENCODING=UTF8
19             options(rolap="on")
20         ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
21         
22         GOPTIONS ACCESSIBLE;
23         /*libname CFE Base "E:\CFE\CFE1";*/
24         
25         


26         proc sql;
27         connect to odbc as oracledb
28         (datasrc="RF_LMS" user=HF_SAS password=XXXXXX);
29         
30         create table work.test_dataset as
31         select *
32         from connection to oracledb
33         (
34         execute HF_REPORTING.LMS_DATA_ARCHIVED
35         
36         );
ERROR: CLI prepare error: [Oracle][ODBC]Syntax error or access violation.
SQL statement: execute HF_REPORTING.LMS_DATA_ARCHIVED.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
37         quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.05 seconds
      cpu time            0.03 seconds
      
38         
39         
40         /*proc sql;*/
41         /*connect to odbc (dsn = RF_LMS user=HF_SAS pwd=HF_SAS);*/
42         /*create table RF.LMS (compress = yes) as */
43         /*select * from connection to odbc (*/
44         /*select  *  from HF_REPORTING.LMS_DATA_ARCHIVED*/
45         /*/*HF_REPORTING.DELINQUENT_LMS_DUMP*/*/
46         /*);*/
47         /*disconnect from odbc;*/
2                                                          The SAS System                            13:37 Thursday, January 5, 2017

48         /* ;*/
49         /* quit;*/
50         /**/
51         
52         
53         
54         GOPTIONS NOACCESSIBLE;
55         %LET _CLIENTTASKLABEL=;
56         %LET _CLIENTPROJECTPATH=;
57         %LET _CLIENTPROJECTNAME=;
58         %LET _SASPROGRAMFILE=;
59         
60         ;*';*";*/;quit;run;
61         ODS _ALL_ CLOSE;
62         
63         
64         QUIT; RUN;
65