topic Re: SAS Universal Viewer, Filter Editor, Advanced -- Item Specification? in SAS Programming

SAS Universal Viewer, Filter Editor, Advanced -- Item Specification?

NKormanik — Sat, 09 Jul 2016 10:02:30 GMT

I'd like to isolate members of a column (character data) that END with a 1.

_21801_0
_22601_3
_23101_1
_21601_0
_22604a_1
_22502_2
_23403_1
_22004_0

It looks like this might be possible using one of the Operators in the pull-down menu, toward the bottom of the list.

Appears totally Greek to me.

Any help greatly appreciated.

Nicholas Komanik

Re: SAS Universal Viewer, Filter Editor, Advanced -- Item Specification?

stat_sas — Sat, 09 Jul 2016 10:32:56 GMT

Hi,

Try this.

data want;
set have;
flag=substr(strip(reverse(members)),1,1);
if flag=1;
run;

Re: SAS Universal Viewer, Filter Editor, Advanced -- Item Specification?

NKormanik — Sat, 09 Jul 2016 10:52:05 GMT

Generated error:

The expression contains undefined function call substr().

Re: SAS Universal Viewer, Filter Editor, Advanced -- Item Specification?

Reeza — Sat, 09 Jul 2016 13:21:48 GMT

Try LIKE

like '%_1'

Re: SAS Universal Viewer, Filter Editor, Advanced -- Item Specification?

LinusH — Sat, 09 Jul 2016 14:42:04 GMT

Universal Viewer is primarily to do a quick browse of SAS files. Don't expect it to support any advanced filtering etc.
May I ask what you try to accomplish with this tool, since you take the time to start a thread around it...?

Re: SAS Universal Viewer, Filter Editor, Advanced -- Item Specification?

NKormanik — Sat, 09 Jul 2016 23:06:26 GMT

Reeza, error message:

Error in Like operator: the string pattern 'like '%_1'' is invalid.

Re: SAS Universal Viewer, Filter Editor, Advanced -- Item Specification?

NKormanik — Sat, 09 Jul 2016 23:09:29 GMT

LinusH, exactly that "a quick browse of SAS files"....

Seems no documentation on those later-in-the-list Operators.

They appear to come from some other universe, not SAS itself.

Re: SAS Universal Viewer, Filter Editor, Advanced -- Item Specification?

Tom — Sat, 09 Jul 2016 23:27:18 GMT

What version are you using?

The LIKE operator in the FILTER gui tool worked for me using % as a wildcard.

I am usng version 1.4 (1.4.1.1410)

Re: SAS Universal Viewer, Filter Editor, Advanced -- Item Specification?

NKormanik — Mon, 11 Jul 2016 01:10:02 GMT

Reeza, above, is basically correct. However, SAS Universal Viewer for some unknown reason wants to add to get it to work:

Convert([i_X],'System.String') like '%1'

That does the trick.

The other strange looking operators are still a mystery. If someone feels like explaining, please do. Perhaps at least the "IN" one?

Re: SAS Universal Viewer, Filter Editor, Advanced -- Item Specification?

Tom — Mon, 11 Jul 2016 01:16:19 GMT

SAS Universal Viewer is Windows tool. It is not really part of the SAS system. I assume the filtering syntax is driven by how that tool works. Most likely SAS adopted some existing package and hence the need to include Convert([i_X],'System.String') to reference a varaible instead of just using the variable name. Note that the GUI will generate that strange syntax for you so you do not need to type it yourself, just select the variable name from the list provided.