I have what I thought was a simple thing to do ,but ended up being more difficult. I have a global variable called &CY. that is = to "FY2017" and another &PERIOD. that is equal "11" (BOTH ARE CHARACTER VALUES). in a proc sql statement I'm trying to create a column called Period that concatenates the year part of FY2017 to the Period. below is the PROC SQL;
CREATE TABLE SAS_DATA.CUST_PVM_PTD_&PERIOD.&FY. AS
SELECT "CUSTPVM" AS DATA_SOURCE,"COMPONENTS" AS PRICING_TYPE,"COMPONENTS" AS PRICING_TYPE_LESS_RECON,
CATX(' ',SUBSTR(&CY.,2,4),&PERIOD.) AS PERIOD, I'm getting the following errors ERROR: The following columns were not found in the contributing tables: FY2017. This isn't working I'm not trying to concatenate and entire column, just want each row to say "201711"
... View more
