Hi,   Whilst I am not going to spend the time looking through that mass of code I would firstly support Reeza in saying move to proc report, it has far more functionality.  You may also want to go through that code, as I don't see a reason for a wall of code to do what is relatively a simple output table.  Not to mention the code is very difficult to read, no indentations, code blocks unfinished, mixes of macro and datastep, muerous repeats of code etc. ... View more

With a data step you can make a workable update dataset with some like: data q1update;      set have (keep = <list of variables need to uniquely id respondent> q1openend);      where not missing(q1openend);      q1 = .;      /* if the original Q1 is text then use q1=''; so types match later. If the codes are longer than 8 you'll need a Length statement*/ run; q1 is a generic place holder for your variable name. With viewtable in Base SAS you can look at the data and enter the appropriate code. Then use your preferred method for update. ... View more

Sorry then, I misunderstood your question. The easiest that comes to my mind is first of all, sort data proc sort data=merged_visit2; by patid visitnum pfsy6mo; run; and create a variable with retain that count how many time this person has answered data aux_data; set merged_visit2 by patid visitnum pfsy6mo; retain num_answers; if first.patid then num_answers=0; if pfs6ymo=1 then num_answers=num_answers+1; if last.patid; run; doing this, you will get a only record by patid with the number of questions answered. Then with a proc freq or with sql you can get the number of patients that answers question. To know who reported I guess that you can transpose this dataset using as column the visits and transposing the pfsy6mo proc transpose data=merged_visit2 out=trans_data; by patid; id visitnum; var pfsy6mo; quit; ... View more

Today() is a FUNCTION that calls todays date from the computer. ... View more

Hi Reeza-I have actually be importing into SPSS and then out to SAS. It actually alleviated most of the data issues but I didn't know it could create the formats so I will try that. Like you said, the additional step is annoying but quicker than dealing with the issues another way. I am going to try ballardw's suggestion, it has definitely been a pain with the delimiters and the program create additional variables because of it. This has been a process and as a newer part time data manager on a study with lots of data issues I am learning a lot but the learning curve is steep! ha! I appreciate all of your help with the issues. Thanks! ... View more

You last statement is exactly what I want to do, clear the other variable when the option is used/re-categorized. If the other had more than 1, then it would not be re-categorized into the variable because these are all select one variables.  Will try some of the code and see what I can come up with. ... View more

you can control the decimal place with the help of formats, please try format var_name 8.2; this will control the decimal places Thanks, jagadish ... View more