Thanks for the quick response! Much appreciated. data SQL_Lines; infile 'SQL_Dimensions_Test1.csv' dlm=',' dsd truncover firstobs=2 end=last; input ReportNo $ VarName $ ProvName $ RowLabel $ Map1 $ Map1_Oper1 $ Map1_Oper2 $ Map1_Value1 $ Map1_Value2 $ Map2 $ Map2_Oper1 $ Map2_Oper2 $Map2_Value1 $ Map2_Value2 $ Map1_NS $ Map2_NS $; length strSQL $10000; . . . strSQL = strip(strSQL) || " AND "... . . . retain strSQL; . . . run; Once the strSQL SQL statement has been assembed, what would be the Call Execute syntax to successfully run the SQL statement? Thanks!
... View more