1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
| MLOGIC(TUTU2): %LET (variable name is VAR)
SYMBOLGEN: Macro variable COLUMN_TMP resolves to matrix_type_name
SYMBOLGEN: Macro variable J_ resolves to 1
MLOGIC(TUTU2): %LET (variable name is VAR)
6 The SAS System 10:45 Thursday, April 17, 2008
SYMBOLGEN: && resolves to &.
SYMBOLGEN: Macro variable VAR resolves to matrix_type_name__1
SYMBOLGEN: Macro variable MATRIX_TYPE_NAME__1 resolves to Plats cuisinés
MLOGIC(TUTU2): %PUT table:**&table_tmp**, Colonne_à_remplir-ou-à_vérifier:**&column_tmp**, contenu_colonne:**&var**,
colonne_identifiant:**&column_FK**
SYMBOLGEN: Macro variable TABLE_TMP resolves to matrix_type
SYMBOLGEN: Macro variable COLUMN_TMP resolves to matrix_type_name
SYMBOLGEN: Macro variable VAR resolves to 'Plats cuisinés'
SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.
SYMBOLGEN: Macro variable COLUMN_FK resolves to id_matrix_type
table:**matrix_type**, Colonne_à_remplir-ou-à_vérifier:**matrix_type_name**, contenu_colonne:**'Plats cuisinés'**,
colonne_identifiant:**id_matrix_type**
MLOGIC(SELECT_ID_FK): Beginning execution.
SYMBOLGEN: Macro variable TABLE_TMP resolves to matrix_type
SYMBOLGEN: Macro variable COLUMN_TMP resolves to matrix_type_name
SYMBOLGEN: Macro variable VAR resolves to 'Plats cuisinés'
SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.
SYMBOLGEN: Macro variable COLUMN_FK resolves to id_matrix_type
MLOGIC(SELECT_ID_FK): Parameter TABLE has value matrix_type
MLOGIC(SELECT_ID_FK): Parameter COLUMN_ has value matrix_type_name
MLOGIC(SELECT_ID_FK): Parameter VAR has value CARRE CARRE Plats cuisinés CARRE CARRE
MLOGIC(SELECT_ID_FK): Parameter COLUMN_IDENT has value id_matrix_type
MLOGIC(SELECT_ID_FK): %LET (variable name is IDENT)
MLOGIC(SELECT_ID_FK): %PUT Retour à la case départ
Retour à la case départ
MPRINT(SELECT_ID_FK): proc sql;
SYMBOLGEN: Macro variable COLUMN_IDENT resolves to id_matrix_type
SYMBOLGEN: Macro variable TABLE resolves to matrix_type
SYMBOLGEN: Macro variable COLUMN_ resolves to matrix_type_name
SYMBOLGEN: Macro variable VAR resolves to 'Plats cuisinés'
SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.
NOTE: Line generated by the macro variable "VAR".
14 'Plats cuisinés'
_
22
_____
202
MPRINT(SELECT_ID_FK): select id_matrix_type into :ident from LBMTST03.matrix_type where matrix_type_name='Plats cuisinés';
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, (, *, +, -, ALL, ANY, BTRIM, CALCULATED, CASE, INPUT, LOWER, PUT, SELECT, SOME, SUBSTRING,
TRANSLATE, UPPER, USER.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
MPRINT(SELECT_ID_FK): quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
MLOGIC(SELECT_ID_FK): %PUT ident is **&ident**
SYMBOLGEN: Macro variable IDENT resolves to
ident is ****
SYMBOLGEN: Macro variable IDENT resolves to
MLOGIC(SELECT_ID_FK): %IF condition %length(&ident)=0 is TRUE |
Partager