Solution for ERROR: Some character data was lost during transcoding in the dataset

When I search for the mentioned error I get the link solution provided administration oriented but developers do not have access. 


Please see my solution below

proc options option=config; run;
proc options group=languagecontrol; run;

/* Show the encoding value for the problematic data set */
%let dsn=item_information_may16;
%let dsid=%sysfunc(open(&dsn,i));
%put &dsn ENCODING is: %sysfunc(attrc(&dsid,encoding));



/*Renaming item desc file  (encoding=any) allowed reading****************************/

data tmp.item_info_curr;
set hc.item_information_may16 (encoding=any);
run;

/*gave error*/
data item_info_curr;
set item_information_may16;
run;

Comments

Popular posts from this blog

How to check whether a SAS dataset exist or not and throw an error in the log ?

2018 plan for getting expertise in Machine Learning and Deep Learning