I'll start by saying that pddate is in datetime20 format in the source: I should also note that this is in SAS EG. Here is the query: PROC SQL; CREATE TABLE WANT AS SELECT DATEPART(PDDATE) AS PDDATE FORMAT DATE9., [more variables that aren't relevant] FROM SOURCE WHERE PDDATE...
But first off, the today() function in your INTNX function should not be in quotation marks 🙂 The DATA to DATA Step MacroBlog: SASnrd 0 Likes Reply SkandaPannu Calcite | Level 5 Re: datepart and intnx in oracle pass through using proc sql Posted 11-21-2017 03:3...
(Date) <= '05NOV21'd Order by Date; quit; Contacts ***; Proc sql; Create Table SASCHART.Arias_Contacts_Trace AS SELECT Contact_Person_ID, CaseStatus, County_1 AS County label = "County", Created_On AS Date label="Date" FROM SASCHART.Arias_EpiCase_AriasContacts W...
Invalid (or missing) arguments to the DATEPART function have caused the function to return a missing Posted 09-19-2019 11:34 AM (1695 views) What is the effect of the above error/warning as far as the rest of the data is concerned once this error is encountered? Does ...
Set in; %Util_Convert_DT_Columns (column_list = &list); <== This is the macro variable containing the list from PROC SQL. Run; 0 Likes Reply Special offer for SAS Communities members Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the...