I'm on a problem that is asking me to extract the date from a character variable(RegisteredDate) and change it to a numeric date variable with the DATE7 format. I need to create a new computed column called RegisteredDate_New. Which functions should I use to do this? I've been trying the DATE(), and INPUT() functions. Please let me know which functions would work for this problem. *This is the code from the Query builder of the Data file I'm working on. @jimbarbour @ballardw Where would I insert the Code? Again I'm a noob, so I really appreciate the help. Thank you. PROC SQL;
CREATE TABLE WORK.QUERY_FOR_FORECLOSURES AS
SELECT t1.APN,
t1.RegisteredDate,
t1.PropertyType,
t1.PropertyAddress,
t1.CouncilDistrict,
t1.Lender,
t1.LenderContact,
t1.LenderPhone,
t1.PropertyManagement,
t1.PropertyManagementContact,
t1.PropertyManagementAddress,
t1.PropertyMgmtContactPhone
FROM WORK.FORECLOSURES t1;
QUIT;
... View more
