Hi Experts, I have a 2-part question and could use your help in reading in reading in another csv file. This time my trouble is reading in the date variable in with the proper formatting while using 'infile', instead of 'proc import', because of the Polish characters. The csv file that I need to read in has 3 variables. The dates are shown as mm/dd/yyyy (eg. 01/28/2021) but as you can see below, all the dates are missing. %let path=C:\Users\SAS\Poland; %let fname=Poland_cases.csv; options DATESTYLE=mdy; data master2; length loc_name $20.; format date mmddyy10.; infile "&path\&fname" encoding='utf-8' dsd firstobs=2 dlm=','; input loc_name $ infected @10 date anydtdte12.; run; For this file, I have to use encoding ='utf-8' or instead of encoding ='wlatin2' or else the Polish characters wouldn't read in properly. For reading in the date, how should I change my code? I've tried a few different things already. And the second part of my question is, will it be problematic for me to merge this file (encoding = 'utf-8') with another weekly file that was created using the daily raw data files that were read in using encoding='wlatin2'? Thanks very much!
... View more
