morinia
asked on
Substituting "19xx" with "18xx"
Experts,
I have a four-digit column (columna) that begins with either "18" or "19". If the column begins with "19", I would like to substitute with "18" for lookup purposes.
Can you tell me how to do this in SAS?
I have a four-digit column (columna) that begins with either "18" or "19". If the column begins with "19", I would like to substitute with "18" for lookup purposes.
Can you tell me how to do this in SAS?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
update table
set columna = columna - 1000
where columnA >=1900