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 63 64 65
|
5539 proc sql ;
5540 select
5541 FACTURE_FACIALE_ID into :num_fact separated by ''','''
5542 from
5543 facture;
5544 quit ;
NOTE: The PROCEDURE SQL printed page 375.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
5545
5546 %let num_fact = %STR(%'&num_fact.%') ;
NOTE: Line generated by the macro variable "NUM_FACT".
5546 50434000','50199758','50612190
--- ---
49 49
NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS
release. Inserting white space between a quoted string and the succeeding
identifier is recommended.
5547 %put &num_fact.;
NOTE: Line generated by the macro variable "NUM_FACT".
5547 '50434000','50199758','50612190'
--- ---
49 49
'50434000','50199758','50612190'
NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS
release. Inserting white space between a quoted string and the succeeding
identifier is recommended.
5548
5549 proc sql ;
5550 create table detail_user as
5551 select
5552 *
5553 from
5554 BIM_FULL.V_USE_F_USAGE_VM_M
5555 where
5556 1=1
5557 and FACTURE_FACIALE_ID in ( &num_fact. );
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: Line generated by the macro variable "NUM_FACT".
5557 '50434000','50199758','50612190'
--- ---
49 49
-
22
-
76
NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS
release. Inserting white space between a quoted string and the succeeding
identifier is recommended.
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,
a datetime constant, a missing value, (, -, SELECT.
ERROR 76-322: Syntax error, statement will be ignored.
5558 quit ;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds |
Partager