topic Analyzing Access tables in SAS in Microsoft Integration with SAS

Analyzing Access tables in SAS

deleted_user — Fri, 29 May 2009 15:01:02 GMT

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?

Re: Analyzing Access tables in SAS

sbb — Fri, 29 May 2009 15:25:59 GMT

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.

Scott Barry
SBBWorks, Inc.

Re: Analyzing Access tables in SAS

deleted_user — Fri, 05 Jun 2009 15:27:23 GMT

Hello,
What I mean by the whole question is that, suppose there is a question in access which says:
B1. Do you smoke?
Yes No

When I analyze this question in SAS, it gives me the output as:
# variable Type Len Format Informat Label
96 B1 Char 255 $255 $255 B1

But I want the question to appear over there....at the place where B1 is

Re: Analyzing Access tables in SAS

sbb — Fri, 05 Jun 2009 16:10:38 GMT

You will need to identify where (in Access) does the question text exist.

Scott Barry
SBBWorks, Inc.

Re: Analyzing Access tables in SAS

deleted_user — Tue, 09 Jun 2009 19:28:20 GMT

The question is in the form design and the references such as Q1 are in the table design...

Re: Analyzing Access tables in SAS

sbb — Tue, 09 Jun 2009 20:08:37 GMT

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.

Scott Barry
SBBWorks, Inc.

Re: Analyzing Access tables in SAS

deleted_user — Tue, 09 Jun 2009 20:23:41 GMT

Exactly right.....how to do that?

Re: Analyzing Access tables in SAS

andreas_lds — Wed, 10 Jun 2009 07:07:57 GMT

> Exactly right.....how to do that?

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.