blocks|key|2273918|text|使用R外部包之一读取文件，然后使用该工具转换为CSV。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2273919|http://cran.r-project.org/doc/manuals/R-data.pdf+Pg+12|offset|length|2273920|改用SAS7BDAT包。它似乎忽略了自定义格式，读取底层数据。|2273921|在SAS中：|2273922|proc+format;
value+agegrp
+++low+-+12+=+'Pre+Teen'
+++13+-15+=+'Teen'
+++16+-+high+=+'Driver';
run;

libname+test+'Z:\Consulting\SAS+Programs';

data+test.class;
set+sashelp.class;
age2=age;
format+age2+agegrp.;
run;|code-block|syntax|javascript|2273923|在R中：|2273924|+install.packages(sas7bdat)
+library(sas7bdat)
+x<-read.sas7bdat("class.sas7bdat",+debug=TRUE)
+x++|2273925|entityMap|0|LINK|mutability|MUTABLE|url|http://cran.r-project.org/doc/manuals/R-data.pdf^0|0|0|1C|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@$D|12|E|13|1|14]]|A|$]]|$1|F|3|G|5|6|7|15|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|16|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|17|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|18|8|@]|9|@]|A|$]]|$1|Q|3|R|5|L|7|19|8|@]|9|@]|A|$M|N]]|$1|S|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

Use one of the R foreign packages to read the file and then convert to CSV with that tool. 

<a href="http://cran.r-project.org/doc/manuals/R-data.pdf" rel="noreferrer">http://cran.r-project.org/doc/manuals/R-data.pdf</a>
Pg 12

Using the SAS7BDAT package instead. It appears to ignore custom formatted, reading the underlying data.

In SAS:

<pre><code>proc format;
value agegrp
 low - 12 = 'Pre Teen'
 13 -15 = 'Teen'
 16 - high = 'Driver';
run;

libname test 'Z:\Consulting\SAS Programs';

data test.class;
set sashelp.class;
age2=age;
format age2 agegrp.;
run;
</code></pre>

In R:

<pre><code> install.packages(sas7bdat)
 library(sas7bdat)
 x&lt;-read.sas7bdat("class.sas7bdat", debug=TRUE)
 x 
</code></pre>

blocks|key|2274099|text|python包sas7bdat，可用here，包含一个用于读取sas7bdat文件的库：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2274100|from+sas7bdat+import+SAS7BDAT
with+SAS7BDAT('foo.sas7bdat')+as+f:
++++for+row+in+f:
++++++++print+row|code-block|syntax|javascript|2274101|以及不需要编程的命令行程序|BOLD|2274102|$+sas7bdat_to_csv+in.sas7bdat+out.csv|2274103|entityMap|0|LINK|mutability|MUTABLE|url|https://pypi.python.org/pypi/sas7bdat^0|7|8|I|4|0|0|0|8|5|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@$9|Y|A|Z|B|C]]|D|@$9|10|A|11|1|12]]|E|$]]|$1|F|3|G|5|H|7|13|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|14|8|@$9|15|A|16|B|M]]|D|@]|E|$]]|$1|N|3|O|5|H|7|17|8|@]|D|@]|E|$I|J]]|$1|P|3|-4|5|6|7|18|8|@]|D|@]|E|$]]]|Q|$R|$5|S|T|U|E|$V|W]]]]

The python package <code>sas7bdat</code>, available <a href="https://pypi.python.org/pypi/sas7bdat" rel="noreferrer">here</a>, includes a library for reading sas7bdat files:

<pre><code>from sas7bdat import SAS7BDAT
with SAS7BDAT('foo.sas7bdat') as f:
 for row in f:
 print row
</code></pre>

and a command-line program requiring no programming

<pre><code>$ sas7bdat_to_csv in.sas7bdat out.csv
</code></pre>

blocks|key|2274059|text|我最近写了这个包，它允许您使用Hadoop/Spark将sas7bdat转换为csv。它能够分割巨大的sas7bdat文件，从而实现高并行度。根据@Ashpreet的建议，解析也使用parso|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2274060|https://github.com/saurfang/spark-sas7bdat|offset|length|2274061|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|16|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

I recently wrote this package that allows you convert sas7bdat to csv using Hadoop/Spark. It's able to split giant sas7bdat file thus achieving high parallelism. The parsing also uses parso as suggested by @Ashpreet

<a href="https://github.com/saurfang/spark-sas7bdat" rel="nofollow">https://github.com/saurfang/spark-sas7bdat</a>

blocks|key|5802100|text|如果这是一次性的，您可以从此处免费下载SAS系统查看器(注册帐户后，这也是免费的)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5802101|http://support.sas.com/downloads/package.htm?pid=176|offset|length|5802102|然后，可以使用查看器打开sas数据集，并将其另存为csv文件。据我所知，目前还没有CLI，但如果您真的想这样做，您可以编写一个自动热键脚本或类似的脚本来将SAS数据集转换为csv。|5802103|还可以使用用于OLE+DB的SAS提供程序来读取SAS数据集，而无需实际安装SAS，这可以从以下位置获得：|5802104|http://support.sas.com/downloads/browse.htm?fil=0&cat=64|5802105|然而，这是相当复杂的-如果你想了解一些想法，可以在这里找到一些文档：|5802106|http://support.sas.com/documentation/cdl/en/oledbpr/59558/PDF/default/oledbpr.pdf|5802107|entityMap|0|LINK|mutability|MUTABLE|url|1|2^0|0|0|1G|0|0|0|0|0|1K|1|0|0|0|29|2|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@$D|10|E|11|1|12]]|A|$]]|$1|F|3|G|5|6|7|13|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|14|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|15|8|@]|9|@$D|16|E|17|1|18]]|A|$]]|$1|L|3|M|5|6|7|19|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1A|8|@]|9|@$D|1B|E|1C|1|1D]]|A|$]]|$1|P|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|C]]|W|$5|S|T|U|A|$V|K]]|X|$5|S|T|U|A|$V|O]]]]

If this is a one-off, you can download the SAS system viewer for free from here (after registering for an account, which is also free):

<a href="http://support.sas.com/downloads/package.htm?pid=176" rel="nofollow">http://support.sas.com/downloads/package.htm?pid=176</a>

You can then open the sas dataset using the viewer and save it as a csv file. There is no CLI as far as I can tell, but if you really wanted to you could probably write an autohotkey script or similar to convert SAS datasets to csv.

It is also possible to use the SAS provider for OLE DB to read SAS datasets without actually having SAS installed, and that's available here:

<a href="http://support.sas.com/downloads/browse.htm?fil=0&amp;cat=64" rel="nofollow">http://support.sas.com/downloads/browse.htm?fil=0&amp;cat=64</a>

However, this is rather complicated - some documentation is available here if you want to get an idea:

<a href="http://support.sas.com/documentation/cdl/en/oledbpr/59558/PDF/default/oledbpr.pdf" rel="nofollow">http://support.sas.com/documentation/cdl/en/oledbpr/59558/PDF/default/oledbpr.pdf</a>

blocks|key|1755074|text|谢谢你的帮助。我结束了在java中使用parso实用程序的工作，它工作得很棒。该实用程序将行作为对象数组返回，我将其写入一个文本文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1755075|我引用的实用程序来自：http://lifescience.opensource.epam.com/parso.html|offset|length|1755076|entityMap|0|LINK|mutability|MUTABLE|url|http://lifescience.opensource.epam.com/parso.html^0|0|B|1D|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Thanks for your help. I ended us using the parso utility in java and it worked like a charm. The utility returns the rows as object arrays which i wrote into a text file.

I referred to the utility from: <a href="http://lifescience.opensource.epam.com/parso.html" rel="nofollow noreferrer">http://lifescience.opensource.epam.com/parso.html</a>

I want to convert a .sas7bdat file to a .csv/txt format so that I can upload it into a hive table.
I'm receiving the .sas7bdat file from an outside server and do not have SAS on my machine.

How to convert sas7bdat file to csv?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我希望将.sas7bdat文件转换为.csv/txt格式，以便可以将其上载到配置单元表中。我正在从外部服务器接收.sas7bdat文件，但我的机器上没有SAS。

问如何将sas7bdat文件转换为csv？
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将sas7bdat文件转换为csv？EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将sas7bdat文件转换为csv？
EN