05-21-2018
Your problem is becoming less and less evident to me.
What does "i am unable to view the sas7dbat file in unix , because its generated using sas" mean? Is that file available on your *nix host? Or, how would those output data be provided, and to where?
What does "read this sasdataset file" mean? Does it exist or not?
Please take a step back, carefully rephrase your request (considering my post#4 and Don Cragun's post#6), and draw the whole picture.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
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
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
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
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
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
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
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
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
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
cr(1) General Commands Manual cr(1)
NAME
cr - converts text files between nix EOL and dos EOL
SYNOPSIS
cr - | + <input file> <output file>
DESCRIPTION
Text files, such as tle files, that come from a dos source usualy have the ^M symbol at the end of every line. Cr converts files between
the dos newline format and the normal *nix newline format by stripping the ^M to convert dos to *nix, using the '-' option, or adding ^M to
a *nix file to create the proper dos file when the '+' option is used.
Although this extra character is not often a problem, programs like seesat5, which are data driven will encounter parsing problems when the
extra character is present. It is these problems that cr is intended to repair.
Options
- | + One or the other of these options is required. The '-' option is used to remove ^M from all newlines found in the dos file. The '+'
option is used to add ^M to every newline found in a *nix file.
input file
Fully delineated path to the input file. As this program is used in the dos environment as well, standard input is not used.
output file
Fully delineated path to the output file. As this program is used in the dos environment as well, standart output is not used.
SEE ALSO
seesat5(1), seesat5(7), SEESAT5.INI(5), tle(5)
BUGS
Cr is not an inteligent program. It methodicaly replaces/removes the offending character when it finds it in the correct context. Newline
sequences found in contexts other than 'newline' will be replaced/removed just like those found in the proper context. Passing a binary
file through cr is not advised, for this reason. Send all inqueries to Dale Scheetz <dwarf@polaris.net>.
Debian Linux 2 April 96 cr(1)