BookmarkSubscribeRSS Feed
thanikondharish
Fluorite | Level 6
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
2 REPLIES 2
Kurt_Bremser
Super User

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.

Onizuka
Pyrite | Level 9
	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 ;
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 833 views
  • 0 likes
  • 3 in conversation