Sorry about that and that you for being willing to help. The datalines below include my outcome which is dishero and the other variables in the proc tabulate. The Overall variable was created only as a header in the proc tabulate table. From what I have found in my research is that is may not be possible to add a p-value in table created by proc tabulate but I could be wrong. As I mentioned before I have a macro that was created by a statistician in my office that also creates tables and then I use the proc print with ods code I past above to output the table to word but I don't know how to modify that to only display yes values in the table and thus the tables turn out to be vary large. Thank you again and let me know if you need more information. DATA sample;    INPUT pid gender age hlthpln usesyr dishero race_new smoke;    DATALINES; a01  0  35  1  1  1 1   1 a02  1  50  1  1  0 3   1 a03  0  45  0  1  1 1   1 a04  1  24  1  0  0 2   0 a05  1  52  0  0  0 1   0 a06  0  44  1  1  1 3   1 a07  1  34  1  0  1 3   0 a08  1  40  0  1  0 2   1 a09  0  47  0  0  0 1   1 a10  0  35  1  0   1   2  0 ; ... View more

Thank you for the references to use, I have been using some of those and have been able to create tables just not in exactly the format I want. Most of my variables are dichotomous 1/0 with a few continuous and categorical variables. I put some sample data below, I am not sure this is what you were looking for. The structure is similar to my data but I prefer not to include my actual data as it is a large file.  pid=ID number, gender (1=male, 0=female), age (continuous), hlthpln (1=yes, 0=no), usesyr (1=yes, 0=no), heat (1=yes, 0=no), likeinf (1=white, 2=hispanic, 3=other). The outcome is heat. I would like the output to ideally look like what I posted above with a total column, columns for yes and no for outcome, an OR, 95% CI, and p-value. I would also be happy without the OR and 95% CI but those would be a bonus. I only want to report yes (1) values in the table for binary variables and mean (sd) for continuous variables. Ideally each variable would take up one row on the table except for categorical variables of course which would include all categories. I have to admit that this level of coding is above my knowledge and I have been able to create basic tables using ODS output but am trying to learn how to create more complicated tables and output. Let me know if you need more information and I will try to clarify. Thank you again, this forum has increased my SAS knowledge immensely. DATA sample;    INPUT pid gender age hlthpln usesyr heat racecate;    DATALINES; a01  0  35  1  1  1 1 a02  1  50  1  1  1 3 a03  0  45  0  1  0 1 a04  1  24  1  0  0 2 a05  1  52  0  0  1 1 a06  0  44  1  1  0 3 a07  1  34  1  0  1 3 a08  1  40  0  1  0 2 a09  0  47  0  0  0 1 a10  0  35  1  0   1   2 ; ... View more

Thanks for your reply. Yes you are correct, I am dealing with participant data and talking about writing journal articles. I often spend hours creating tables and have some of the process set up in SAS to create tables in word but still have to spend considerable time reformatting how I'd like them. I am just learning all of this and have been doing tons of research on creating nicer looking tables. I shouldn't have included the proc print above, they are from two separate sets of code. The proc print calls its data from a macro and creates nice tables but they are large and include tons of information that is not needed. I have been trying to modify that code to fit my needs but am having trouble. Ideally I'd like to create something like in the photo I attached but realize that may not be possible. If I can just get the all, yes, no, and a p-value in that manner that would be great. ... 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

They are a default in SPSS, and I agree with the sentiment that the SPSS format "features" for me generally create more of a headache then they are worth. The data can be exported as a text file and I tried that in the past and had an issue but can't remember what, I will have to try again. In short, we have very messy data due to survey programming issues and interviewer errors. Like you said we don't want to use the survey system defaults that were programmed because it creates missing data in SAS on categories we need. I've played around with several options but there are bugs in the QDS export process and the data doesn't always come out like we want it to. Another issue is that within our Other fields on the survey interviewers have used commas and semicolons so we can't export with those as separators. We have lots of issues and I am just trying to make the process the least burdensome as possible. Thanks again. I will see if a text file might work better and go from there. ... View more

As I was looking through the code I did notice a couple of errors with the code but I do also know they are not the cause of the messages I received in SAS. Actually, after restarting SAS it no longer gave me those errors so I was able to run the code after fixing some of the little mistakes with no problem. It was not just that one variable that was getting an error, there were several but I was only using that one as an example. Unfortunately the QDS program will not export to CSV, it gives the options for a SAS transport file or a SPSS file. There are other but none that I can use. There are issues with the way the program exports via a SAS transport file because it does not keep the original coding of the Don't know and Refuse to Answer variables. There is a way to specify the values for those but it does not do so correctly and it is a known issue and I was basically told by the company that they don't support SAS anymore because it is too expensive. The next best option was to export to SPSS because it keeps the original coding however, when importing the SPSS file without any modifications into SAS using proc import SAS drops the values for Don't Know and Refuse to Answer and makes them missing values. Unfortunately for some of our questions those are valid responses so we need that code. So far the best work around I have found is to export to SAS from SPSS and then using a libname statement to read in the SAS file. When I do that it keeps all the coding I need but then also gives me the [Skipped] I am having an issues with here. Those skipped should be missing. This is a long explanation that probably does not make any sense but because I was asked I figured I would elaborate. I have worked with several different ways to export the data from QDS and get it into SAS and this is the only way that I have come up with that works so far. Thank you all again for your time and information, it is greatly appreciated. ... View more

Yes, QDS is a survey program and when data is exported to SPSS is formatts skipped for the character variables in this manner. Unfortunately we cannot export directly to sas for numerous reasons I have been dealing with recently. I have run proc contents and I know  that the variable  whoshcko is a character variable. I only recently started having this issue because of having to change the way the data was created. Simiilar to how I  changed all of the -5 to missing, is there are way to convert all of the [Skipped] in my data to missing so I don't have this issue? ... View more

So I guess my question would actually be, how do I change all of the "[Skipped]" in my dataset to missing. I think that is something that SPSS does for character variables. I did something earlier with your help for the -5 and missing, but when I try to indicate _character_ in an array it doesn't seem to work. Thanks again. ... View more