In Data Prep, I have the following code which is working great: proc sql noprint;
create view TEMP_LASR_VIEW_1234 as
SELECT
X.EmployeeID,
X.EmployeeName
FROM
LASRLIB.MyTable X
quit;
/* Drop existing table */
%vdb_dt(LASRLIB.EMPLOYEES);
data LASRLIB.EMPLOYEES ( );
set TEMP_LASR_VIEW_1234 ( );
run; Now I want to alter this code to insert a hard-coded row in the same data prep script. I tried doing a UNION statement: SELECT
X.EmployeeID,
X.EmployeeName
FROM
LASRLIB.MyTable X
UNION
SELECT
0,
'EMPTY ROW' but i keep getting the " Syntax error, expecting one of the following: a quoted string, ',', AS, FORMAT, FROMSELECT X.EmployeeID, X.EmployeeName FROM LASRLIB.MyTable X" error. What is the correct syntax for using hard coded values in this scenario?
... View more