topic transpose_format in SAS Programming

transpose_format

Srigyan — Mon, 02 Sep 2019 10:59:33 GMT

I am importing one .lst file by following code

data import;
 infile  "S3_Location/File.lst" length=len;
 length text $500;
 input text $varying. len;
run;

input is

parameter passed = S3_Location/File.csv
2019-09-02 06:18:37    3092373 File.csv
successful

output is

text

parameter passed = S3_Location/File.csv

2019-09-02 06:18:37 3092373 File.csv

successful

I wanted this output to converted like this

Location	Date_time	size	file	transfer
parameter passed =S_location/File.csv	02/09/2019 06:18	3092373	File.csv	successful

Re: transpose_format

Ksharp — Mon, 02 Sep 2019 12:25:25 GMT

Not see your real data, but try this.

data import;
 infile  "S3_Location/File.lst" truncover dlm=' ';
 input #1 location $100. 
       #2 date : $12. time : $10. size file : $40.
       #3 transfer $40. ;
run;

Re: transpose_format

Srigyan — Mon, 02 Sep 2019 13:24:32 GMT

from where you learned all that, do you want to suggest any reference.:)

Re: transpose_format

Ksharp — Tue, 03 Sep 2019 11:55:04 GMT

Check Documentation for SAS/Base at support.sas.com