Are you trying to use SPT values to predict pile capacities? If so, Meyerhof presented a method to do this.
The ultimate end bearing (in tons) is estimated by
Qp=0.4 (N/B) Df Ap <= 4 N Ap for sand
and
Qp=0.4 (N/B) Df Ap <= 3 N Ap for nonplastic silt
where N is the SPT value corrected for hammer energy and overburden,
B is the pile width,
Df is the length of pile in the stratum,
Ap is the area of the pile point.
The ultimate unit skin friction in tons per square foot is estimated by
fs=N/50 <= 1 tsf