Hello, Trying to load in data via INFILE and then create a new logical column. However, if my data contains ASCII characters (ex. ">", "-") I'm trying to filter on, I don't think SAS is reading it. For example, dataset = (Toyota, 35000, >12) (Toyota, 40000, 12) data car;
infile 'file path.csv'
input Car $ Miles Group $;
if Group = >12 then NewColumn = "a";
if Group = 12 then NewColumn "b";
run;
Expectation: (Toyota, 35000, >12, a) (Toyota, 40000, 12, b) Results: (Toyota, 35000, >12, ) (Toyota, 40000, 12, a) Can someone help explain this, been reading on character comparisons but not much describes how to handle these operations... Thanks!
... View more
