Hello SAS Community, I need help formating SAS to read the date properly from an excel sheet in order to answer the following questions: Average Start and End time in hours? What day of the week shows up the most frequent? I assume that once SAS has the format right, i can extract the date or time from the observations to find the average. I very much appreciate your help. Student, DATA: Under the Starttime (B) and Stoptime(C) column on excel, the date format is displayed as: 09/01/2015 0:04 Imported Excel to SAS using: Proc import out=citi.sept15
datafile="C:\445_695\Course_data\201509-citibike-tripdata.csv"
DBMS=csv replace;
getnames = yes;
run; SAS Proc Content: Alphabetic List of Variables and Attributes # Variable Type Len Format Informat 12 14 8 10 11 9 15 4 6 7 5 2 3 1 13 bikeid Char 7 $7. $7. birth_year Char 6 $6. $6. end_station_id Char 6 $6. $6. end_station_latitude Char 13 $13. $13. end_station_longitude Char 14 $14. $14. end_station_name Char 31 $31. $31. gender Char 3 $3. $3. start_station_id Char 6 $6. $6. start_station_latitude Char 20 $20. $20. start_station_longitude Char 20 $20. $20. start_station_name Char 31 $31. $31. starttime Char 19 $19. $19. stoptime Char 19 $19. $19. tripduration Char 6 $6. $6. usertype Char 12 $12. $12. SAS output for Starttime: 9/1/2015 00:00:00
... View more