First step import a CSV file to a SAS table, then the format is: Name Type Long Format Format L Header 6 Flight_date Number 8 BEST12.0 F12.0 And the data is: Flight_date 20110607 20110504 I convert them using the input function: IMPW.flight_date 2=input(IMPW.flight_date,yyyymmdd.10) But it doesn’t work!! Question 1: I have to create the column IMPW.flight_date2 before to create the input function. But, where do you create the new column? Question 2: Do you know the input function to convert from number to date (ddmmyyyy)? The 2nd table has the next data format: Name Type Long Format Format L fecha_vuelo Date 4 DDMMYY10.0 F12.0 And the data is: fecha_vuelo 07/05/2011 09/06/2011 11/06/2011 Thanks.
... View more