topic Re: ERROR: The function LOCATEC is unknown, or cannot be accessed. in SAS Enterprise Guide

ERROR: The function LOCATEC is unknown, or cannot be accessed.

Pank81 — Tue, 04 Apr 2017 19:34:15 GMT

Friends,

I am trying to run following code but keep getting ERROR message mentioned in subject line. Not sure what's wrong I am doing.

data _null_;
	team='Cleveland';
	tabelid = open('sashelp.baseball');
	rc=locatec(tabelid,varnum(tabelid,'Team'),team,'a');

	if (rc=0) then
		_msg_= 'There is no Team '||team||'.';
	else
		do;
			_msg_='There is Team '||team||'.';
		end;

	close=close(tabelid);
run;

Operating enviroment:

SAS 9.04.01M3

SAS EG 7.1

Linux platform

Any suggestion will be helpful.

Thank you,

Pankhil

Re: ERROR: The function LOCATEC is unknown, or cannot be accessed.

Astounding — Tue, 04 Apr 2017 20:07:25 GMT

Well, the error message is pretty explicit. SAS doesn't contain a function named LOCATEC. What is it you are trying to accomplish? Perhaps another tool will suffice?

Re: ERROR: The function LOCATEC is unknown, or cannot be accessed.

Pank81 — Tue, 04 Apr 2017 20:26:56 GMT

I am trying to read specific character string in SAS datasets. Just want to see if it is present or not. I tried using usual datasets but exploring if SCL can do same or not. Appricieate your reply.

Re: ERROR: The function LOCATEC is unknown, or cannot be accessed.

LaurieF — Tue, 04 Apr 2017 21:56:44 GMT

SCL can do it. A datastep, with dataset functions, cannot.

Re: ERROR: The function LOCATEC is unknown, or cannot be accessed.

Reeza — Tue, 04 Apr 2017 22:50:56 GMT

You can use the File functions, but you're better off querying the SASHELP.VCOLUMN table IMO.

Re: ERROR: The function LOCATEC is unknown, or cannot be accessed.

Pank81 — Fri, 07 Apr 2017 13:33:27 GMT

Sorry did not understand. Do you see any wrong with my logic? If so will you able to update code and show me? Thank you for reply.

Re: ERROR: The function LOCATEC is unknown, or cannot be accessed.

Reeza — Fri, 07 Apr 2017 13:42:45 GMT

We can't see what you're responding to if you don't quote the original text, or make it explicit.

What type of functionality are you trying to build here, checking for the presence of a variable or value of a variable in a dataset?

Do you need an interactive component?

Re: ERROR: The function LOCATEC is unknown, or cannot be accessed.

Pank81 — Fri, 07 Apr 2017 13:57:46 GMT

Hi Reeza,

Here is what I am trying to accomplish: I want to scan all .lst files present in one folder and look for string "NOTE: No unequal values were found. All values compared are exactly equal." and get the list.

One way I was thinking about doing was importing .lst file and look for above mentioned string. I can do using dataset and function but though about using SCL. So I was trying LOCATEC() to do so.

I hope I explain my dilema. I am sure there will be better and much easier way to do. Please share if you have any input on this.

Regards,

Pankhil

Re: ERROR: The function LOCATEC is unknown, or cannot be accessed.

Patrick — Sat, 08 Apr 2017 04:57:40 GMT

@Pank81

Below code searches all .lst files in folder c:\temp for "Note: No...." and writes a record to dataset found if there is a match.

Is that what you're after?

data found;
  length FoundInFile _CurrentFile $80;
  infile 'c:\temp\*.lst' filename=_CurrentFile truncover;
  input;
  if find(_infile_,'NOTE: No unequal values were found. All values compared are exactly equal','i');
  FoundInFile=_CurrentFile;
run;

You could easily extend the code by also adding the line number on which a match has been found.

Re: ERROR: The function LOCATEC is unknown, or cannot be accessed.

Pank81 — Mon, 10 Apr 2017 13:34:22 GMT

@Patrick: Thank you. Excatly what Dr odered...