Import Data: ERROR: No logical assign for filename #LN00062.

hellind — Thu, 14 Jul 2011 03:57:50 GMT

My company is using SAS Enterprise Guide 4.2 connected to SAS 9.1.3. SAS Access Interface to PC Files is not installed.

I want to import Ms Access MDB table and prefer not to import data via ODBC. Using EG, I go to File > Import Data > Local Data > MS Access MDB

Then I click on the Import Data icon and click Add Code As Template, I get this code show below.

When I exit EG and re-open and run it again, it gives me the error: ERROR: No logical assign for filename #LN00062.

Question: I want to automate this as a code, don't want to run as a task in process flow. How can I tweak the code to run even after I re-enter EG? What is the code behind that create the file #LN00062?

/* -------------------------------------------------------------------

Code generated by SAS Task

Generated on: Tuesday, July 12, 2011 at 3:43:16 PM

By task: Import Data

Input Data: #LN00062

Server: SASMain

------------------------------------------------------------------- */

%_eg_conditional_dropds(WORK.CA_MASTER);

%MACRO _EG_ImportData;

%LET IsMVS=FALSE;

%IF %TRIM(&SYSSCP) = OS %THEN %DO;

%IF %sysfunc(getoption(filesystem))=MVS %THEN %DO;

%LET IsMVS=TRUE;

%END;

DATA WORK.CA_MASTER;

/* Enterprise Guide creates this temporary asterisk delimited text file from the original data source */

INFILE #LN00062

DELIMITER='*'

MISSOVER

DSD

%IF &IsMVS=FALSE %THEN %DO;

LRECL=32767

%END;

FIRSTOBS=2

;

LENGTH

PRODUCT_GROUP $ 30

PRODUCT_NAME $ 50

CA_NUMBER $ 31

APPLICATION_MONTH $ 19

;

INPUT

PRODUCT_GROUP $

PRODUCT_NAME $

CA_NUMBER $

APPLICATION_MONTH $

;

LABEL

PRODUCT_GROUP = "PRODUCT_GROUP"

PRODUCT_NAME = "PRODUCT_NAME"

CA_NUMBER = "CA_NUMBER"

APPLICATION_MONTH = "APPLICATION_MONTH"

;

RUN;

%MEND;

%_EG_ImportData

/* -------------------------------------------------------------------

End of task code.

------------------------------------------------------------------- */

RUN; QUIT;

Import Data: ERROR: No logical assign for filename #LN00062.

Doc_Duke — Thu, 14 Jul 2011 13:14:37 GMT

EGuide has some capabilities that are not part of your SAS install. When you use the EGuide task to do the import, the EGuide client task connects to the Access database and pulls the data into a delimited text file that it hands off to your SAS 9.1.3 server. If you run just the code, you miss the export. If you want to do the import with code alone, you must use just the 9.1.3 tools.

Doc Muhlbaier

Duke

topic Import Data: ERROR: No logical assign for filename #LN00062. in SAS Enterprise Guide

Import Data: ERROR: No logical assign for filename #LN00062.

Import Data: ERROR: No logical assign for filename #LN00062.