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?
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;
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;
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));
No reason to use %eval just use ('29DEC2015'd-'28DEC201
Though learning th INTCK function will help in the future.
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));
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.