topic ERROR: The following columns were not found in the contributing tables in SAS Enterprise Guide

ERROR: The following columns were not found in the contributing tables

KubiK888 — Thu, 10 Aug 2017 20:54:56 GMT

I am using SAS EG to create and reformat a time variable, but it gave me this error "ERROR: The following columns were not found in the contributing tables: time_v2."

PROC SQL;
CREATE TABLE WORK.COOL_DATA_02 AS
SELECT t1.id,

/* time_v2, to correct typo */
(CASE
WHEN t1.id=3177 and t1.hospital_id=7 and t1.site_id=210
THEN "15:14"
ELSE t1.time
END) LABEL="Age_formatted" AS time_v2,

/* time_v3, to correct format */
(INPUT(time_v2, TIME5.)) AS time_v3

FROM WORK.COOL_DATA_01 t1;
QUIT;

Re: ERROR: The following columns were not found in the contributing tables

Reeza — Thu, 10 Aug 2017 20:57:24 GMT

If the field is being calculated in the same query you need to use the key word CALCULATED before it.

PROC SQL;
CREATE TABLE WORK.COOL_DATA_02 AS
SELECT t1.id,
/* time_v2, to correct typo */
(CASE
WHEN t1.id=3177 and t1.hospital_id=7 and t1.site_id=210
THEN "15:14"
ELSE t1.time
END) LABEL="Age_formatted" AS time_v2,
/* time_v3, to correct format */
(INPUT(CALCULATED time_v2, TIME5.)) AS time_v3
FROM WORK.COOL_DATA_01 t1;
QUIT;