Your SAS programs, embedded in web apps and elsewhere

PROC CONTENTS can you Fuzzy seach for variables?

Reply
N/A
Posts: 0

PROC CONTENTS can you Fuzzy seach for variables?

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
SAS Super FREQ
Posts: 8,869

Re: PROC CONTENTS can you Fuzzy seach for variables?

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 1 reply
  • 158 views
  • 0 likes
  • 2 in conversation