Hi I have simple query in Proc SQL to look for all ID = 0, but my result included both 1 and 0.  The table is in a SQL Server. My query is below   Proc SQL;   Select StudentID from TBL_Student where StudentID = 0; quit;   I had tried to the different in where clause but did not work :   where put(studentid, $1.) = '0' where  put(studentid, best.) = 0 where studentid = put(0, $1.) where studentid = put(0, 1.)   Please help. ... View more

My date columns are showing in this format DDMONYYYY (ex. 08MAR2018) is showing 01JAN1960:06:00:23 in Oralce table.    I have try to add format=Date9. in the select statement to convert the date but it did not help.    Oracle : Column: DUE_DATE Date Type: Date   SAS Column: Due_Date Date Type: Date9.   My code:   PROC SQL; INSERT INTO admr.STAR_ACTION_ITEMS ( NAME_ID, DUE_DATE ) Select Name_ID, Due_Date FORMAT=Date9. FROM WORK.ACTION_ITEMS; QUIT;   How do you format the date in SAS correctly so that it show the actual date in Oracle table? ... View more