I am using QDS and ACASI to collect data and one of the benefits is that when I export data from the program, formats are attached to the data file. How do I save the formats in new cleaned sas files that I create for analysis and to send to other people to use? Rigth now when I send someone the clean data I created and saved using a libname statement, none of the formats are attached so they have to delete them to use the file otherwise they get errors. Any suggestions would be greatly appreciated. ... View more

I posted about this previously but think I got confused and in turn confused others so I am going to re-try here. I am working on a longitudinal study collecting data at 5 points in time. We completed the first visit and created a new questionnaire for the second visit. However, our programmer made a mistake and if the question was the same, he created a new variable name instead of keeping it the same. What we wanted was the variable names to remain the same and for them to be identified by the variable "visit_number" to look at change over time. So I have an excel file that has all the variable names from visit 1, matched up with the variables names from visit 2 if the question was identical. What I need to do is convert the variable names from visit 2 to equal the variable name of visit 1 if the question was the same. Visit 1 varname               Visit 2 varname travel6mo                         trav6mo varaa                               varrra usedrg                             drguse So I need the visit 2 varnames to be replaces by those in visit 1. I know I can use the RENAME statement but I have about 900 variables that need to be renamed, that is why we created an excel file first, to match things up. Please let me know if there is a way to do this. Please let me know if you have any questions. ... View more

I am recoding variables and am having trouble with missing data. I was to make sure if data is missing, it stays missing in the new variables so I have coded like this: if (.<dg6fqad^=8) or (.<dg6fqd^=8) then newvar=1; if (dg6fqad=.) and (dg6fqd=.) then newvar=.; else newvar=0; if (.<dg6fqe^=8) then newvar1=1; if dg6fqe=. then newvar1=.; else newvar1=0; This codes makes missing data =0, how do I correct this? Thanks! ... View more

This is probably a really dumb/simple question but how do I combine variables in SAS? I have 2 variables, COPD and COPD1, some participants answered COPD and others answered COPD1 but the question is the same so I want to combine them to have complete responses for analyses. Thanks for your help. I know how to create a new variable from two variables but I can't remember how to just simply combine two variables. I need to take into account missing data as well, so If COPD=. and COPD1=. then new_var=. Thanks!  ... View more