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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1046 views
  • 0 likes
  • 1 in conversation