Hi experienced users, I have a query on building my concept of looping through an existing column of a dateset which i would like to read through row by row through a loop read over rows. Eg: lets say the column is C(categorical) containing many subcategories like c1...c5 and each are of different counts. My task is to use loops [not by using retain or by group processing(first.c/last.c)] to get the counts and display all of them by %put once the loop exits .let's day %put &=c1 to %put &=c5 should be automated. if later the dataset comes with c1 to c10 it should be able to show %put =c1 to %put &=c10 automatically.   for doing this, I'm using the syntax, proc sql ;create table want as select count(C) from d1 groupby C;quit;also I have followed the exclusive advice given by @Kurt_Bremser  to solve this by retain statement .However, learning loops can be achieved if i can gt to perform the same by using loops. the above code gives me respective counts from c1 to c5, later i need to display it by automatically putting %put&= c1 to %put &=c5. the Cn subcategory part needs to be macrotised so that when the loop ends automatically.   I know @Kurt_Bremser asking you and other for a bit more support on this, the sole purpose is to solve a puzzle which can be build on this concept. Requesting you to help on this.   Thanks in advance.           ... View more

Hi Experts, I've a dataset containing a column named Category like below Category 1 1 1 1 1 2 2 2 2 2 3  3 3 3 4 4 4 4 4 ; I would like to create a macro that gives me output with its count like below 1- 5 2-5 3-4 4-5 ;   To do this i have taken %macro cat();  %let Received_data = %sysfunc(open(dataset.p1)); %If &Received_data %Then %Do; Proc freq data=dataset.p1; Table &col./out=outfile; run; %End; %mend cat(); Later from this step I'm trying to put it in to call symputx().    If anyone knows a better method to complete this please do help with your response.   ... View more

Hi Experts, I have a column such like below: 9  years 1  Week 0 6 year 1 0 Months 1  YEAR 7 MONTHS 5  YEARS 1  YEAR 6 MONTHS I've some places double or single blanks in the ist space. I would like to remove the ist occuring space(if there are 2 spaces, 1 space to nospace. How to do achieve this? one such example could be:  1 0 years should be  10 years.     ... View more