topic Re: Trying to insert hard-code row into table in data prep in SAS Visual Analytics

Trying to insert hard-code row into table in data prep

VAinTestMode — Thu, 07 Feb 2019 19:08:50 GMT

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?

Re: Trying to insert hard-code row into table in data prep

LinusH — Fri, 08 Feb 2019 10:47:06 GMT

As I can recall, SELECT requires a FROM clause.

So you might need to refer to a row stored in an existing table, rather than hard code the values.

Re: Trying to insert hard-code row into table in data prep

VAinTestMode — Fri, 08 Feb 2019 16:40:03 GMT

Thanks @LinusH

I ended up referencing the table and then just capping the select statement to a single row to avoid multiple entries going into the table:

SELECT
   X.EmployeeID,
   X.EmployeeName
FROM
   LASRLIB.MyTable X

UNION

SELECT
   0,
   'EMPTY ROW'
FROM
   LASRLIB.MyTable X (obs=1)

WORKED!