DATA=MYLIB.FILTER_FOR_FLT_WT t2;
array flt_id {249} S_Fri_BR3303_SJCTPE S_Fri_BR3304_TPESJC S_Fri_BR3309_SJCTPE
DO n=1 TO 3;
PROC SQL;
CREATE TABLE MYLIB.FILTER_FOR_MER05 AS
SELECT t1.Wt_Knw_Ind,
t1.Pax_key,
t1.Bag_Cnt,
t1.Bag_Wt_Msr,
t1.Unit_Qual_Cd,
t1.Pool_Ind,
t1.Pax_Prm_Id,
t1.Pty_Rk,
t1.Flt_Id,
t1.Age,
t1.Horscp_Nm,
t1.Nat_Cd,
t1.Emp_Ind,
t1.Pax_Typ_Cd,
t1.Gndr_Cd,
t1.Title_Cd,
t1.Tvl_Seq,
t1.Seg_Id,
t1.Grp_Ind,
t1.Obd_Cbn_Cls_Cd,
t1.Seat_Nbr,
t1.Trf_Ind,
t1.Ffp_Carr_Cd,
t1.Ffp_Typ_Cd,
t1.Brdg_Stat_Desc
FROM MYLIB.MER05 t1
WHERE t1.Wt_Knw_Ind = flt_id{n};
QUIT; Hi, I have a problem with sas array value problem, i try to use several ways to get the value call flt_id (which tells the different flight) and I try to seperate the data with tons of passenger by the flt_id, but i cant access the array value and it keep showing ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, (, *, **, +, -, '.', /, <, <=, <>, =, >, >=, AND, EQ, EQT, EXCEPT, GE, GET, GROUP, GT, GTT, HAVING, INTERSECT, LE, LET, LT, LTT, NE, NET, NOT, OR, ORDER, OUTER, UNION, ^, ^=, |, ||, ~, ~=. I have try different syntax like ( ), [ ] but is not working at all, plz help. (By the way, I'm using SAS EG, and is there an easier way to automatically seperate the data with different flt_id? )
... View more
