What test should be conducted

[Shivi82]

Hi.

I am working on a data where there are 65000 observations. this is a transport delay data for various cities. So i need to find if there is a relation between the cities and the delay in days. T-test and ANOVA cannot be conducted as day is a numeric value and city is a categorical value.

Also would it be advisable if i aggrgate the data i.e. total of delay in days for a particular city and then run some descriptive analysis.

Please suggest.

[Ksharp]

Contingency Table Analysis - ChiSqr Test . 

Check proc freq + chisq option.