It kind of worked, the years for the respective serial numbers came out as follows  ----> 2013 = 2073 ----> 2015 = 2075  ----> 2016 = 2076 ... View more

Also why is SAS reading Date as a character variable ? ... View more

I used the code you sent me, and sas Log stated this:    1320 proc datasets lib=grad nolist; 1321 modify mosdata; ERROR: You are trying to use the numeric format DATE with the character variable trap_coll_date in data set GRAD.MOSDATA. 1322 format Trap_Coll_Date date9.; /* or any other SAS date format */ 1323 run;    is this because sas is reading dates as a character variabel instead of a numberic variable ?   ... View more

My Code-  proc import datafile="C:\Users\okund\Desktop\Practicum Documents\2016MosqDataEntry.xlsx" out=Grad.mosdata dbms=xlsx replace; getnames=yes; run; ... View more

Alright, what is the procedure to adjust dates within excel spread sheets in sas  do I type an informat line before typing a format ?  ... View more

Specifcally looking at the dates column, you will find that some of the output is in serial number format and some show actual dates.  ... View more

Yes it appears like that, I've tried using the format options to convert the serial numbers to dates. The problem is not all the dates  were imputed into Excel as serial numbers. Some values appear as dates when formated options were changed from date to general.    This is the SAS output after importing the excel file ... View more

Wanted Variable to be corrected Trap_Coll_Date; Example: ---> 41503 is stored in excel, but it represents 8/17/2016    Some dates are stored as serial numbers, some dates are stored as regular dates    I can convert the serial numbers in excel into dates, but importing it to SAS reveals the original serial number from Excel. How to I fix this ?  ... View more