BookmarkSubscribeRSS Feed
Cello23
Quartz | Level 8

Recently I installed win10 (before win 7 32-bit), replace sas 9.2 to 9.4.

Now, I have a problem with a query, in this step:

proc sql;  
  update  ATM_EXPO.Totale_ope_pre_avg_a
   set SINTESI='PRELIEVI'
   where   SINTESI='SI' ;
   quit;

i have this error:

537           proc sql;
538           update  ATM_EXPO.Totale_ope_pre_avg_a
539           set SINTESI='PRELIEVI'
540           where   SINTESI='SI' ;
ERROR: File ATM_EXPO.TOTALE_OPE_PRE_AVG_A cannot be updated because its encoding does not
       match the session encoding or the file is in a format native to another host, such as
       WINDOWS_64.
541           quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL ha utilizzato (tempo totale di elaborazione):
      real time           0.11 seconds
      cpu time            0.04 seconds

how can i solve it ?

Thank so much

1 REPLY 1
Cello23
Quartz | Level 8

I have resolver:

	        DATA ATM_EXPO.Totale_ope_pre_avg_a; 
		 SET ATM_EXPO.Totale_ope_pre_avg_a ;
		 IF SINTESI='SI' THEN SINTESI='PRELIEVI';
		 RUN;

thankìs