Hi, I am trying to use support tables within SAS DI job within WHERE CLAUSE but I am getting syntax error near (SELECT under IN part: proc sql;
create view work.W20YF54Y as
select
PERIODE_MONTH_KEY,
MAIN_NUMBER,
DRM_TRAFFIC_CATEGORY,
SUM_of_TRAFFIC_NUMBER_EVENTS,
SUM_of_TRAFFIC_NET_AMOUNT,
SUM_of_TRAFFIC_NET_DISCOUNT_AMOU,
TRAFFIC_TOTAL_AMOUNT,
SUM_of_TRAFFIC_VOLUME_TOTAL,
SUM_of_TRAFFIC_DURATION,
TRAFFIC_LOCATION_ID,
TRAFFIC_LOCATION_DESC,
current_country_grouping_roam,
current_country_grouping_dest,
SUBSCRIPTION_KEY,
SUBSCR_USER_KEY,
SUBSCR_OWNER_KEY,
TWIN_DESC,
Ant_minutter
from &SYSLAST
where SOURCE_SYSTEM_KEY_3 IN (
SELECT SVALUE
FROM CONF_ARPU_01
WHERE SNAME='SOURCE_SYSTEM_KEY_3'
)
;
quit; Can someone advise me around this part: where SOURCE_SYSTEM_KEY_3 IN (
SELECT SVALUE
FROM CONF_ARPU_01
WHERE SNAME='SOURCE_SYSTEM_KEY_3'
) Error message: OTE: Libref ARPU01 was successfully assigned as follows:
Engine: BASE
Physical Name: /sasdata/Business/Prod/DI/t915925
3 data null;
4 set arpu01.W1LNYK37;
5 where SOURCE_SYSTEM_KEY_3 IN (
6 SELECT SVALUE
______
22
202
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant,
a missing value, -.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
7 FROM CONF_ARPU_01
8 WHERE SNAME='SOURCE_SYSTEM_KEY_3'
9 );
ERROR: Syntax error while parsing WHERE clause.
10 run cancel; How can I use subqueries in SAS DI? Thanks in advance!
... View more