Hi, I created few tables in access database and then analyzed in SAS by merging all together. The access database had questions for which I used say Q1, Q2, Q3.....while creating the forms. But when I analyzed it in SAS it gives me the output with Q1,Q2,Q3......But I want the whole question to appear in the output.
How do I do it?
You will need to explain what is meant by "...I want the whole question..." and better yet share what SAS code you have created (pasted into a post reply to the forum) and also share input (short data sample using instream DATALINES; approach) and output (expected) to help explain visually what it is that you are hoping to generate with your SAS application/program.
I expect you would want these data-strings for the questions to be available (and somehow related) to the appropriate response table column, not buried in a Access-internal form/table design file. I don't know what to suggest to you.
Hardly possible as long as you do not have the text in the data table. You could create an association table in Access mapping B1 to the appropriate text, that table can be used to create label-statements in sas.