SAS to Access

[YJHappy]

If I have SAS database of
-- multiple tables
-- mixture of continuous, discrete, categorical, and string variable types
-- categorical variable values are integer values each having a value label (format)
-- each variable (i.e. table column) also has a label

When converted to Access what do I get?
-- multiple tables?
-- preservation of variable type (float, integer, string)
-- conversion of value formats?
-- conversion of variable labels?

Thanks!!

 

[klaz2002]

Why not try it. You use proc import with one table at a time. Generally, you have to 'play' with your data to get it to look exactly like it did in SAS.

I noticed that 99% of what I wanted ported fine.

If you have any questions on how to do this post them and hopefully someone will answer.
Klaz

 

[YJHappy]

Klaz2002, thank you so much!

 

[YJHappy]

SAS to Access

I use the code below to export data to Access:

proc export data=proto.final
outtable="final"
dbms=access replace;
database="G:\CD Data\ccdbase8.mdb";
run;

Then have error:
ERROR: Libname PROTO is not assigned.
ERROR: Export unsuccessful. See SAS Log for details.

What should I do now?

Thanks!

 

[ChrisW75]

You need a libname statement. Have you previously done any SAS programming? If not you'll need quite a bit of help.
If you have a libname statement, then check spelling, and check the log to make sure that the library was assigned successfully.