Hi, I am trying to store some values from a data set to a series of macro variables. Eg. the data is called temp, variable of interest is called name. proc sql noprint;       select count(*)              into: inn_nvar1       from temp;       select distinct name           into :inxvar1 - :inxvar&inn_nvar1.              from temp; quit; That is, I need to first store # of unique values of name, and then store each of them into macro variable of inxvar. However, I am keeping getting errors due to the use of &inn_nvar1. in second into. If I use accurate numbers, such as, inn_nvar1=39 and into :inxvar1 - :inxvar39. then there is no any errors. How can I still let the number of inxvar depends on inn_nvar1? Thanks, Sunny ... View more

Hi, I am trying to create a macro variable M that takes 1 if macro variable X takes values among a set of values defined by another macro variable Y. For example, %LET X=a;  %LET Y=a b c d e f g; Since a is one of values of Y, so macro variable M takes 1; otherwise, it takes 0. Can you please show me some quick way to write it? In STATA, it is something like Local M: list X in Y Thanks in advance. Sunny ... View more

Hi, I need to drop a bunch of variables ending with either _xx or _xy. How to do it in SAS? the colon ":" seems only working for starting letters. Thanks in advance. Thanks, Sunny ... View more

first, I need to resolve j ; then resolve &&CCp_reg&j.; and finally resolve CCp_&&CCp_reg&j.._xx. For example, %let j=3; %let CCp_reg3=testy; %let CCp_testy_xx=6; how can i get 6 by resolving CCp_&&CCp_reg&j.._xx. ? Thanks a ton in advance. Sunny ... View more

Hi, My SAS log file suddenly becomes the following. I need to know how many observations were read in and how many observations are saved in new data etc. How can I get them back in log file?  Many thanks. Sunny 1695      1696      data a; 1697       set out.regdata(keep=mtime todays_state tomorrows_state); 1698       if mtime<=mdy(4,1,2014) &  todays_state=0 & tomorrows_state in(0,1,4) 1698    & mtime<mdy(5,1,2014) ; 1699      run; 1700      quit; run; 1701      ODS _ALL_ CLOSE; 1702      ODS _ALL_ CLOSE; 1703      FILENAME WPSWBHTM TEMP; 1704      ODS HTML(ID=WBHTML) BODY=WPSWBHTM GPATH="R:\WPS\TEMP\sunyi\WPS Temporary Data\_TD4152" 1704    ! ; ... View more