Having both R and SAS decided to test this out.
What version of Haven do you have?
EDIT: What is the length of the name of the data set? I shortened the file name to under 8 characters and it worked (replicated this process with it named SASfile and it worked ok for me )
I updated haven package in R and it worked.
I exported mpg (sashelp.cars equivalent) and am getting issues. Using @Tom code I get the following in my log for first three lines.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0
1 HEADER RECORD*******LIBV8 HEADER RECORD!!!!!!!000000000000000000000000000000
2 SAS SAS SASLIB 6.06 bsd4.2 10OCT23:16:13:55
3 10OCT23:16:13:55
So attempting to use XPT2LOC, but then I get a different series of errors related to formats not being read correctly. Sample XPT file attached as zip for anyone else playing around.
78 %xpt2loc(libref=work, filespec=&xpt_file_loc.);
NOTE: Format XPRTFLT is already on the library WORK.FORMATS.
NOTE: Format XPRTFLT has been output.
NOTE: Informat XPRTFLT is already on the library WORK.FORMATS.
NOTE: Informat XPRTFLT has been output.
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 123.50k
OS Memory 20640.00k
Timestamp 10/10/2023 10:24:59 PM
Step Count 137 Switch Count 0
Page Faults 0
Page Reclaims 15
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 40
NOTE: The data set WORK.CNTLIN has 1 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 534.12k
OS Memory 20900.00k
Timestamp 10/10/2023 10:24:59 PM
Step Count 138 Switch Count 2
Page Faults 0
Page Reclaims 100
Page Swaps 0
Voluntary Context Switches 11
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
NOTE: There were 1 observations read from the data set WORK.CNTLIN.
NOTE: The data set WORK.CNTLIN has 1 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 800.21k
OS Memory 21160.00k
Timestamp 10/10/2023 10:24:59 PM
Step Count 139 Switch Count 2
Page Faults 0
Page Reclaims 135
Page Swaps 0
Voluntary Context Switches 10
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
NOTE: There were 1 observations read from the data set WORK.CNTLIN.
NOTE: SAS sort was used.
NOTE: 0 observations with duplicate key values were deleted.
NOTE: The data set WORK.CNTLIN has 1 observations and 4 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 780.15k
OS Memory 21160.00k
Timestamp 10/10/2023 10:24:59 PM
Step Count 140 Switch Count 2
Page Faults 0
Page Reclaims 127
Page Swaps 0
Voluntary Context Switches 10
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
NOTE: Format $MEMWANT is already on the library WORK.FORMATS.
NOTE: Format $MEMWANT has been output.
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 445.78k
OS Memory 20900.00k
Timestamp 10/10/2023 10:24:59 PM
Step Count 141 Switch Count 0
Page Faults 0
Page Reclaims 51
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 8
NOTE: There were 1 observations read from the data set WORK.CNTLIN.
NOTE: Deleting WORK.CNTLIN (memtype=DATA).
NOTE: PROCEDURE DELETE used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 36.21k
OS Memory 20640.00k
Timestamp 10/10/2023 10:24:59 PM
Step Count 142 Switch Count 2
Page Faults 0
Page Reclaims 15
Page Swaps 0
Voluntary Context Switches 9
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
NOTE: UNBUFFERED is the default with RECFM=N.
NOTE: The infile '/home/fkhurshed/Demo1/SAS_export_file.xpt' is:
Filename=/home/fkhurshed/Demo1/SAS_export_file.xpt,
Owner Name=fkhurshed,Group Name=oda,
Access Permission=-rw-r--r--,
Last Modified=10Oct2023:16:14:35,
File Size (bytes)=24320
NOTE: The file METADATA is:
Filename=/saswork/SAS_work77290001FCEC_odaws01-usw2.oda.sas.com/#LN00133,
Owner Name=fkhurshed,Group Name=oda,
Access Permission=-rw-r--r--,
Last Modified=10Oct2023:16:24:59
NOTE: The file INPTSTMT is:
Filename=/saswork/SAS_work77290001FCEC_odaws01-usw2.oda.sas.com/#LN00132,
Owner Name=fkhurshed,Group Name=oda,
Access Permission=-rw-r--r--,
Last Modified=10Oct2023:16:24:59
NOTE: 38 records were written to the file METADATA.
The minimum record length was 1.
The maximum record length was 71.
NOTE: 15 records were written to the file INPTSTMT.
The minimum record length was 3.
The maximum record length was 43.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 937.50k
OS Memory 21344.00k
Timestamp 10/10/2023 10:24:59 PM
Step Count 143 Switch Count 0
Page Faults 0
Page Reclaims 148
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 16
NOTE: The file SASCODE is:
Filename=/saswork/SAS_work77290001FCEC_odaws01-usw2.oda.sas.com/#LN00135,
Owner Name=fkhurshed,Group Name=oda,
Access Permission=-rw-r--r--,
Last Modified=10Oct2023:16:24:59
NOTE: The infile INPTSTMT is:
Filename=/saswork/SAS_work77290001FCEC_odaws01-usw2.oda.sas.com/#LN00132,
Owner Name=fkhurshed,Group Name=oda,
Access Permission=-rw-r--r--,
Last Modified=10Oct2023:16:24:59,
File Size (bytes)=248
NOTE: The infile METADATA is:
Filename=/saswork/SAS_work77290001FCEC_odaws01-usw2.oda.sas.com/#LN00133,
Owner Name=fkhurshed,Group Name=oda,
Access Permission=-rw-r--r--,
Last Modified=10Oct2023:16:24:59,
File Size (bytes)=990
NOTE: 52 records were written to the file SASCODE.
The minimum record length was 1.
The maximum record length was 71.
NOTE: 15 records were read from the infile INPTSTMT.
The minimum record length was 3.
The maximum record length was 43.
NOTE: 38 records were read from the infile METADATA.
The minimum record length was 1.
The maximum record length was 71.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.01 seconds
memory 751.62k
OS Memory 20896.00k
Timestamp 10/10/2023 10:24:59 PM
Step Count 144 Switch Count 0
Page Faults 0
Page Reclaims 47
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 16
NOTE: Fileref METADATA has been deassigned.
NOTE: Fileref INPTSTMT has been deassigned.
84 +format manufacturer $. ;
_
85
76
85 +informat manufacturer $. ;
_
85
76
87 +format model $. ;
_
85
76
88 +informat model $. ;
_
85
76
90 +format displ . ;
_
85
200
76
91 +informat displ . ;
_
85
200
76
93 +format year . ;
_
85
200
76
94 +informat year . ;
_
85
200
76
96 +format cyl . ;
_
85
200
76
97 +informat cyl . ;
_
85
200
76
99 +format trans $. ;
_
85
76
100 +informat trans $. ;
_
85
76
102 +format drv $. ;
_
85
76
103 +informat drv $. ;
_
85
76
105 +format cty . ;
_
85
200
76
106 +informat cty . ;
_
85
200
76
108 +format hwy . ;
_
85
200
76
109 +informat hwy . ;
_
85
200
76
111 +format fl $. ;
_
85
76
112 +informat fl $. ;
_
85
76
114 +format class $. ;
_
85
76
115 +informat class $. ;
_
85
76
ERROR 85-322: Expecting a format name.
ERROR 76-322: Syntax error, statement will be ignored.
ERROR 200-322: The symbol is not recognized and will be ignored.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.SAS_EXPORT_FILE may be incomplete. When this step was stopped there were 0 observations and 11
variables.
WARNING: Data set WORK.SAS_EXPORT_FILE was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 503.03k
OS Memory 21156.00k
Timestamp 10/10/2023 10:24:59 PM
Step Count 145 Switch Count 0
Page Faults 0
Page Reclaims 59
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 16
NOTE: Fileref SASCODE has been deassigned.
131
132
133 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
143
