Here is my code that gives me the EXPRESSION IS INCOMPLETE BECAUSE AN OPERATION IS MISSING error. I've tried changing the || to a single | concatenation operator, but still the error persists.

DEFINE FILE HOLDFILE1

DISPLAY_NM2/A500 = 	IF CAR_NM IS NOT MISSING 
					THEN ' ['  || CAR_NM || ' - ' || ( IF SQNC_NB IS NOT MISSING THEN  BR_NB ELSE RGN_CD ) || '] ' ;

END  

Any ideas on what is missing?
Thank you!

This message has been edited. Last edited by: OnQuest,

You cannot embed a second IF statement within the first one.

Try something like this instead:

DEFINE FILE HOLDFILE1
DISPLAY_NMXX/A50 = IF SQNC_NB IS NOT MISSING THEN BR_NB ELSE RGN_CD;
DISPLAY_NM2/A500 = IF CAR_NM IS NOT MISSING THEN ' [' || CAR_NM || ' - ' || DISPLAY_NMXX || '] ' ELSE '';
END

Here is a format with a nested IF currently in production:

  
February/P12.3CB = IF '&MO2' GE '02' THEN 
                  (IF Month EQ '02' AND VERSIONS_KEY EQ 'ACT'    THEN Amount ELSE 0)
                 ELSE
                   IF Month EQ '02' AND VERSIONS_KEY EQ 'PLAN01' THEN Amount ELSE 0;

This "may" be the syntax you are looking for...

hth

And you're also missing the ELSE part.
The following DEFINE should syntactically correct (did not test it):

DEFINE FILE HOLDFILE1
DISPLAY_NM2/A500 = IF CAR_NM IS MISSING THEN '?' ELSE
                   IF SQNC_NB IS NOT MISSING THEN
                   ' ['  || CAR_NM || ' - ' || BR_NB || '] ' ELSE
                   ' ['  || CAR_NM || ' - ' || RGN_CD || '] ' ;
END

Thanks Everyone.
I replaced the nested If with a define variable and also added the missing else ' ' at the end.
that worked for me.