DOS prompt code question

[JeenLeen]

I'm trying to use DOS code to pipe the full directory path (with metadata) to a text file, such that one line of data has
-creation date
-size
-file path
-file name

I can get the metadata by using
dir *.* /s > files.txt
It yields most of the data I want in a single row like

09/21/2020  05:12 PM            39,758 P2021 draft file.csv

But note that the above doesn't have the file path. I'd have to get that from a few rows above... which seems tricky to do programmatically.

I can get the full filepath by using
dir *.* /b /s > files.txt;
But that excludes the metadata

R:\subfolder\P2021 draft file.csv

Does anyone know the right combination of DOS options to get both the full filepath and the metadata, such that I could get something like

09/21/2020  05:12 PM            39,758 r:\subfolder\P2021 draft file.csv

EDIT
A technicality: I'm actually running this within SAS, but it should work the same as in DOS, with the possible exception of when single/double-quotes are needed around file names. I'm using the X system option to issue a command to the operating system.

[Manga Shoggoth]

del x.txt
echo off
FOR /R . %F IN (*.*) DO echo %~tF %~zF %~F >>x.txt
echo on
type x.txt

You will need the echo off, otherwise the echo commands will appear in the output file. If you can only issue one command then put all the commands in a batch file and run that.

Results:

C:\Mine\Music>del x.txt

C:\Mine\Music>echo off
FOR /R . %F IN (*.*) DO echo %~tF %~zF %~F >>x.txt
echo on

C:\Mine\Music>type x.txt
30/09/2012 16:50 4035438 C:\Mine\Music\Best of Anime reduced\07 Track 07.mp3
30/09/2012 16:53 4958084 C:\Mine\Music\Best of Anime reduced\11 Track 11.mp3
30/09/2012 16:54 5108027 C:\Mine\Music\Best of Anime reduced\13 Track 13.mp3
30/09/2012 16:54 3305578 C:\Mine\Music\Best of Anime reduced\14 Track 14.mp3
07/05/2016 14:15 3745108 C:\Mine\Music\Fleetwood Mac - The Dance\01 - Track 1.mp3
07/05/2016 14:15 3357346 C:\Mine\Music\Fleetwood Mac - The Dance\02 - Track 2.mp3
07/05/2016 14:16 2510038 C:\Mine\Music\Fleetwood Mac - The Dance\03 - Track 3.mp3
07/05/2016 14:16 4906512 C:\Mine\Music\Fleetwood Mac - The Dance\04 - Track 4.mp3

[JeenLeen]

Thank you!

For my own records and anyone else looking, here's how to do it in SAS, assuming XCMD is enabled

OPTIONS NOXWAIT;
%let dir=R:\&subfolder;
X "cd &dir";
X "echo off";
X "FOR /R . %F IN (*.*) DO echo %~tF %~zF %~F >> files.txt";
X "echo on";

%F does yield a warning about macro resolution, as %F is SAS code for "call the macro named F"... but as long as you don't have a macro named F, it works fine.

[Manga Shoggoth]

You're welcome.

The F is arbitary, so you can use a different letter if you need to, in which case all the %...F elements change to something else.