Virheilmoitus koskien yhteyttä Exceliin

nymanju — Tue, 29 Oct 2019 09:38:15 GMT

Hei

Meillä Helsingin sosiaali- ja terveystoimessa on SAS Enterprise Guide ajojen logissa ollut virheilmoitus alkaen siirtymisestä versioon 7.1. Aiemmin virheilmoitusta ei esiintynyt. Virheilmoitus on seuraava:

1 The SAS System 11:23 Tuesday, October 29, 2019

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='One-Way Frequencies';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8
9 ODS _ALL_ CLOSE;
10 ODS PROCTITLE;
11 OPTIONS DEV=PNG;
12 GOPTIONS XPIXELS=0 YPIXELS=0;
12 GOPTIONS XPIXELS=0 YPIXELS=0;
________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.

13 %macro HTML5AccessibleGraphSupported;
14 %if %_SAS_VERCOMP(9, 4, 4) >= 0 %then ACCESSIBLE_GRAPH;
15 %mend;
16 FILENAME EGSR TEMP;
17 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
18 STYLE=HTMLBlue
19 NOGTITLE
20 NOGFOOTNOTE
21 GPATH=&sasworklocation
22 ENCODING=UTF8
23 options(rolap="on")
24 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
25 FILENAME EGXLSSX TEMP;
26 ODS EXCEL(ID=EGXLSSX) FILE=EGXLSSX STYLE=Excel
27 OPTIONS (
28 EMBEDDED_TITLES="yes" EMBEDDED_FOOTNOTES="yes"
29 );
ERROR: Unable to load module 'SpreadsheetML' from template store!
ERROR: No body file. EXCEL(EGXLSSX) output will not be created.
30
31 LIBNAME TMP00001 "G:\HOTIDW2\SASUSER\pr_nymanju";
NOTE: Libname TMP00001 refers to the same physical library as ECI00001.
NOTE: Libref TMP00001 was successfully assigned as follows:
Engine: V9
Physical Name: G:\HOTIDW2\SASUSER\pr_nymanju
32
33 /* -------------------------------------------------------------------
34 Code generated by SAS Task
35
36 Generated on: Tuesday, October 29, 2019 at 11:24:45 AM
37 By task: One-Way Frequencies
38
39 Input Data: G:\HOTIDW2\SASUSER\pr_nymanju\th_avo2015_2018.sas7bdat [Hoitodw_EG]
40 Server: Hoitodw_EG
41 ------------------------------------------------------------------- */
42
43 %_eg_conditional_dropds(WORK.SORT);
44 /* -------------------------------------------------------------------
45 Sort data set G:\HOTIDW2\SASUSER\pr_nymanju\th_avo2015_2018.sas7bdat [Hoitodw_EG]
46 ------------------------------------------------------------------- */
2 The SAS System 11:23 Tuesday, October 29, 2019

47
48 PROC SQL;
49 CREATE VIEW WORK.SORT AS
50 SELECT T.tuoryhma
51 FROM TMP00001.th_avo2015_2018 as T
52 ;
NOTE: SQL view WORK.SORT has been defined.
53 QUIT;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

54
55 TITLE;
56 TITLE1 "One-Way Frequencies";
57 TITLE2 "Results";
58 FOOTNOTE;
59 FOOTNOTE1 "Generated by SAS (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%QSYSFUNC(TIME(),
59 ! NLTIMAP25.))";
60 PROC FREQ DATA=WORK.SORT
61 ORDER=INTERNAL
62 ;
63 TABLES tuoryhma / SCORES=TABLE;
64 RUN;

NOTE: There were 4525523 observations read from the data set TMP00001.TH_AVO2015_2018.
NOTE: There were 4525523 observations read from the data set WORK.SORT.
NOTE: PROCEDURE FREQ used (Total process time):
real time 1.61 seconds
cpu time 1.60 seconds

65 /* -------------------------------------------------------------------
66 End of task code
67 ------------------------------------------------------------------- */
68 RUN; QUIT;
69 %_eg_conditional_dropds(WORK.SORT);
NOTE: View WORK.SORT has been dropped.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

70 TITLE; FOOTNOTE;
71
72
73 %LET _CLIENTTASKLABEL=;
74 %LET _CLIENTPROCESSFLOWNAME=;
75 %LET _CLIENTPROJECTPATH=;
76 %LET _CLIENTPROJECTPATHHOST=;
77 %LET _CLIENTPROJECTNAME=;
78
79 ;*';*";*/;quit;run;
80 ODS _ALL_ CLOSE;
81
82
83 QUIT; RUN;
3 The SAS System 11:23 Tuesday, October 29, 2019

Re: Virheilmoitus koskien yhteyttä Exceliin

CaseySmith — Wed, 30 Oct 2019 03:40:02 GMT

Hi @nymanju,

I don't speak or read Finnish, but Google Translate translated your message pretty well to:
(En puhu tai luke suomea, mutta Google Translate käänsi viestin hyvin:)

Hey

We have had an error message in the SAS Enterprise Guide racing log for Helsinki Social and Health Care since moving to version 7.1. Previously, there was no error message. The error message is as follows:

12 GOPTIONS XPIXELS=0 YPIXELS=0;
________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.

That error looks like it doesn't recognize the GOPTIONS statement, which means you probably don't have SAS/GRAPH installed. You can avoid that error by checking the "Suppress graph option statements in generated code" option (in EG's Tools -> Options -> Results -> Graph).

(Tämä virhe näyttää siltä, että se ei tunnista GOPTIONS-käskyä, mikä tarkoittaa, että sinulla ei todennäköisesti ole SAS / GRAPH -sovellusta asennettuna. Voit välttää tämän virheen tarkistamalla "Sulje kuvaajavaihtoehtojen lausunnot luodussa koodissa" -vaihtoehto (EG: n Työkalut -> Asetukset -> Tulokset -> Kaavio).)

Casey

topic Virheilmoitus koskien yhteyttä Exceliin in Microsoft Integration with SAS

Virheilmoitus koskien yhteyttä Exceliin

Re: Virheilmoitus koskien yhteyttä Exceliin