read paradox database files

[ANLYNG]

Hi,

I need to access data which is in paradox format. I use the proc import (have tried by libname) but I get errors and no data.

Do you have any ideas how to access the data ? or is it not possible (we run sas on windows, 9.4)

 Thanks in advance.

142  PROC IMPORT OUT= WORK.MYDATA

143              DATAFILE= "C:\YYYY\FFFF\MYDATA.DB"

144              DBMS=PARADOX REPLACE;

NOTE:    Variable Name Change...   -> _1

NOTE:    Variable Name Change...   -> _2

NOTE:    Variable Name Change...   -> _3

NOTE:    Variable Name Change...   -> _4

NOTE:    Variable Name Change...   -> _5

NOTE:    Variable Name Change...   -> _6

NOTE:    Variable Name Change...   -> _7

NOTE:    Variable Name Change...   -> _8

NOTE:    Variable Name Change...   -> _9

NOTE:    Variable Name Change...   -> _10

NOTE:    Variable Name Change...   -> _11

NOTE:    Variable Name Change...   -> _12

NOTE:    Variable Name Change...   -> _13

NOTE:    Variable Name Change...   -> _14

NOTE:    Variable Name Change...   -> _15

NOTE:    Variable Name Change...   -> _16

NOTE:    Variable Name Change...   -> _17

NOTE:    Variable Name Change...   -> _18

NOTE:    Variable Name Change...   -> _19

NOTE:    Variable Name Change...   -> _20

NOTE:    Variable Name Change...   -> _21

NOTE:    Variable Name Change...   -> _22

NOTE:    Variable Name Change...   -> _23

NOTE:    Variable Name Change...   -> _24

NOTE:    Variable Name Change...   -> _25

NOTE:    Variable Name Change...   -> _26

NOTE:    Variable Name Change...   -> _27

NOTE:    Variable Name Change...   -> _28

NOTE:    Variable Name Change...   -> _29

NOTE:    Variable Name Change...   -> _30

NOTE:    Variable Name Change...   -> _31

NOTE:    Variable Name Change...   -> _32

NOTE:    Variable Name Change...   -> _33

NOTE:    Variable Name Change...   -> _34

NOTE:    Variable Name Change...   -> _35

NOTE:    Variable Name Change...   -> _36

NOTE:    Variable Name Change...   -> _37

NOTE:    Variable Name Change...   -> _38

NOTE:    Variable Name Change...   -> _39

NOTE:    Variable Name Change...   -> _40

NOTE:    Variable Name Change...   -> _41

NOTE:    Variable Name Change...   -> _42

NOTE:    Variable Name Change...   -> _43

NOTE:    Variable Name Change...   -> _44

NOTE:    Variable Name Change...   -> _45

NOTE:    Variable Name Change...   -> _46

NOTE:    Variable Name Change...   -> _47

NOTE:    Variable Name Change...   -> _48

NOTE:    Variable Name Change...   -> _49

NOTE:    Variable Name Change...   -> _50

NOTE:    Variable Name Change...   -> _51

NOTE:    Variable Name Change...   -> _52

NOTE:    Variable Name Change...   -> _53

NOTE:    Variable Name Change...   -> _54

NOTE:    Variable Name Change...  1 -> _1_1

NOTE:    Variable Name Change...  2 -> _2_1

NOTE:    Variable Name Change...  3 -> _3_1

NOTE:    Variable Name Change...  4 -> _4_1

NOTE:    Variable Name Change...  5 -> _5_1

NOTE:    Variable Name Change...  6 -> _6_1

NOTE:    Variable Name Change...  1 -> _1_2

NOTE:    Variable Name Change...  1 -> _1_3

NOTE:    Variable Name Change...  1 -> _1_4

NOTE:    Variable Name Change...  2 -> _2_2

NOTE:    Variable Name Change...  3 -> _3_2

NOTE:    Variable Name Change...  4 -> _4_2

ERROR: The variable name  is illegal for file WORK.MYDATA.DATA.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

      real time           0.10 seconds

      user cpu time       0.06 seconds

      system cpu time     0.03 seconds

      memory              646.03k

      OS Memory           18672.00k

      Timestamp           10/11/2017 12.27.26 e.m.

      Step Count                        24  Switch Count  0

145

146  RUN;

[kiranv_]

Looks like variable names  in your dbms does not adhere to SAS variable names.

Try using options validvarname option. below is the link for this option.

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000279245.htm

[ANLYNG]

is stills fails with the options -but give maybe more information about the variables:

13

14 * denne importerer paradox filer;

15 options validvarname=v7;

16 PROC IMPORT OUT= WORK.MYDATA

17 DATAFILE= "C:\YYYY\TTTT\MYDATA.DB"

18 DBMS=PARADOX REPLACE;

NOTE: Variable Name Change... -> _1

NOTE: Variable Name Change. ë‹Ë·Ó¸ÿ -> VAR3

NOTE: Variable Name Change... -> _2

NOTE: Variable Name Change. » -> __

NOTE: Variable Name Change... -> _3

NOTE: Variable Name Change... -> _4

NOTE: Variable Name Change. ¿ -> _

NOTE: Variable Name Change... -> _5

NOTE: Variable Name Change... -> _6

NOTE: Variable Name Change. €ë·Ó·Ã‹û‹Ë» -> VAR11

NOTE: Variable Name Change... -> _7

NOTE: Variable Name Change... -> _8

NOTE: Variable Name Change. L‹E§f
E"fA‰@‹ÃfA‰A‰HA‰xH‹MÿH -> VAR14

NOTE: Variable Name Change... -> _9

NOTE: Variable Name Change... -> _10

NOTE: Variable Name Change. HÄ  -> VAR17

NOTE: Variable Name Change... -> _11

NOTE: Variable Name Change... -> _12

NOTE: Variable Name Change. A_A^A]A\_^]ÃÌÌH‰\$UVWATAUAVAWH -> VAR20

NOTE: Variable Name Change... -> _13

NOTE: Variable Name Change... -> _14

NOTE: Variable Name Change. H‹Ùp -> VAR23

NOTE: Variable Name Change... -> _15

NOTE: Variable Name Change... -> _16

NOTE: Variable Name Change. ‰U³º -> VAR26

NOTE: Variable Name Change... € -> __1

NOTE: Variable Name Change... -> _17

NOTE: Variable Name Change. E3íf#ÊDzÿD‰EÇfA#ÿH‰]¿ÇE÷ÌÌÌÌÇEû -> VAR29

NOTE: Variable Name Change... -> _18

NOTE: Variable Name Change. E…Ò….
-> VAR31

NOTE: Variable Name Change... -> _19

NOTE: Variable Name Change. f;ÊADÀfÇC
0fD‰+ˆCDˆké’ -> VAR33

NOTE: Variable Name Change... -> _20

NOTE: Variable Name Change. fA;ÿ…
-> VAR35

NOTE: Variable Name Change... ¾ -> __2

NOTE: Variable Name Change... -> _21

NOTE: Variable Name Change... -> _22

NOTE: Variable Name Change. €fD‰D;ÎuE…Òt9Aºá-r2HKLsG -> VAR39

NOTE: Variable Name Change... -> _23

NOTE: Variable Name Change... º -> ___1

NOTE: Variable Name Change... -> _24

NOTE: Variable Name Change... -> _25

NOTE: Variable Name Change. èÔÿÿ…À„¯ -> VAR44

NOTE: Variable Name Change... -> _26

NOTE: Variable Name Change... -> _27

NOTE: Variable Name Change. E3ÉE3À3Ò3ÉL‰l$ èÎÿÿÌf…Ét;Aù -> VAR47

NOTE: Variable Name Change... -> _28

NOTE: Variable Name Change... -> _29

NOTE: Variable Name Change. Àu2E…ÒunHKL&G -> VAR50

NOTE: Variable Name Change... -> _30

NOTE: Variable Name Change. ARèÕÓÿÿ…Àt7E3ÉE3À3Ò3ÉL‰l$ èMÎÿ -> VAR52

NOTE: Variable Name Change... -> _31

NOTE: Variable Name Change. ARèžÓÿÿ…Àu¸ -> VAR54

NOTE: Variable Name Change... -> _32

NOTE: Variable Name Change... ¿1 -> _1_1

NOTE: Variable Name Change... ¿2 -> _2_1

NOTE: Variable Name Change... ¿3 -> _3_1

NOTE: Variable Name Change... ¿4 -> _4_1

NOTE: Variable Name Change... ¿5 -> _5_1

NOTE: Variable Name Change... ¿6 -> _6_1

NOTE: Variable Name Change... 1 -> _1_2

NOTE: Variable Name Change... 1 -> _1_3

NOTE: Variable Name Change... ¾1 -> _1_4

NOTE: Variable Name Change... ¾2 -> _2_2

NOTE: Variable Name Change... ¾3 -> _3_2

NOTE: Variable Name Change... ¾4 -> _4_2

ERROR: The variable name is illegal for file WORK.MYDATA.DATA.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.14 seconds

user cpu time 0.07 seconds

system cpu time 0.06 seconds

memory 647.90k

OS Memory 12008.00k

Timestamp 11/11/2017 08.32.32 f.m.

Step Count 6 Switch Count 0

[Tom]

Are you sure it is a paradox file? What version? Is it encrypted?

[ANLYNG]

How can i see the version - the files are arranged with 5 types:

*.DB

*.MB

*.PX

*.XGO

*.YGO

I found this text in some of the ?license file.

when i edit the files it looks like this:

      



   ¬3äk       
  ÿ ÿN   fm @@äk2@äk 
                    ò
     

    Mé9W ƒ
  ä

‘
       `@äkeAäkiAäkrAäkyAäkAäk‡AäkAäkresttemp.DB                                                                                                                                                                         

Any clues what it is and can it be written into SAS?

[ballardw]

Did you try using DBMS=DB instead of DBMS=PARADOX?

If that isn't working can you export from Paradox to a CSV file and import that?

[ANLYNG]

I tried both DBMS setting - none of them is working. I will try to export the data and see what the names is.

[ANLYNG]

as far i can see with a exported data that the labels/variable has comma , and .  - can i suppress that?

[ANLYNG]

it says also that ERROR: The variable name is illegal for file WORK.MYDATA.DATA