Import .csv file from Unix SAS server

[sfawver]

Does someone have the syntax for read that will import an .xls file from a Unix SAS server?

How do I change the path to read from a SAS server?

Thanks.

desktop example
allmsa.read(t=xls, a1, s=All436areas) "C:\Documents and Settings\Desktop\All436areas.xls"

SAS path
\\Sac-psas-01\Scott

[EViews Gareth]

What is the full Windows (UNC) path to the file?

[sfawver]

My co-worker figured it out. You can setup a network drive alias, i.e. W and it works. You can't use the whole path.

works
allmsa.read(t=txt) "W:\riskindex\RI_V3.1\code\main\All384areas.csv"

doesn't work
allmsa.read(t=txt) "\\Sac-psas-01\riskindex\RI_V3.1\code\main\All384areas.csv"

[EViews Gareth]

That might be true for the read command. If you're using EViews 7, you're probably better off using wfopen or import instead.