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;
... View more