Hi All: New to this forum, but I am hoping can get a reply to my question fairly quickly. I have three datasets, pilot, full and recent. When I imported my datasets into SAS I had to remove the second row of the excel file, because the labels were in the 2nd row and they were messing up some code I was running. So, now I just have the variable names, fine. Anyhow, in trying to combine the datasets, it appears some variables are defined as both character and numeric (numeric in 2 of the datasets, character in one) so its not allowing me to combine the datasets into a single file using the set statement. I used this code in the hopes of standardizing the variable formats : data combined; set pilot full recent; VAR20=VAR20*1; VAR21=VAR21*1; /*etc*/ run; but its continuing with the error. The log is below. Any help would be appreciated! Thank you. 23338 data combined; 23339 set pilot full recent; ERROR: Variable VAR20 has been defined as both character and numeric. ERROR: Variable VAR21 has been defined as both character and numeric. ERROR: Variable VAR22 has been defined as both character and numeric. ERROR: Variable VAR23 has been defined as both character and numeric. ERROR: Variable VAR24 has been defined as both character and numeric. ERROR: Variable VAR25 has been defined as both character and numeric. ERROR: Variable VAR26 has been defined as both character and numeric. ERROR: Variable VAR236 has been defined as both character and numeric. ERROR: Variable VAR20 has been defined as both character and numeric. ERROR: Variable VAR21 has been defined as both character and numeric. ERROR: Variable VAR22 has been defined as both character and numeric. ERROR: Variable VAR23 has been defined as both character and numeric. ERROR: Variable VAR24 has been defined as both character and numeric. ERROR: Variable VAR25 has been defined as both character and numeric. ERROR: Variable VAR26 has been defined as both character and numeric. ERROR: Variable VAR28 has been defined as both character and numeric. ERROR: Variable VAR29 has been defined as both character and numeric. ERROR: Variable VAR30 has been defined as both character and numeric. ERROR: Variable VAR31 has been defined as both character and numeric. ERROR: Variable VAR32 has been defined as both character and numeric. ERROR: Variable VAR33 has been defined as both character and numeric. ERROR: Variable VAR34 has been defined as both character and numeric. ERROR: Variable VAR244 has been defined as both character and numeric. 23340 VAR20=VAR20*1; 23341 VAR21=VAR21*1; 23342 VAR22=VAR22*1; 23343 VAR23=VAR23*1; 23344 VAR24=VAR24*1; 23345 VAR25=VAR25*1; 23346 VAR26=VAR26*1; 23347 VAR28=VAR28*1; 23348 VAR29=VAR29*1; 23349 VAR30=VAR30*1; 23350 VAR31=VAR31*1; 23351 VAR32=VAR32*1; 23352 VAR33=VAR33*1; 23353 VAR34=VAR34*1; 23354 VAR236=VAR236*1; 23355 VAR244=VAR244*1; 23356 by UserId; 23357 run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 23354:8 23355:8 NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 23354:14 23355:14 NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.COMBINED may be incomplete. When this step was stopped there were 0 observations and 316 variables. WARNING: Data set WORK.COMBINED was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds
... View more