Error for creating new table

Macy — Sun, 27 Nov 2016 21:23:59 GMT

hi, I am trying to create new table as below code, but it shows error like"ERROR: Unresolved reference to table/correlation name GCT."

can you help ?

PROC SQL;
CREATE TABLE GCT.ORGANICS_IMPUTED_ALL
AS
SELECT GCT.DemCluster,GCT.DemGender,GCT.DemReg, GCT.DemTVReg
,(CASE
WHEN (DemCluster = '') THEN 'U'
ELSE DemCluster
END) AS IMP_DemCluster
,(CASE
WHEN (DemGender = '') THEN 'U'
ELSE DemGender
END) AS IMP_DemGender
,(CASE
WHEN (DemReg = '') THEN 'U'
ELSE DemReg
END) AS IMP_DemReg
,(CASE
WHEN (DemTVReg = '') THEN 'U'
ELSE DemTVReg
END) AS IMP_DemTVReg
,(CASE
WHEN (DemCluster = '') THEN 1
ELSE 0
END) AS M_DemCluster
,(CASE
WHEN (DemGender = '') THEN 1
ELSE 0
END) AS M_DemGender
,(CASE
WHEN (DemReg = '') THEN 1
ELSE 0
END) AS M_DemReg
,(CASE
WHEN (DemTVReg = '') THEN 1
ELSE 0
END) AS M_DemTVReg

FROM GCT.ORGANICS;
QUIT;

Re: Error for creating new table

Shmuel — Mon, 28 Nov 2016 15:22:56 GMT

You need a LIBNAME statement to point to the library where your data exist or should be saved,

like:

libname gct "...path to the library ...";

also: in proc sql, when you use a form of X.y - then

X should be defined as reference to input dataset an

y is a variable name.

Your code:

SELECT GCT.DemCluster, GCT.DemGender, GCT.DemReg, GCT.DemTVReg

would be interpreted as: GCT is a reference

while DemGender DemReg DemTVReg - are variables in your input

defined by:

FROM GCT.ORGANICS;

that should be changed into:

FROM GCT.ORGANICS as GCT;

topic Re: Error for creating new table in SAS Studio

Error for creating new table

Re: Error for creating new table