I am reading in data from a excel sheet I cannot edit. SAS reads in the columns as CHAR and in order to do some calculations with them, I need to turn them into numeric. I tried a SQL modify statement,
/* Changing the columns from characters to numeric */
proc sql;
alter table race_sjc_mph_data
modify first_dose_administered format=comma15.;
quit;
but this results in this error.
151
152 /* Changing the columns from characters to numeric */
153 proc sql;
154 alter table race_sjc_mph_data
155 modify first_dose_administered format=comma15.;
ERROR: Character column first_dose_administered requires a character format specification.
NOTE: Table WORK.RACE_SJC_MPH_DATA has been modified, with 17 columns.
156 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
This is the current output properties of that table
![heyyou1_0-1637333211819.png heyyou1_0-1637333211819.png](https://communities.sas.com/t5/image/serverpage/image-id/65908i3D8AAD61D443AD3B/image-size/medium?v=v2&px=400)
From what I see in the data, there is not stray characters that would cause an error in parsing from character to numeric.
Thanks you