topic How to import latest excel file in to SAS EG in SAS Enterprise Guide

How to import latest excel file in to SAS EG

srinivaschary — Wed, 28 Jun 2017 11:27:11 GMT

Hi,

I need to import latest updated file in SAS EG.

Actual file name:

exel28062017_060000

exel28062017_050000

exel28062017_070000

Required to import file from the folder

exel28062017_070000

Please help

Srinivas

RW9 — Wed, 28 Jun 2017 11:38:13 GMT

Select the right file when you choose import??

A lack of information is not a good way of getting an answer.

If you need to check a file list, then do you have x command access? If you do then this should help:

Get a directory listing, identify the filename you want logically, then use that as the filename.

If you don't then DOPEN and process that way:

srinivaschary — Wed, 28 Jun 2017 13:25:42 GMT

Thanks for the reply,

sorry for the misscommunication RW9. i have a hourly based list of

excel files(

exel28062017_060000.XLSX

exel28062017_050000.XLSX

exel28062017_070000.XLSX) in a folder ,which is located in server .

i would like to pick and import most recent (exel28062017_070000.XLSX) file .

Kindly help me on importing the recent excel file.

Thanks