topic Re: How to use this command in SAS Programming

How to use this command

thanikondharish — Wed, 26 Jun 2019 07:20:39 GMT

I have one CSV file in below path
'\\10.11.333\a\b\test.csv' .
When I am writing proc import like see below
Proc import data file='\\10.11.333\a\b\test.csv' DBMS=CSV
Out=want;
Run;
When I am running this code I am getting error.
Then how to import that data

Re: How to use this command

Kurt_Bremser — Wed, 26 Jun 2019 08:09:11 GMT

Maxim 1: Read the Documentation.

In this case, the documentation for the PROC IMPORT Statement

Your mistake will be obvious.

The position of the ERROR indicator in the log will also provide a clue which part of the statement is wrong.

Re: How to use this command

Onizuka — Wed, 26 Jun 2019 10:14:02 GMT

	Proc import datafile = "path\name_file.csv" 
		out = name_output dbms = dlm replace ;
		delimiter = ";" ;
		getnames = yes ; /* depend of your data */
		guessingrows=500; /* facultative, by default 20*/
	run ;