topic Re: I am getting the following error when I import certain .csv files into SAS ? Can anyone please help how to import it successfully ? in SAS Procedures

I am getting the following error when I import certain .csv files into SAS ? Can anyone please help how to import it successfully ?

tanuj82 — Mon, 01 Jun 2015 09:53:06 GMT

ERROR: Module SASMSR not found in search paths.

ERROR: Method _getValue(NCCO)N is not defined.

ERROR: This method is not defined for the object class.

Parameters passed to method _GETVALUE:

1 (Numeric Literal) = 0

2 (Character Literal) = 'PRODUCTS\BASE\EFI\GuessingRows'

3 valuType = ''

4 regValues = .

Program returning prematurely at line 820

AF Program: SASHELP.EFI.EFIBATCH.SCL

NOTE: Import Cancelled.

Re: I am getting the following error when I import certain .csv files into SAS ? Can anyone please help how to import it successfully ?

Doc_Duke — Mon, 01 Jun 2015 17:44:19 GMT

What version of SAS and OS?

What was the syntax of the IMPORT?

Re: I am getting the following error when I import certain .csv files into SAS ? Can anyone please help how to import it successfully ?

cj9000 — Mon, 01 Jun 2015 17:54:12 GMT

If you are licensed for SAS/Access Interface to PC File Formats in SAS 8.2 but Access is not installed properly, the PC File Formats filetypes (such as Excel, MSAccess, DBF, and so on) remain available when you try to use the Export and Import wizards. However, if you select these file types, this error message appears: ERROR: Module SASIMODE not found in search paths

5871 - "ERROR: Module SASIMODE not found in search paths" message appears whenattempting to import or export a PCFF file

Re: I am getting the following error when I import certain .csv files into SAS ? Can anyone please help how to import it successfully ?

tanuj82 — Tue, 02 Jun 2015 04:43:27 GMT

Version of SAS is 9 TS Level 00M0 and version of OS is Windows 7 Home Basic. I didn't write any syntax , I was trying to import using the File and Import data option.

Re: I am getting the following error when I import certain .csv files into SAS ? Can anyone please help how to import it successfully ?

Kurt_Bremser — Tue, 02 Jun 2015 05:36:45 GMT

If you are importing .csv files, the absolutely best way to go is to write a data step that does the import. Does not need any additional modules/licensing.

Re: I am getting the following error when I import certain .csv files into SAS ? Can anyone please help how to import it successfully ?

tanuj82 — Tue, 02 Jun 2015 06:01:31 GMT

I have written the below code to import using the data step ..its still not working ..

proc import datafile= "C:\Users\admin\Documents\SAS CASE STUDY\SAS Master Case Study-2_Data\Laptops.csv"

out=laptops

dbms=csv

replace;

getnames=yes;

run;

proc print;

run;

The error message I am getting is :-

75 proc print;

ERROR: There is not a default input data set (_LAST_ is _NULL_).

76 run;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds.

Please help..??

Re: I am getting the following error when I import certain .csv files into SAS ? Can anyone please help how to import it successfully ?

RW9 — Tue, 02 Jun 2015 08:09:45 GMT

Yes, you are importing a filetype of MS Office and you lack the SAS/Access part. If your file really is CSV, i.e. text delimited by commas -> open in Notepad, then as KurtBremser has said, write a datastep import program - plenty of examples on here.

If it is an Excel file, then SaveAs -> CSV.

Re: I am getting the following error when I import certain .csv files into SAS ? Can anyone please help how to import it successfully ?

Kurt_Bremser — Tue, 02 Jun 2015 12:48:31 GMT

Looks to me that PROC IMPORT does not set the automatic _LAST_ system option, which holds the name of the most recently created dataset.

Use

proc print data=laptops;

run;

instead.

And have a look at the complete log. PROC IMPORT will place the DATA step that it automatically creates there, so you have something to start writing your own DATA step. PROC IMPORT is good for a first shot, but a manually written DATA step is the way to go with .csv (or other "flat" files).

Re: I am getting the following error when I import certain .csv files into SAS ? Can anyone please help how to import it successfully ?

tanuj82 — Tue, 02 Jun 2015 12:54:20 GMT

Thanks for all the answers , I have been able to import all my .csv files into SAS after reinstalling a fresh University version of SAS..now I need help with a Case Study .. is anyone willing to guide me answer the case study questions ..? if yes I can share it via Email or if possible here on the forum as well ..