I really appreciate your help! Where would I put the 'By' statement in the code? This is my code: data dataset1.pce2; set dataset1.pce; Year = mdy (1,1,input(year, 4.)); format year year4.; run; proc print data=dataset1.pce2; run; This is from my log: 11 libname dataset1 'C:\Users\kjoseph4\Documents'; NOTE: Libref DATASET1 was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\kjoseph4\Documents 12 13 data dataset1.pce2; 14 set dataset1.pce; 15 Year = mdy (1,1,input(year, 4.)); 16 format year year4.; 17 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 15:23 NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 740 at 15:8 NOTE: There were 740 observations read from the data set DATASET1.PCE. NOTE: The data set DATASET1.PCE2 has 740 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 18 proc print data=dataset1.pce2; 19 run; NOTE: There were 740 observations read from the data set DATASET1.PCE2. NOTE: PROCEDURE PRINT used (Total process time): real time 0.37 seconds cpu time 0.35 seconds
... View more