BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
alepage
Barite | Level 11

Hello I am using the following command to get the listing of the S3 bucket. it goes into the log file.

How to put it into a SAS dataset?

 

%let s3bucketpath=s3://***-pr-brz-datareten-edp-nprod;

filename oscmd pipe "aws s3 ls ""&s3bucketpath."" ";
1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHemedinger
Community Manager

You need to pair this PIPE output with a DATA step, something like:

 

data WANT; 
  infile oscmd pad; 
  input LINE 256.;
  /* parse the line into fields */
  FNAME=substr(X,..); 
run;
Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!

View solution in original post

3 REPLIES 3
ChrisHemedinger
Community Manager

You need to pair this PIPE output with a DATA step, something like:

 

data WANT; 
  infile oscmd pad; 
  input LINE 256.;
  /* parse the line into fields */
  FNAME=substr(X,..); 
run;
Register for SAS Innovate 2025!! The premier event for SAS users, May 6-9 in Orlando FL. Sign up now for the best deals!
alepage
Barite | Level 11

I am not familliar with pad

 

What does it stand for ?

Tom
Super User Tom
Super User

@alepage wrote:

I am not familliar with pad

 

What does it stand for ?


It means what it sounds like.  The lines are padded with spaces to the full logical record length.

Not much use for it since they introduced the TRUNCOVER option some 30 to 40 years ago.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 594 views
  • 1 like
  • 3 in conversation