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 |
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;
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;
from where you learned all that, do you want to suggest any reference.:)
Check Documentation for SAS/Base at support.sas.com
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.