Hi All, Dumb Question: I am currently facing an issue where the statement below confuses the dates when combining datasets. PROC SQL; CREATE TABLE WORK.Three AS SELECT T1.TR_PRICE, T1.TR_QUANTITY, T1.DT_PK_QUANTITY, T1.DATE, T2.tot_dt_pk_quantity, (TR_PRICE*(DT_PK_QUANTITY/tot_dt_pk_quantity)) AS TR_WEIGHTED_PRICE FROM WORK.One T1, WORK.Two T2 WHERE T1.DATE=T2.DATE ORDER BY T1.DATE; RUN; QUIT; In the T1 table, there are multiple values for the date (ex:40 lines of data for 01Jan2012), however in the T2 table there is only one value for the date. Then when the new table is created, the variable DT_PK_Quantity takes the correct values for JAN 1-2, but then starts spitting out random numbers (half right, half wrong) for the variable. There is no error statement, nor warning statement, just a confused table as the end product. Any help would be most appreciated! Best, Regulator
... View more