topic Re: Give value to a parameter in SAS Programming

Give value to a parameter

Jonison — Thu, 23 Jul 2020 19:20:32 GMT

Hello, Expert, I have a simple question. I established a query to store the value (which will be changed under specific condition), and then want to give this value to variable J which will be used by other Macros. I was using '&let' but system showed wrong. Can you give me some advice, still a newbee to SAS.

PROC SQL;
CREATE TABLE WORK.Number AS
SELECT (MAX(t1.'Primary ID'n)) FORMAT=BEST12. AS RowNum
FROM WORK.modeltraining_blocked t1;
QUIT;

%let j=int(number.Rownum/7);

proc print data=work.number.rownum;

Re: Give value to a parameter

PGStats — Thu, 23 Jul 2020 19:31:56 GMT

To put the value from a SQL query into a macro variable, use the INTO : clause

PROC SQL;
SELECT int( MAX('Primary ID'n) / 7) into : J
FROM modeltraining_blocked;
QUIT;

Re: Give value to a parameter

smantha — Thu, 23 Jul 2020 19:55:47 GMT

PROC SQL;
SELECT MAX(t1.'Primary ID'n/7) FORMAT=BEST12. into :RowNum
FROM WORK.modeltraining_blocked t1;
QUIT;

%put &rownum.;

Re: Give value to a parameter

Jonison — Thu, 23 Jul 2020 23:35:54 GMT

Thank you!

Re: Give value to a parameter

Jonison — Thu, 23 Jul 2020 23:36:20 GMT

thank you!