https://communities.sas.com/t5/SAS-Procedures/Proc-SQL/m-p/68220#M19535 with $reverse when you see Pop, it is stored as poP<BR /> so reverse the quoted string in the sql syntax, like<BR /> where content_category = 'poP' ;<BR /> <BR /> If the comparison need not be case sensitive, use<BR /> where lowcase(content_category) = 'pop' ;<BR /> <BR /> why use the IN( ) ?<BR /> <BR /> peterC Wed, 02 Feb 2011 15:02:25 GMT Peter_C 2011-02-02T15:02:25Z https://communities.sas.com/t5/SAS-Procedures/Proc-SQL/m-p/68219#M19534 Hi All,<BR /> <BR /> I use :<BR /> <BR /> PROC SQL;<BR /> CREATE TABLE pop AS<BR /> SELECT *<BR /> FROM a <BR /> where content_category in('Pop');<BR /> run;<BR /> <BR /> I have used the format $REVERS35. for content_category. But when I run this code I do not get any output and no data is retreived even when there is data in 'a' that has 'Pop' in content_category.<BR /> <BR /> Kindly suggest.<BR /> <BR /> Regards,<BR /> K.Q Wed, 02 Feb 2011 14:50:38 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-SQL/m-p/68219#M19534 deleted_user 2011-02-02T14:50:38Z https://communities.sas.com/t5/SAS-Procedures/Proc-SQL/m-p/68220#M19535 with $reverse when you see Pop, it is stored as poP<BR /> so reverse the quoted string in the sql syntax, like<BR /> where content_category = 'poP' ;<BR /> <BR /> If the comparison need not be case sensitive, use<BR /> where lowcase(content_category) = 'pop' ;<BR /> <BR /> why use the IN( ) ?<BR /> <BR /> peterC Wed, 02 Feb 2011 15:02:25 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-SQL/m-p/68220#M19535 Peter_C 2011-02-02T15:02:25Z