For me in a single byte session with WLATIN1 the Hex value is 97. filename inp "c:\temp\test_emdash_u8.csv"; data finaldata; em_dash='97'x; encoding="%sysfunc(getoption(encoding,keyexpand))"; infile inp encoding='utf-8' truncover; input mainline $10. ; hex=put(mainline,$hex20.); run; proc print data=finaldata(obs=1); run;     ... View more

The second INPUT is to read the next line and write it onto the end of the current line being written.  You should probably test whether or not it works when there are multiple extra end-of-lines embedded in the same record.   The last PUT is the end the line that is being written since the previous PUT statements had trailing @ which does not write the end-of-line characters.   Probably the simplest way to convert the |'s back into ' is to do it in the variables you end up with in your SAS dataset after you have successfully read in the fixed file.    Here is a data step that will replace all | with ' in all character variables in a SAS dataset. data apostrophe; set bar ; array _char_ _character_; do over _char_; _char_ = translate(_char_,"'",'|'); end; run; ... View more

Still think there may be something on your end. I run this, where I have taken the time to actually provide data sets: data table_A ; input ID; datalines; 1 2 3 4 ; data table_B ; input ID ; datalines; 2 4 9 ; data table_C; input ID; datalines; 2 3 8 ; proc sql; create table all_ids as select distinct coalesce(a.ID,b.ID,c.ID) as all_ID, (case when calculated all_ID=a.ID then 1 else 0 end) as in_A, (case when calculated all_ID=b.ID then 1 else 0 end) as in_B, (case when calculated all_ID=c.ID then 1 else 0 end) as in_C from table_A as a full join table_B as b on a.ID=b.ID full join table_c as c on a.ID=c.ID; quit; And get this result: Obs all_ID in_A in_B in_C 1 1 1 0 0 2 2 1 1 1 3 3 1 0 1 4 4 1 1 0 5 8 0 0 1 6 9 0 1 0 If you aren't then one (or possibly more) of your data sets is not as you present it. ... View more

To define new variables you need to know how many to create BEFORE that data step even starts running so there is no way the syntax you proposed could work (even if SAS modified the language to allow it).   You might try this method to create a macro variable first and then use that in the data step. data _null_; if 0 set have ; array cats category: ; call symputx('nvars',dim(cats)); stop; run; data want; set have ; array cats category: ; array price [&nvars] ; ...   ... View more

data have; input ID Start_date : ddmmyy10. end_date : ddmmyy10.; format Start_date end_date ddmmyy10.; cards; 011 1/1/1996 5/3/2020 003 2/1/2020 12/1/2020 ; data want; set have; array x{*} Jan2020 Feb2020 Mar2020 Apr2020; do j=1 to dim(x); x{j}=0; end; do i= Start_date to end_date; do j=1 to dim(x); if upcase(put(i,monyy7.))=upcase(vname(x{j})) then x{j}=1; end; end; drop i j; run; ... View more