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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.