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
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.
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.