CASE
WHEN LEFT(je.product_id__c, 1) = 'C' THEN
RIGHT(je.product_id__c, Len(je.product_id__c) - 1)
ELSE je.product_id__c
END AS Product_ID
Please I want the code and what are the Functions used for Left,Right and Len in HADOOP
@saikiran_nemani wrote:
CASE
WHEN LEFT(je.product_id__c, 1) = 'C' THEN
RIGHT(je.product_id__c, Len(je.product_id__c) - 1)
ELSE je.product_id__c
END AS Product_ID
Please I want the code and what are the Functions used for Left,Right and Len in HADOOP
This is a complete guess on my part as HADOOP can involve more than one DBMS.
I would start by trying standard SAS functions
Instead of LEFT try SUBSTR(je.product_id__c,1,1) to get the first character, LENGTH instead of LEN and SUBSTR(je.product_id__c, Length(je.product_id__c) - 1).
The SAS functions Left and Right justify variable values. If a variable contains " text" (2 leading spaces) then Left(var) = "text" so that the non-blank text starts in the first position. The Right function moves trailing blanks to the start: Right ("text ") = " text".
So I suspect your code may have given you errors related to too many parameters for the Left and Right functions.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.