Hi Friends; I have a data set in excel format. When I imported it to sas studio, I converted it to "window comma seperated csv" format. But some of the numeric variables were imported as string, such as hba1c. I looked up the log and corrected the informat statement, and I can fix the problem. But I hope to find an efficient way that can avoid this problem. Also, when I import the excel table to STATA, I did not find the format problem. Thanks. data WORK.IMPORT1 ;
97 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
98 infile REFFILE delimiter = ',' MISSOVER DSD firstobs=2 ;
....
113 informat eos best32. ;
114 informat baso best32. ;
115 informat glucose best32. ;
116 informat hba1c $1. ;
117 informat crt best32. ;
118 informat egfr best32. ;
119 informat na best32. ;
........ data I have: hpbpid hct wbc rbc hba1c 19270818FM-B 0.44 6.6 4.55 19270818FM-B 0.38 5.2 4.41 5.9 19270818FM-B 0.38 7.3 4.33 5.9 19270818FM-B 0.42 5.7 4.98 5.8 19270818FM-B 0.39 11 4.49 5.8 19270818FM-B 0.41 8 4.84 5.8
... View more