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;
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
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#Ê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
Are you sure it is a paradox file? What version? Is it encrypted?
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?
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?
I tried both DBMS setting - none of them is working. I will try to export the data and see what the names is.
as far i can see with a exported data that the labels/variable has comma , and . - can i suppress that?
it says also that ERROR: The variable name is illegal for file WORK.MYDATA.DATA
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.