topic Re: Advance Filter "Begins With" in SAS Procedures

Advance Filter "Begins With"

ismahero2 — Mon, 18 Nov 2013 18:07:04 GMT

I am trying to do an advance filter in a column I have named "Wages". This column is made up of random numbers of dollars amounts in dollar20. format.

I want to do a query were I get only the Wages that starts with the number 2. I have tried many options, but none of then have worked for me. I tried this formula but it didnt work either, Wages LIKE '2%'

I got an error saying it cant be done because is not character formatted. Any ideas?

Re: Advance Filter "Begins With"

Linlin — Mon, 18 Nov 2013 18:12:06 GMT

example:

data have;

input n;

cards;

;

data want;

set have;

if first(left(n))='2';

proc print;run;

Re: Advance Filter "Begins With"

Reeza — Mon, 18 Nov 2013 18:20:33 GMT

Assuming this is EG, which it sounds like you should post it in EG Forum

This would be a two step process in my opinion, 1, convert to character and then check if the first character is a 2. You can easily nest these functions though.

LinLin's code above could also be used in your query, but there are many other options, since it generates a conversion note.

substr(left(put(n, 8.)), 1, 1)='2'

Re: Advance Filter "Begins With"

ChrisNZ — Thu, 24 Sep 2015 12:18:51 GMT

Or to make it short while avoiding notes in the log:

first(cats(n))='2'

or even shorter

cats(n)=:'2'

Edit: Oops sorry I didn't see this was old. Why was it in the front page?