Desktop productivity for business analysts and programmers

EG 4.1 Export/Import Wizards - Can they have macro variable based filenames

Reply
N/A
Posts: 0

EG 4.1 Export/Import Wizards - Can they have macro variable based filenames

Hi

We are currently doing a large deployment of EG 4.1 in our bank with a remote SAS 9.1.3 server. We are moving away from PC SAS installations. All SAS code is expected to run on server only.

Question:
Is there any way to generate macro variable based filenames with EG 4.1 Export/Import wizards for files being exported/imported from the desktop PC ? Any workarounds/tricks in case this is not possible ?

Our users previously used a combination of proc upload/download & proc import/export on PC SAS to generate various excel filenames using macro variables as an automation technique. I'm trying to find ways to replace this functionality with our new setup.

Regards
Respected Advisor
Posts: 3,837

Re: EG 4.1 Export/Import Wizards - Can they have macro variable based filenames

Hi
Assuming the SAS Server is not under z/OS:
If the excels would be stored on a share accessible by the SAS Server and the users then the upload/download part could be skipped.
Proc import/export should still work as before - and if this is coded then using macro vars shouldn't be an issue.
HTH
Patrick Message was edited by: Patrick
N/A
Posts: 0

Re: EG 4.1 Export/Import Wizards - Can they have macro variable based filenames

The SAS server is an IBM AIX 5.3

The server technology stack is all 9.1.3 components.

Share access: Both Samba or a windows NFS do not offer secure n/w transfers (as they just open up a share) and hence not possible in our corporate environment due to policy.

Libname SFTP cannot be used in 9.1

Any ideas on proc download replacements ?
Respected Advisor
Posts: 3,837

Re: EG 4.1 Export/Import Wizards - Can they have macro variable based filenames

Hi

Not that this is really my field of expertise - but I can't agree with your security objections.
http://publib.boulder.ibm.com/infocenter/aix/v6r1/index.jsp?topic=/com.ibm.aix.security/doc/security...

I've worked for more than one bank (where security gets high attention) where things like this were possible (mostly using unc paths).

HTH
Patrick
Ask a Question
Discussion stats
  • 3 replies
  • 117 views
  • 0 likes
  • 2 in conversation