Desktop productivity for business analysts and programmers

Program automate Import Data Task from shared windows server?

Reply
Occasional Contributor
Posts: 11

Program automate Import Data Task from shared windows server?

I want to use macros to allow import so don't want to just use the 'ordered list' functionality.
Here is the task code. I can rerun MANUALLY generated task code from 'import data' task if its pulling text from the sas server because it gives the entire unix path. But if text is sitting on regular server or C drive it gives this funny #LN00018. Note this is NOT a sas dataset. Any ideas?:

(code snippet from EG logSmiley Happy

OPTIONS DATESTYLE=MDY;
35 DATA WORK.IMPW_0000;
36 /* Enterprise Guide creates this temporary asterisk delimited text file from the original data source */
37 INFILE #LN00018
38 DELIMITER=','
39 MISSOVER
40 DSD
41 %IF &IsMVS=FALSE %THEN %DO;
42 LRECL=32767
43 %END;
44 ;
45 LENGTH
46 F1 8
Ask a Question
Discussion stats
  • 0 replies
  • 404 views
  • 0 likes
  • 1 in conversation