hi tom, Question 1: can we use macro functions in datastep (%scan,%sysfunc  etc) Question 2: need output datasets for list of values in a varible in a dataset. could you please  correct the program. *1. selecting all varible values from a varible in a table; proc sql; select distinct make into : makes separated by ' ' from sashelp.cars order by make; quit; *2.due to variable value  mercedes-benz compressing and printing the values; %let makes=%sysfunc(compress(&makes,'-')); %put &makes; *3.  sorting the dataset to get the different values of varibles one by one(group processing); proc sort data=sashelp.cars out=cars; by make; run; *4. want to get each distinct value from varible and making  output to corresponding dataset. data &makes; set cars; by make; retain i 1; if first.make  then   do;                 output scan("&makes",i,' ');   i+1;   end; run; ... View more

thanks a lot. No one give me this answer. till now i assumed that recall is for program editor only.  I am able to getting my code with recall in new editor. ... View more

hi, thanks. instead of the input(substr(name,1,1),8.)>=0,we  can use notdigit(substr(name,1,1)) --easy to understand . ... View more

hi, thanks  a lot. I thought some what wrong with the code due to color in editor. but executed fine and got the results. I don't know whether you observed my code or not. could you pls help me , bcaz I tried to do with first.make but unable to do. please observe my code and if you can please change my code ... View more

hi, I am using PC  sas. 1. I submitted a macro and mistakenly closed my enhanced editor. then i got this question how to retrive macro code.(session compiled macros) 2 . Assumed there is no straight forward way to get the source of macro from catalog(stored compiled macros) 3. Not a question because we are keeping source code (we have to keep source code anyway) if my assumption is wrong let me know and thanks for the reply. ... View more

thanks a lot. A problem can be solved in many ways. generally your approach is simple and easy to understand. ... View more

hi ksharp, please help me in this.(you can copy and paster this code as it is in your loca). got a macro for the same task which is working fine. but I want to understand where I am doing mistake in the following approach. * selecting all varible values from a varible in a table; proc sql; select distinct make into : makes separated by ' ' from sashelp.cars order by make; quit; * due to variable value  mercedes-benz compressing and printing the values; %let makes=%sysfunc(compress(&makes,'-'));  %put &makes;  *  sorting the dataset to get the different values of varibles one by one(group processing); proc sort data=sashelp.cars out=cars; by make; run; * want to get each distinct value from varible and making  output to corresponding dataset. data &makes; set cars; by make; retain i 1; if first.make  then   do;                 output scan("&makes",i,' ');   i+1;   end; run; ... View more

thanks. sorry to ask in this way. 1. if you can could you help me in changing my code to do the same task(without macro) with a datastep. 2. how to print macro varible vales one by one. ex: &let numbers =1 2 3; %put numbers;   --> need output like this.how to print this way/ 1 2 3 ... View more

Hi, thanks a lot. I understood. ... View more

hi, thanks a lot. i understood. ... View more