topic Re: proc sql insert into values() question in SAS Programming

Doing mathematical operations with proc sql insert into values()

spirto — Tue, 20 Dec 2016 20:54:36 GMT

Hello all,

is it possible to use mathematical operations in the values() statement? For example

data have;
input x $ y z;
datalines;
a 1 2
b 3 4
;

proc sql;

insert into have values('c',5,6);
insert into have values('d',3*1,7-6);
quit;

The first insert statement works but the second does not. Is it possible to use mathematical operations?

Re: proc sql insert into values() question

SuryaKiran — Tue, 20 Dec 2016 19:20:57 GMT

data have;

input x $ y z;

datalines;

a 1 2

b 3 4

;

proc sql;

insert into have values('c',5,6);

insert into have values('d',%EVAL(3*1),%EVAL(7-6));

quit;

Re: proc sql insert into values() question

spirto — Tue, 20 Dec 2016 20:15:11 GMT

Thank you for your response! A followup question: how would I use the %EVAL function with date literals.

For example how can I do

insert into have values('d',%EVAL(3*1),%EVAL('29DEC2015'd-'28DEC2015'd));

Re: proc sql insert into values() question

ballardw — Tue, 20 Dec 2016 20:25:40 GMT

No reason to use %eval just use ('29DEC2015'd-'28DEC2015'd)

Though learning th INTCK function will help in the future.

Re: proc sql insert into values() question

SuryaKiran — Tue, 20 Dec 2016 20:25:37 GMT

proc sql;

insert into have values('c',5,6);

insert into have values('d',%EVAL(3*1),%SYSFUNC(INTCK(DAYS,'28DEC2015'd,'29DEC2015'd)));

quit;

Re: proc sql insert into values() question

spirto — Tue, 20 Dec 2016 20:32:45 GMT

When I tried using just the literals I got an error but using %sysevalf worked. I guess date literals are considered floating point values and not purely interger values

insert into have values('d',%eval(3*1),%sysevalf('29DEC2015'd-'28DEC2015'd));