Write and run SAS programs in your web browser

Error for creating new table

Reply
Contributor
Posts: 24

Error for creating new table

 

 

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;

Trusted Advisor
Posts: 1,459

Re: Error for creating new table

[ Edited ]

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;

Ask a Question
Discussion stats
  • 1 reply
  • 138 views
  • 0 likes
  • 2 in conversation