View SAS Data in Visual Studio Code
A SAS7BDAT file is a database storage file created by Statistical Analysis System (SAS) software.
SAS Data Viewer is a robust JavaScript-based tool for viewing files in the SAS7BDAT format. It allows users to freely browse SAS data without needing to install SAS Client, SAS Viya, or the SAS Universal Viewer. Additionally, it improves the encoding of Unicode files, including support for Chinese characters, ensuring better handling and display of multi-language data.
JavaScript
· JSON
CSS
HTML
· Vue 2.0
· Vuetify
· Vtable
. SheetJS
Installation
Install through VS Code extensions. Search for SAS Data Viewer
Visual Studio Code Market Place: SAS Data Viewer
Features
2024
- 0.0.1 Prototype: Automatically scan explorer to finde sas file, Basic display and sort SAS data, to test marketplace environment.
- 0.1.0 Formal release and Long time support. Filter data within page.
- 0.1.1 Add a brief user guide in the .md file.
- 0.1.2 Fixed the bug occurring when VSCode does not have any folder open.
- 0.1.3 Added a copy content option to the right-click menu.
- 0.1.4 Added a feature to export the information into excel file.
- 0.2.1 Converted datetime from raw data to the string.
- 0.2.2
- Automatically uppercase the contents for the Column Name of the property.
- Build a new tree for the excel file which generated by customers.
- Add a new icon for opening the folder in SAS Dataset Viewer.
- 0.3.1
- Added customized parameter, "Per Page Count" is available for this version.
- Split the excel file to new viewer
- 0.4.1 Compatible with a full range of xpt files. Support opening files via a right-click context menu.
- For XPORT result, its icon is yellow, against the CPORT result be assign the orange background.
- For XPORT result, it will be opened directly.
- regards the CPORT result, there are two cases, if there is a dataset in file, it will be open directly. if there are more than one result, the first one will be opened directly.
- 0.4.2 the last update for 2024. the contents of CPORT result be unzip and be listed below the file.
Happy New Year
- 0.5.1 CDISC/Phuse Dataset-JSON 1.0
- Export/Import data in the Dataset-JSON format.
- Fixed the bug of export excel file.
- Modify the rule about the property's type.
Two Ways Get Start
- To right-click the SAS7BDAT file in your explorer, then select the option-
Open File with SAS Viewer
- Select the icon which be placed in the activity bar at the left side, then it will scan the current fold of explorer to filter the SAS file automatically, then click sas file to browse it.
Customized parameter
Acknowledgements
Eason YANG(yi.yang.yy1@hengrui.com)
Contributions
Any and all test, code or feedback contributions are welcome.
Author: Jianfeng YE (冶剑锋)
Phone: +86 18710106985
Mail: yejianfeng186@163.com
Linkin: www.linkedin.com/in/jianfeng-ye-63015b102/