BookmarkSubscribeRSS Feed
ANLYNG
Pyrite | Level 9

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;

8 REPLIES 8
kiranv_
Rhodochrosite | Level 12

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
Pyrite | Level 9

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

Tom
Super User Tom
Super User

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

 

ANLYNG
Pyrite | Level 9

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
Super User

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
Pyrite | Level 9

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

ANLYNG
Pyrite | Level 9

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

ANLYNG
Pyrite | Level 9

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 8 replies
  • 1297 views
  • 0 likes
  • 4 in conversation