topic Re: read paradox database files in SAS Programming

read paradox database files

ANLYNG — Fri, 10 Nov 2017 14:24:02 GMT

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;

Re: read paradox database files

kiranv_ — Fri, 10 Nov 2017 18:58:22 GMT

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

Re: read paradox database files

Tom — Fri, 10 Nov 2017 20:57:50 GMT

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

Re: read paradox database files

ANLYNG — Sat, 11 Nov 2017 07:37:31 GMT

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

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#ÊDzÿ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ÇC0fD‰+ˆ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ºá-r2HKLsG -> 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…ÒunHKL&G -> VAR50

NOTE: Variable Name Change... -> _30

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

NOTE: Variable Name Change... -> _31

NOTE: Variable Name Change. ARèžÓÿÿ…À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

Re: read paradox database files

ANLYNG — Sat, 11 Nov 2017 07:46:21 GMT

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äkAäk‡AäkAäkresttemp.DB

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

Re: read paradox database files

ballardw — Mon, 13 Nov 2017 18:01:17 GMT

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?

Re: read paradox database files

ANLYNG — Mon, 13 Nov 2017 18:14:36 GMT

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

Re: read paradox database files

ANLYNG — Mon, 13 Nov 2017 18:17:39 GMT

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

Re: read paradox database files

ANLYNG — Mon, 13 Nov 2017 18:31:39 GMT

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