BookmarkSubscribeRSS Feed
thanikondharish
Calcite | Level 5
D:/folder1.
In my D drive there is one folder name is Folder1.
In Folder1 there is one Excel file.
How find that excel filename and that file created date like see below....
File_name. Time
Students.xlsx. 10:23:22
6 REPLIES 6
andreas_lds
Jade | Level 19

Can you use os-commands in your sas-session?

If not, use the functions dopen, dread and finfo to get the information.

andreas_lds
Jade | Level 19

@thanikondharish wrote:
How to write code

You haven't answered my question. When you read the documentation of the functions i mentioned you should be able to write the data-step.

VDD
Ammonite | Level 13 VDD
Ammonite | Level 13

@thanikondharish How to write code

you practice, 

 

here is one way bring up a DOS or a PowerShell window and type help.

C:\> help

or

C:\> help fc

 

 

 

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!

How to Concatenate Values

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 6 replies
  • 1091 views
  • 3 likes
  • 4 in conversation