Hi All, i am reading the varaible and then using that in like statment, while doing this during comparision gwtting wrong output because of space(variable length), coul you please help. data filesystemtable ; infile "/home/cfile/filesystem.txt" ; input filesystem :$30. ; call symput('filesystem',filesystem); run; data Library_of_filesystem; set mine; where path like "&filesystem%"; keep path Library_name libref; run; log: NOTE: There were 0 observations read from the data set WORK.MINE. WHERE path like '/sas/bau/pricing/ %'; you can see as variable length is less than 30 hence space getting addedd while comparing and not getting expected result, could you please help to remove the leading space?
... View more