Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: SAS dataset to CSV
Top Forums UNIX for Advanced & Expert Users SAS dataset to CSV Post 303017761 by Master_Mind on Tuesday 22nd of May 2018 12:13:09 AM
Old 05-22-2018
Hi ,

The thing is i am unable to view cat the .sas7dbat file which is holding no many special characters

Code:
cat sample.sas7bdat
^]▒AA▒▒▒▒▒▒▒▒▒0▒^_▒BA▒▒▒▒ŇAAx▒▒▒#▒DA▒▒▒▒_;CA▒▒▒▒▒▒▒▒kA▒o%ȨKjA▒Fؽ5>oAT▒|▒▒lA▒▒▒▒▒o
                                                                                 ▒▒▒@▒)P▒▒▒A▒▒▒CWWAMALAYSIA INCL DSR▒NCCPL_IL▒[XXXX]$ xtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtemxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxtermxterm^C

od -bc sample.csv

0501720 346 202 123 107 104 345 205 101 123 055 123 107 104 343 202 123
        346 202   S   G   D 345 205   A   S   -   S   G   D 343 202   S
0501740 107 104 341 206 125 055 120 122 114 055 111 351 202 123 107 104
          G   D 341 206   U   -   P   R   L   -   I 351 202   S   G   D
0501760 345 210 123 151 156 147 141 160 157 162 145 341 202 123 107 104
        345 210   S   i   n   g   a   p   o   r   e 341 202   S   G   D
0502000

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Accessing Mainframe Dataset

Hi May I know is there a way to read/copy a mainframe (IBM OS/390) dataset (sequential file) into a UNIX directory? Thank you for your time. IcyGuava (4 Replies)
Discussion started by: IcyGuava
4 Replies

2. Shell Programming and Scripting

Numbers of records in SAS dataset

I'm declaring a variable within a Korn shell to represent the total number of records in a SAS dataset and could use a little help with the syntax. This is what I have thus far: #!/usr/bin/ksh RecCount = `sas -x "select count(*) from /users/abc/123/sas_dataset.sas7bdat"` (2 Replies)
Discussion started by: sasaliasim
2 Replies

3. Programming

Finding number of records in SAS dataset

I am running the following Korn shell script: #!/usr/bin/ksh num_records=`sas "select count(*) from /users/abc/123/sasdata.sas7bdat"` echo "$num_records" The script keeps returning an invalid file error even though I am certain that the file really exists. Does anyone see anything wrong... (1 Reply)
Discussion started by: sasaliasim
1 Replies

4. Shell Programming and Scripting

Normalize a dataset with AWK

Hello everyone, i have to normalize this dataset (with 20.000 rows): 2,4,4,3,2,7,8,2,9,11,7,7,1,8,5,6 4,7,5,5,5,5,9,6,4,8,7,9,2,9,7,10 7,10,8,7,4,8,8,5,10,11,2,8,2,5,5,10 4,9,5,7,4,7,7,13,1,7,6,8,3,8,0,8,8 6,7,8,5,4,7,6,3,7,10,7,9,3,8,3,7,8 in this form:... (1 Reply)
Discussion started by: [raven]
1 Replies

5. Shell Programming and Scripting

Computing dataset for a specific record

Hello everybody, I want to compute a data file in awk. I am new in awk and I need your help. The data file has the following fields. It has thousands of records. Col1 Col2 Col3 Col4 Col5 0.85 0.07 Fre 42:86 25 0.73 0.03 frp 21:10 28 0.64... (12 Replies)
Discussion started by: ubeejani
12 Replies

6. Shell Programming and Scripting

How to extract a subset from a huge dataset

Hi, All I have a huge file which has 450G. Its tab-delimited format is as below x1 A 50020 1 x1 B 50021 8 x1 C 50022 9 x1 A 50023 10 x2 D 50024 5 x2 C 50025 7 x2 F 50026 8 x2 N 50027 1 : : Now, I want to extract a subset from this file. In this subset, column 1 is x10, column 2 is... (3 Replies)
Discussion started by: cliffyiu
3 Replies

7. Programming

Dataset Library for C?

I am looking for an opensource dataset library for C. Something equivalent to ADO.Net. Specifically, I am looking for the following features: 1. Create a Dataset from a file (XML or CSV). 2. Create a Dataset from a select query using an ODBC connection. 3. Load a created Dataset into a... (1 Reply)
Discussion started by: a_programmer
1 Replies

8. Solaris

flarecreate for zfs root dataset and ignore multiple dataset

Hi All, I want to write a script to create flar images on multiple servers. In non zfs filesystem I am using -X option to refer a file to exclude mounts on different servers. but on ZFS -X option is not working. I want multiple mounts to be ignore on ZFS base system during flarecreate. I... (0 Replies)
Discussion started by: uxravi
0 Replies

9. Solaris

ZFS - Dataset / pool name are the same...cannot destroy

I messed up my pool by doing zfs send...recive So I got the following : zpool list NAME SIZE ALLOC FREE CAP DEDUP HEALTH ALTROOT rpool 928G 17.3G 911G 1% 1.00x ONLINE - tank1 928G 35.8G 892G 3% 1.00x ONLINE - So I have "tank1" pool. zfs get all... (8 Replies)
Discussion started by: eladgrs
8 Replies

10. UNIX for Advanced & Expert Users

How to extract subset file from dataset?

Hello I have a data set which looks like this : progeny sire dam gender 12 1 3 M 13 2 4 F 14 2 5 F 15 6 5 ... (13 Replies)
Discussion started by: sajmar
13 Replies

LEARN ABOUT OPENSOLARIS

iconv_maz

iconv_maz(5)                                            Standards, Environments, and Macros                                           iconv_maz(5)

NAME

       iconv_maz - code set conversion tables for Mazovia

DESCRIPTION

       The following code set conversions are supported:

       +--------------------------------------------------------------------+
       |                  Code Set Conversions Supported                    |
       +--------------+--------+--------------+--------+--------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |       Target       |
       +--------------+--------+--------------+--------+--------------------+
       |Output        |        |              |        |                    |
       +--------------+--------+--------------+--------+--------------------+
       |Mazovia       |maz     |ISO 8859-2    |iso2    | ISO Latin 2        |
       +--------------+--------+--------------+--------+--------------------+
       |Mazovia       |maz     |MS 1250       |win2    | Windows Latin 2    |
       +--------------+--------+--------------+--------+--------------------+
       |Mazovia       |maz     |MS 852        |dos2    | MS-DOS Latin 2     |
       +--------------+--------+--------------+--------+--------------------+
       |Mazovia       |maz     |DHN           |dhn     | Dom Hanlowy Nauki  |
       +--------------+--------+--------------+--------+--------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   Mazovia to ISO 8859-2
       For the conversion of Mazovia to ISO 8859-2, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |   Mazovia     |  ISO 8859-2    |   Mazovia      |  ISO 8859-2   |
       |24-177         | 40             |230             |246            |
       |200            | 307            |231             |326            |
       |201            | 374            |232             |334            |
       |202            | 351            |233             |40             |
       |203            | 342            |234             |243            |
       |204            | 344            |235             |40             |
       |205            | 40             |236             |266            |
       |206            | 261            |237             |40             |
       |207            | 347            |240             |254            |
       |210            | 40             |241             |257            |
       |211            | 353            |242             |363            |
       |212-213        | 40             |243             |323            |
       |214            | 356            |244             |361            |
       |215            | 346            |245             |321            |
       |216            | 304            |246             |274            |
       |217            | 241            |247             |277            |
       |220            | 312            |250-340         |40             |
       |221            | 352            |341             |337            |
       |222            | 263            |342-365         |40             |
       |223            | 364            |366             |367            |
       |224            | 366            |367             |40             |
       |225            | 306            |370             |260            |
       |226-227        | 40             |371-376         |40             |
       |256            | 201            |                |               |
       +---------------+----------------+----------------+---------------+

   Mazovia to MS 1250
       For the conversion of Mazovia to MS 1250, all characters not in the following table are mapped unchanged.

       +---------------+----------------+----------------+---------------+
       |   Mazovia     |    MS 1250     |   Mazovia      |   MS 1250     |
       |200            | 307            |236             |234            |
       |201            | 374            |237             |40             |
       |202            | 351            |240             |217            |
       |203            | 342            |241             |257            |
       |204            | 344            |242             |363            |
       |205            | 40             |243             |323            |
       |206            | 271            |244             |361            |
       |207            | 347            |245             |321            |
       |210            | 40             |246             |237            |
       |211            | 353            |247             |277            |
       |212-213        | 40             |250-251         |40             |
       |214            | 356            |252             |254            |
       |215            | 346            |253-255         |40             |
       |216            | 304            |256             |253            |
       |217            | 245            |257             |273            |
       |220            | 312            |260-340         |40             |
       |221            | 352            |341             |337            |
       |222            | 263            |342-345         |40             |
       |223            | 364            |346             |265            |
       |224            | 366            |347-360         |40             |
       |225            | 306            |361             |261            |
       |226-227        | 40             |362-365         |0              |
       |230            | 214            |366             |367            |
       |231            | 326            |367             |40             |
       |232            | 334            |370             |260            |
       |233            | 40             |371             |40             |
       |234            | 243            |372             |267            |
       |235            | 40             |373-376         |40             |
       |274            | 212            |                |               |
       +---------------+----------------+----------------+---------------+

   Mazovia to MS 852
       For the conversion of Mazovia to MS 852, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |   Mazovia     |    MS 852      |   Mazovia      |    MS 852     |
       |205            | 40             |234             |235            |
       |206            | 245            |235             |40             |
       |210-213        | 40             |236             |230            |
       |215            | 206            |237             |40             |
       |217            | 244            |240             |215            |
       |220            | 250            |241             |275            |
       |221            | 251            |243             |340            |
       |222            | 210            |244             |344            |
       |225            | 217            |245             |343            |
       |226-227        | 40             |246             |253            |
       |230            | 227            |247             |276            |
       |233            | 40             |250-375         |40             |
       |227            | 327            |                |               |
       +---------------+----------------+----------------+---------------+

   Mazovia to DHN
       For the conversion of Mazovia to DHN, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |   Mazovia     |      DHN       |   Mazovia      |     DHN       |
       |200-205        | 40             |234             |203            |
       |206            | 211            |236             |217            |
       |207-214        | 40             |240             |207            |
       |215            | 212            |241             |210            |
       |216            | 40             |242             |216            |
       |217            | 200            |243             |205            |
       |220            | 202            |244             |215            |
       |221            | 214            |246             |220            |
       |225            | 201            |247             |221            |
       |230            | 206            |                |               |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so             conversion modules

       /usr/lib/iconv/*.t              conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10                                                          18 Apr 1997                                                       iconv_maz(5)
All times are GMT -4. The time now is 10:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy