topic x statement output in SAS Programming

x statement output

KarthikSrivasthav — Wed, 22 Feb 2012 15:48:51 GMT

Dear all,

How can i send output of x statement into

a dataset. By using the below code the dataset is created

but i am unable to open the dataset.

X 'man bdf>>/sys/man.sas7bdat';

X 'bdf>>/sys/bdf.sas7bdat';

x statement output

Hima — Wed, 22 Feb 2012 15:54:18 GMT

It would help if you can post more details. what do you have in 'bdf'?

x statement output

art297 — Wed, 22 Feb 2012 15:55:14 GMT

I don't know what man or bdf do. Do they result in sas files or text files or something else?

x statement output

KarthikSrivasthav — Wed, 22 Feb 2012 16:07:15 GMT

Bdf or df command will give details about data usage and the percent of data occupied

in the server according to directory and file wise

x statement output

Hima — Wed, 22 Feb 2012 16:16:00 GMT

The best approach would be moving the results to text file and then converting the text file to data set. Give it a try.

x statement output

KarthikSrivasthav — Wed, 22 Feb 2012 16:23:22 GMT

Hima i already tried that way i got the result

But i need to send directly to a sas data set

x statement output

Hima — Wed, 22 Feb 2012 16:26:49 GMT

Can you post the results of man bdf? It would greater visibilty for me to help you solve this.

x statement output

FriedEgg — Wed, 22 Feb 2012 16:55:39 GMT

'bdf' and 'df' are pretty much the same thing, they have a different default block-size is all, I think. The 'man' command requests the manual information for a command, and I cannot be sure what purpose this is being called for.

KarthikSrivasthav wrote:
X 'man bdf>>/sys/man.sas7bdat';
X 'bdf>>/sys/bdf.sas7bdat';

These commands will create two text files in /sys/ with the erronious extention of sas7bdat. Just using the sas dataset extention does not convert this output to a valid data format for SAS.

The way you will want to accomplish this task is to use filename statement with the pipe engine to read the stdout from the system commands into a SAS data step.

filename foo pipe 'df -hTP';

data foo;

infile foo lrecl=512 firstobs=2 truncover;

input (filesystem type size used avail usepct mounted_on) (:$64.);

run;

x statement output

Ksharp — Thu, 23 Feb 2012 08:24:00 GMT

As FriedEgg said, you need PIPE .

filename x pipe 'dir c:\';
data want;
infile x length=len;
input row $varying200. len ;
run;

Ksharp

x statement output

KarthikSrivasthav — Thu, 23 Feb 2012 16:35:57 GMT

Thanks

Its working