DATA Step, Macro, Functions and more

read paradox database files

Reply
Frequent Contributor
Posts: 75

read paradox database files

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;

PROC Star
Posts: 326

Re: read paradox database files

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

 

 

 

Frequent Contributor
Posts: 75

Re: read paradox database files

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Ç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ºá-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

Super User
Super User
Posts: 7,060

Re: read paradox database files

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

 

Frequent Contributor
Posts: 75

Re: read paradox database files

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?

 

 

 

Super User
Posts: 11,343

Re: read paradox database files

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?

Frequent Contributor
Posts: 75

Re: read paradox database files

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

Frequent Contributor
Posts: 75

Re: read paradox database files

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

Frequent Contributor
Posts: 75

Re: read paradox database files

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

Ask a Question
Discussion stats
  • 8 replies
  • 112 views
  • 0 likes
  • 4 in conversation