I'm having this macro. The aim is to take the name of variables from the table dicofr and put the rows inside into variable name using a symput. However , something is not working correctly because that variable, &nvarname, is not seen as a variable. This is the content of dico&&pays&l varname descr var12 aza var55 ghj var74 mcy This is the content of dico&&pays&l..1 varname var12 var55 var74 Below is my code %macro testmac;  %let pays1=FR ;  %do l=1 %to 1 ;  data dico&&pays&l..1 ; set dico&&pays&l (keep=varname); call symput("nvarname",trim(left(_n_))) ; run ;  data a&&pays&l; set a&&pays&l; nouv_date=mdy(substr(date,6,2),01,substr(date,1,4)); format nouv_date monyy5.; run;   proc sql; create table toto (nouv_date date , nomvar varchar (12)); quit;  proc sql;  insert into toto SELECT max(nouv_date),'&nvarname' as nouv_date as varname FROM a&&pays&l WHERE (&nvarname ne .);   %end; %mend;  %testmac; A subsidiary question. Is it possible to have the varname and the date related to that varname into a macro variable? My man-a told me about this but I have never done that before. Thanks in advance. ... View more

I'm looking for advice on that one. Some context before. I have the following table on SAS. There are 711 observations and many more variables. Below is a sample from my table. date col1 col2 col3 jun14  0   0   0 may14  1   0   2 apr14  1   0   3 The table has no index, no primary key , nothing. The results I'm aiming for, is to know for a specific date, all the values of that column. date col1 col2 col3 may14  1   0   2 apr14  1   0   3 Example for May 14, I will have I'm running the following SQL query on it proc sql; select * from mytable where date < (input('may14',MONYY5.)); As you can imagine, the query is heavy when you have many variables and many observations. The query started 50 minutes ago and it is still running. I also thought about using a proc print proc print data=mytable; var date col1 col2 col3; where date = (input('may14',MONYY5.)); run; So here is my question. Is there an other way to have my results rather than through this query or the proc print? Do I need to have a datastep like a transpose , although if I'm doing a transpose, things would be different (see below). date jun14 may14 apr14 col1 0   1   1 col2 0   0   0 col3 0   2   3 Thanks in advance for your insight. ... View more