PROC CONTENTS can you Fuzzy seach for variables?

deleted_user — Fri, 02 Nov 2007 14:36:57 GMT

I am working from time to time with very large datasets and I was wondering if there is a way to fuzzy search using PROC CONTENTS or some other method to list specific fields matching one criteria or another.

Of course the fallback way is to just do a CTRL-F but that is really inefficient when you have dataset with two thousand variables.

TX

Re: PROC CONTENTS can you Fuzzy seach for variables?

Cynthia_sas — Fri, 02 Nov 2007 14:56:37 GMT

Hi:
Do you mean something like this:
[pre]
proc sql;
create table work.varlist as
select libname, memname, name, type, label, format
from dictionary.columns
where upcase(libname) = 'SASHELP' and
upcase(memname) = 'SHOES' and
name contains 'ry';
quit;

proc print data=work.varlist;
title 'Variables from SASHELP.SHOES that contain the string "ry"';
run;
[/pre]
and the output from the job is:
[pre]
Variables from SASHELP.SHOES that contain the string "ry"

Obs libname memname name type label format

1 SASHELP SHOES Subsidiary char
2 SASHELP SHOES Inventory num Total Inventory DOLLAR12.

[/pre]

In this example, the search is for something about the variable NAME as the selection criteria.
On the other hand, you may actually want to find something about a variable value using a search -- which would require reading the actual file itself instead of dictionary.columns.

cynthia

topic Re: PROC CONTENTS can you Fuzzy seach for variables? in Developers

PROC CONTENTS can you Fuzzy seach for variables?

Re: PROC CONTENTS can you Fuzzy seach for variables?