I found the answer %let n=%sysfunc(countw(&vector)); %put &n.; ... View more

When I say that I need to careate SAS macro varaibles m0,m1,m2,m3...... there is a reason for that. I have input SAS data sets that are created every month. I need to use only tables for specific months that are defined by user. For example: %let start=1612; %let end=1803; It means that I will use following tables: tbl_1612,tbl_1701,tbl_1702....................tbl_1803.   %macro mmacro; %DO j=1 %TO &n.; PROC SQL; create table tbl2_&&m&j..   as select * from tbl_&&m&j.. where   out_condition........... ; QUIT; %end; %mend; %mmacro; ... View more

Hello Thanks for nice answers. I found the best code that is working well.   %let start=1701; %let end=1803; %let date_start=%sysfunc(inputn(&start.,yymmn4.)); %let date_end=%sysfunc(inputn(&end.,yymmn4.)); %put &date_start.; %put &date_end.; Data want_month; do j=0 to intck('month',&date_start.,&date_end.) ; ddate=intnx('month', &date_start., j, 's'); char_ddate = put(ddate, YYMMn4.); /*Var_Macro_name=compress('m'||put(J,2.));*/ Var_Macro_name='m'||strip(put(J,2.)); call symputx('m'||strip(put(J,2.)), char_ddate); output; end; Run;     I have 2 other problems: Problem1- I want to calculate number of months between start and end and create a sas macro variable with this value. One way to do it is working well. PROC SQL Noprint; select count(*) INTO:n from want_month ; QUIT; %put &n.;   I have tried to do it in open code but didn't succeed %let n=%sysfunc(intck('month',&date_start.,&date_end.)); /*Here we have a problem and we get in log a message: WARNING: An argument to the function INTCK referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range.*/     Problem2- I want to see sas macro varaibles values in log. %put &m0; %put &m1; %put &m2; %put &m3; %put &m4; %put &m14; %PUT &&m&n..; /*Here there is a problem and I don't get value of macro varaible m15*/ /*In log we can see : WARNING: Apparent symbolic reference M not resolved. &m 15.*/   ... View more

Sorry,Maybe I didn't explain it well We need to create parameters which are called  t1  ,t2,t3..etc. They will get following values t1=1503 t2=1506 t3=1509 t4=1512 .... t14=1806     ... View more

Hello I need this new parameter (number of arguments) in order to create a flexible SAS program . In this program user define only one parameter called  vector and  SAS create another parameter automatically(count parameter). As I see I only use count as a parameter and don't use it in data step. So actually I will only use code: %let count= %sysfunc(countw(&vector)); Thank you so much  and I have learned a lot from this forum and i love SAS         ... View more

Thank you! As I understand it is enough to write the code: %let count= %sysfunc(countw(&vector)); %put &count.;   What is the purpose of  the code: data _null_; count = countw("&vector"); put count=; run; ?? ... View more

Thank you so much! It is a very clever and nice solution. May I ask please: strip(put(x{1},best.)) What is the reason of using strip function here? What is the purpose of using best. format? ... View more