Hi @Kurt_Bremser, Thanks your for your help. Due to policy issues i really cant share the % freq macro.How ever, I have modified the code by the reference that you have given, and checked that a perticular type of syntax error is coming for all the variables. kindly have a look to my full code and the log error. %macro test1(s=); %do kk=1 %to %sysfunc(countw(&s,%str( ),q)); %let varname =%scan(&s,&kk.); data dd_&varname.; OPTIONS SPOOL; call execute(cats('%nrstr(%freq(DATASET = b2,TRT=trt, TRTFMT =_NONE_ ,BYVAR = _NONE_,FMTVAR= _NONE_,COND= _NONE_,PCTTYPE= COL,P= _NONE_,DENOMNODISP = _NO_, delALLDS= _YES_,MAXnumLEN= 6,clopper_pearson = _NONE_ VAR=' "&varname.,_,OUTDS=d_&varname.))")); run; %end; %mend test1; %test1(s=a t s ); Error in the log: GOPTIONS ACCESSIBLE; 26 %test1(s=a t s); NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.DD_a may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.DD_a was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Line generated by the macro variable "VARNAME". 26 "a,_,OUTDS=d_a __________________ 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, ^=, |, ||, ~=. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.DD_t may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.DD_t was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Line generated by the macro variable "VARNAME". 26 "t,_,OUTDS=d_t ________________________ 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, 2 The SAS System 20:53 Thursday, September 5, 2019 GT, LE, LT, MAX, MIN, NE, NG, NL, OR, ^=, |, ||, ~=. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.s may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.DD_s was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds Kindly hep with your suggestion. ... View more

Hi @Kurt_Bremser, I'm getting a new type of error. Kindly have a look. VARNAME=a 180: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 180-322: Statement is not valid or it is used out of proper order. VARNAME=b 180: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 180-322: Statement is not valid or it is used out of proper order. ... View more

No need. Automatically it will be submitted. ... View more

Hi @Tom,   After executing the below command for 1 variable(EG: only sex ) by giving %test1(sex)  I'm getting i=sex s=sex  varname=sex.  %put AFTER FREQ &=i &=varname &=s ;  However when i execute the command %test1(sex aa bb cc xx yy) the nothing is printing in to the log file and the code is imply running with out stopping.    So,after trying  few options I have at least figured out that the problem starts after execution of ist variable (in this case it is Sex.) after that the do loop is not taking the second variable as mentioned in the example(aa). so, can you suggest something on this how to go about fixing this? Is there a way in capturing the output once it executes with the sex variable and get stored in a output then the loop goes back again to get the second variable, kindly let me know, it would be a great help.      Cheers, Ram ... View more

Hi @Tom , Many thanks for your quick responses to all my queries. I have somehow got the output by taking reference from your code that needs one step improvisation, which i would request you to have a look & comment.   %macro test1(s);    %do i=1 %to %sysfunc(countw(&s,%str( ),q));    %let varname =%scan(&s,&i.);    %freq(DATASET = b2,TRT=trt, TRTFMT =_NONE_ ,BYVAR = _NONE_,VAR=&varname.,OUTDS=d_&varname.);    %end; %put &varname; %mend test1;   %test1(sex); %test1(response); %test1(disease_status); %test1(diabetes_status);         when i execute the above code the for every categorical variables(eg: sex response disease_status etc.) especially when calling test1 macro for individually for each variable, I'm getting individual outputs named subsequently d_sex,d_response,d_disease_status  as i have mentioned in my code OUTDS=d_&varname. . Which is perfectly fine. But, the point is when i'm calling the macro like %test1(sex response disease_status diabetes_status) then it throws ambiguous errors.Is there a way out to fix this? I would need your help in improvising the code in a way that automatically all the outputs should get stored in one dataset at the moment it comes out of the loop by mentioning all the variables in a single macro call since i have more than 50 variables to pass on to the macro. I have tried using proc append as you have  suggested but, it's not working ,seems like loop is not keeping the 1st variable's output after running through the second one, by this logic when i tried to store the output in to a dataset (this_one)as you have mentioned in your last reply, it only stores the last variables's output. Hope my query is clear to you.    looking forward to get some ideas/help from you soon .   Cheers, Ram  ... View more

Hi @Tom, Your code looks quite convincing.I can see it has taken care everything,except 1 parameter OUTDS= option which I would request you to look upon. OUTDS= &out says all the variables eg: age sex height will have different output which further can be taken in to proc report as per the requirement. kindly refer to below written chunk of code: %freq(DATASET = Inputdataset , VAR=&variables, ,OUTDS= &out); Any additional inputs how to handle that? I have thought of doing something like this, kindly suggest if I'm going in a right direction %macro test1/parmbuff; %global cnt; %do i=1 %to %sysfunc(countw(&syspbuff,%str( ),q)); %let make=%scan(&syspbuff,&i,%str( ),q); %let out=&make&i; data y&i.; %freq(DATASET = b2,TRT=trt, ,BYVAR = _NONE_,VAR=&make.,LABEL= , FMTVAR= _NONE_,COND= _NONE_,PCTTYPE= COL,P= _NONE_,DENOMNODISP = _NO_, delALLDS= _YES_,MAXnumLEN= 6,clopper_pearson = _NONE_,OUTDS= &out.); run; %end; %mend; %let varlist=age sex height ; or do you suggest to write something like %let out=sex_output age_output height_output; if yes, to this then, i need your help in where to use this in code? Cheers, Ram ... View more

Hi @PaigeMiller, U guessed almost right. %FREQ is a project specific macro to take care of steps from getting a few things done including frequency and further restructuring.However, here my concern involves how to read categorical variables one by one(eg: lets say: sex race disease_status etc.) and i need to use those variables one by one to pass in to %freq(predesigned macro) to finally get different outputs and later combining them (pretty much like a set command to stack up output datasets one upon another. I know, that this thing can be done by using proc freq macro that you have mentioned but i want to use specifically the study designed macro out of compulsion. Hope you understand and suggest something on this. Cheers, Ram ... View more

Hi @Jagadish, I've tried executing your code , it didn't work. how ever i would like to understand reason behind your approach in using few functions. Kindly, help me with your response. 1. use/advantage of countw() inside the test macro. it's not getting resolved since i tried executing only few parts of your code: %macro test; %let variables=a b c d e; %let cnt=%sysfunc(countw(&variables,' ')); %mend test; %put &cnt; and result was : WARNING: Apparent symbolic reference CNT not resolved. ... View more