topic Re: Reading "<" ">" from excel file on linux in SAS Programming

Reading "<" ">" from excel file on linux

SP_SAS — Wed, 13 Feb 2019 18:17:25 GMT

Hi Guys,

I have an excel file that has many lines with date < x, or date > x or variable1 > 59 etc. This is all in excel concatenate function.

=CONCATENATE("(a<=6)","hello")

When I read this excel file using xlsx libname engine, I get " (a<=6)hello "

Is there a way around this.

Thanks,

data_null__ — Wed, 13 Feb 2019 16:53:22 GMT

How about this?

%let LT=<;

ballardw — Wed, 13 Feb 2019 18:25:33 GMT

Do you want the text of the formula or the resolved value?

If the later it may be easier to export the sheet as CSV and read that file.

SP_SAS — Wed, 13 Feb 2019 18:29:12 GMT

Resolved Value.

ErikLund_Jensen — Wed, 13 Feb 2019 20:54:04 GMT

Hi SP_SAS

The htmldecode function works here. It gived an ugly warning, but it does the decoding:

data _null_;
	a =  "       (a&lt;=6)hello     ";
	b = htmldecode(a);
	put b;
run;

114
115 data _null_;
116 a = " (a<=6)hello ";
WARNING: Apparent symbolic reference LT not resolved.
117 b = htmldecode(a); put b;
118 put b;
119 run;

(a<=6)hello

data_null__ — Wed, 13 Feb 2019 21:19:29 GMT

The warning is not from the function. The warning refers to line 116.

SP_SAS — Wed, 13 Feb 2019 21:19:45 GMT

Thanks.. That is a good work around..

ChrisNZ — Thu, 14 Feb 2019 03:15:52 GMT

The warning comes from the way you created your string.

a = ' (a<=6)hello ';

yields no warning.