# Reading in a csv file into SAS

#### ahart

##### Member
hi guys

I am trying to read in the attached csv file (in the zip folder attached)

I started with

dsd dlm = '09'x truncover lrecl = 1023 firstobs = 2;

run;

and got the following in the log

RECFM=V,LRECL=1023,File Size (bytes)=1640761,
Create Time=12 October 2015 09:31:04 o'clo

NOTE: 0 records were read from the infile "C:\Users\aimee.hart\Desktop\New Cust Marketing
NOTE: The data set WORK.ADOBE has 1 observations and 0 variables.
NOTE: The data set WORK.MAY has 1 observations and 0 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time

What are the variations I can change in the code to read this and have orderly columns when there are blanks and 0 values in the csv sheet?

#### Con-Tester

##### Member
Your code specifies that a tab-delimited file is to be imported, whereas the file you attached is comma-delimited. Furthermore, the import code doesn’t identify any variables or their attributes whatsoever.

The code you want is as follow:
Code:
data	Test;
input	OrderPurchaseID		:$12. LastTouchChannel :$30.
run;