SRY-box transcription factor 9 (SOX9) (OMIM 608160) is a transcription factor. The expression of SOX9 in pan-cancers and the regulation by small molecules in cancer cell lines are unclear. In the current study, we comprehensively analyzed the expression of SOX9 in normal tissues, tumor tissues and their matched healthy tissues in pan-cancers. The study examined the correlation between immunomodulators and immune cell infiltrations in normal and tumor tissues. Cordycepin (CD), an adenosine analog for SOX9 expression regulation, was also conducted on cancer cells. The results found that SOX9 protein is expressed in a variety of organs, including high expression in 13 organs and no expression in only two organs; in 44 tissues, there was high expression in 31 tissues, medium expression in four tissues, low expression in two tissues, and no expression in the other seven tissues. In pan-cancers with 33 cancer types, SOX9 expression was significantly increased in fifteen cancers, including CESC, COAD, ESCA, GBM, KIRP, LGG, LIHC, LUSC, OV, PAAD, READ, STAD, THYM, UCES, and UCS, but significantly decreased in only two cancers (SKCM and TGCT) compared with the matched healthy tissues. It suggests that SOX9 expression is upregulated in the most cancer types (15/33) as a proto-oncogene. The fact that the decrease of SOX9 expression in SKCM and the increase of SOX9 in the cell lines of melanoma inhibit tumorigenicity in both mouse and human ex vivo models demonstrates that SOX9 could also be a tumor suppressor. Further analyzing the prognostic values for SOX9 expression in cancer individuals revealed that OS is long in ACC and short in LGG, CESC, and THYM, suggesting that high SOX9 expression is positively correlated with the worst OS in LGG, CESC, and THYM, which could be used as a prognostic maker. In addition, CD inhibited both protein and mRNA expressions of SOX9 in a dose-dependent manner in 22RV1, PC3, and H1975 cells, indicating CD’s anticancer roles likely via SOX9 inhibition. Moreover, SOX9 might play an important role in tumor genesis and development by participating in immune infiltration. Altogether, SOX9 could be a biomarker for diagnostics and prognostics for pan-cancers and an emerging target for the development of anticancer drugs.