proc sql noprint; connect to odbc as sqldb(&odbc_conn); create table CHCSS as select 'Project'n label='Project' length=200 format=$200. informat=$200., 'site'n label='Site', 'Subject'n label='Subject', 'UniqueIdentifier'n label='UniqueIdentifier' length=200 format=$200. informat=$200., 'CHCSCDAT_INT'n label='Health care contact (Non-asthma) Date' from connection to sqldb ( select Project as Project, SUBSTRING(Site,1,4) as Site, Subject as Subject, project + '-' + site + '-' + subject + '-' + LTRIM(RTRIM(InstanceName)) + '-' + cast(INSTANCEREPEATNUMBER as varchar(10)) + '-' + cast(RECORDPOSITION as varchar(10)) + '-' + cast(INSTANCEID as varchar(10)) + '-' + cast(FOLDERNAME as varchar(100)) + '-' + cast(DATAPAGEID as varchar(10)) + '-' + cast(RECORDID as varchar(10)) as 'UniqueIdentifier', Convert(varchar(10),CHCSCDAT_INT,21) as 'CHCSCDAT_INT' from dbo.V_D3250C00018_CHCSS where environmentname='PROD' and userid=57); disconnect from sqldb; quit; Here Unique identifier is not part of the V_D3250C00018_CHCSS table somehow we need to get the data for this column as combination of the other columns.Please suggest me whats need to be incurred in this program to avoid the error.
... View more