topic Re: Reading last non blank record from dat file in SAS Programming

Reading last non blank record from dat file

sfffdg — Fri, 19 Jan 2018 05:05:08 GMT

Hi ,

i am trying to get last non blank record from an external file.

I tried with

filename ocmd pipe "awk '/./{line=$0} END{print line}' /vfau/vfau_sit/sit05/datain/AppDirect/Landing/APPDIRECT_PROD_2018011105.dat"

and

filename ocmd pipe "tac /vfau/vfau_sit/sit05/datain/AppDirect/Landing/APPDIRECT_PROD_2018011105.dat | egrep -m 1 ."

But our company has no Goptions accesible..and i am getting error like

ERROR 23-2: Invalid option name GOPTIONS.

25 ! GOPTIONS NOACCESSIBLE;
____________
23
ERROR: Error in the FILENAME statement.
ERROR 23-2: Invalid option name NOACCESSIBLE.

Is there any other approach?

Re: Reading last non blank record from dat file

sfffdg — Fri, 19 Jan 2018 06:47:06 GMT

It is like reading XXXXX from the below file.

ADJJSHJBSJJAJS

SJHDBSJSJJSJ

XXXXX

Re: Reading last non blank record from dat file

BrunoMueller — Fri, 19 Jan 2018 07:25:35 GMT

All SAS statements end with a semicolon ";"

you are missing this

Re: Reading last non blank record from dat file

sfffdg — Fri, 19 Jan 2018 07:35:16 GMT

With semicolon only am getting the error as our company does not have access to goptions

Re: Reading last non blank record from dat file

BrunoMueller — Fri, 19 Jan 2018 07:43:29 GMT

I guess you are running this with SAS Enteprise Guide as the front end.

Please post the complete log as attachment or as a code block (the {} symbol in the editor)

Re: Reading last non blank record from dat file

RW9 — Fri, 19 Jan 2018 09:02:05 GMT

Goptions has nothing to do with the code you are running - which is a command line command which you do need access for. You can turn goptions off to get rid of this error:

https://communities.sas.com/t5/SAS-Enterprise-Guide/Turning-off-goptions-in-SAS-EG-code-node/td-p/139509

And docs:

http://support.sas.com/documentation/cdl/en/graphref/63022/HTML/default/viewer.htm#goptionschap.htm

However that will not solve your connection to the OS which may be turned off by default by your IT group - this is often the case.