BookmarkSubscribeRSS Feed
Wickywick
Calcite | Level 5

hi all, I'm trying to get the below code to run but keep getting the same error - any suggestions on what im doing wrong?

regards

code :

proc sql;

create table mrg_tst as

select AW.*

,AR.AR_ID

,AR.AR_LOCAL_ID

from All_WatchList AW

left join

API5AFS.AR_TRANSLATION AR

on AW.ACCT_NO=put(AR.AR_LOCAL_ID, $12.)

where AW.ACCT_NO=put(AR.AR_LOCAL_ID, $12.)

;

quit;

Error Log -

;*';*";*/;quit;run;

2 OPTIONS PAGENO=MIN;

3 %LET _CLIENTTASKLABEL=%NRBQUOTE(Code);

4 %LET _EGTASKLABEL=%NRBQUOTE(Code);

5 %LET _CLIENTPROJECTNAME=%NRBQUOTE(G:\Portfolio Management\Small Business Collections\SAS\Daily ESBC Account Refresh.egp);

6 %LET _SASPROGRAMFILE=;

7

8 ODS _ALL_ CLOSE;

NOTE: Some of your options or statements may not be supported with the Activex or Java series of devices. Graph defaults for these

drivers may be different from other SAS/GRAPH device drivers. For further information, please contact Technical Support.

9 OPTIONS DEV=ACTIVEX;

10 FILENAME EGHTML TEMP;

NOTE: Writing HTML(EGHTML) Body file: EGHTML

11 ODS HTML(ID=EGHTML) FILE=EGHTML ENCODING='utf-8' STYLE=EGDefault

11 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS/Shared%20Files/BIClientStyles/EGDefault.css")

11 ! ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/graph/v91/sasgraph.exe") NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation

11 ! ;

12

13 %gaccessible;

14 proc sql;

15 create table mrg_tst as

16 select AW.*

17 ,AR.AR_ID

18 ,AR.AR_LOCAL_ID

19 from All_WatchList AW

20 left join

21 API5AFS.AR_TRANSLATION AR

22 on AW.ACCT_NO=put(AR.AR_LOCAL_ID, $12.)

23 where AW.ACCT_NO=put(AR.AR_LOCAL_ID, $12.)

24 ;

ERROR: Expression using equals (=) has components that are of different data types.

ERROR: Expression using equals (=) has components that are of different data types.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

25 quit;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.01 seconds

cpu time 0.00 seconds

26

27 %LET _CLIENTTASKLABEL=;

28 %LET _EGTASKLABEL=;

29 %LET _CLIENTPROJECTNAME=;

30 %LET _SASPROGRAMFILE=;

31

32 ;*';*";*/;quit;run;

33 ODS _ALL_ CLOSE;

34

35

36 QUIT; RUN;

3 REPLIES 3
art297
Opal | Level 21

From your log I can't tell what the initial warnings are about but, regarding the proc sql code, you have two statements:

22 on AW.ACCT_NO=put(AR.AR_LOCAL_ID, $12.)

23 where AW.ACCT_NO=put(AR.AR_LOCAL_ID, $12.)

If aw.acct_no and ar.ar_local_id are both numbers, why are you converting the latter one to be character?  They must both be of the same type.

Wickywick
Calcite | Level 5

apologies should have been a bit clearer before,

ar.ar_local_id is character and aw.acct_no is numeric.

R_Win
Calcite | Level 5

proc sql; create table mrg_tst as select AW.* ,AR.AR_ID ,AR.AR_LOCAL_ID from All_WatchList AW left join API5AFS.AR_TRANSLATION AR on AW.ACCT_NO=input(AR.AR_LOCAL_ID, 12.) where AW.ACCT_NO=input(AR.AR_LOCAL_ID,12.) ;quit; Try this

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 4165 views
  • 0 likes
  • 3 in conversation