How to turn the output of an x command into a variable

[fgasdg]

I'm looking to  get the output of unix command

       %let myfile =  x 'ls -tr /sas/data/mydata | tail -1';

to be added into the sas program as a variable  &myfile to use in the program and I can get awa from hardcoded filenames.

Any ideas?

[Reeza]

This macro, not mine, will generate the directory listing of a folder into a data set and can recursively search the subfolders. Set the depth to control it not searching. 

https://github.com/sasutils/macros/blob/master/dirtree.sas

[s_lassen · Accepted solution]

You probably want to use a PIPE device, e.g.:

filename ls pipe 'ls -tr /sas/data/mydata | tail -1';
data want;
  infile ls;
  input <whatever you want from the input>;  call symputx('myfile',<the variable you read>);
run;

[fgasdg]

Exactly what I needed. Works perfectly! thanks!