Hi guys, I am a newbie to SAS/SQL coding, needed help on 1 of the coding block as below: proc sql; create table abc_123 as select Date-21916 format date9. as sub_date, "ABCD" as staff, "ABCDE" as product_name FORMAT=$CHAR200. LENGTH=200, sum('Total Pieces'n) as xyz, 0 as afyp from XXX where Date-21916>=&stdt and Date-21916<=&eddt group by 1,2,3 ;quit; The error received: 1. ERROR: The SUM summary function requires a numeric argument. 2. ERROR: The following columns were not found in the contributing tables: Date, 'Total Pieces'n. Although both of the tables is available in my excel file. Anybody expertise on this are greatly appreciated. TQ.
... View more
