This study utilises NaOH to treat composite cementitious materials containing aeolian sand and zeolite powders, which were used to replace 50% of the cement in aeolian-sand concrete (ASC). The mechanical properties of treated ASC considerably improved, especially when the NaOH dosage was 4% by mass. After curing this sample (denoted as AAZC-4) for 28 d, its compressive strength improved by 17.2% and its split tensile was increased by 16.3%. Potassium feldspar and montmorillonite in zeolite powder and SiO2 in the sand were decomposed by OH− and combined with other elements to generate various silicate gels and A-type potassium zeolite crystals inside the concrete. Microscopic examination showed that the gels and crystals intertwined to fill the pores, decreasing (increasing) the percentage of large (small) pores, thus optimising the pore structure. This substantially improved the mechanical properties of ASC. Freeze–thaw salt-intrusion tests showed that the extent of mass loss, degree of damage and loss of compressive strength of AAZC-4 were similar to those of ordinary concrete but were reduced by 36.8%, 19% and 52.1%, respectively, compared with those of ASC. Therefore, AAZC-4 has sustainable working performance in the chloride ion permeable environment in cold and arid areas.