To create csv file,we have to open notepad.then ,declaring 
the variables.then save the file.like enr.csv
SYNTAX: proc import datafile='external file' 
out=<dataset name> dbms=csv replace;
getnames=yes;
proc print data=<dataset name>
run;
eg:proc import datafile='E:\enr.csv'
out=sai                     
dbms=csv    replace;
getnames=yes;
proc print data=sai;
run;

by using proc import or through wizard select import data 
from file menu and infile statement.


proc import datafile='c:\my .csv' out =gan;
run;

You can also use an 
ods html file ='c:\user\new.xls';
proc print data=new;
run;
ods html close;

something along those lines

data DatasetName(drop = If any);
 infile 'Path\CSVFileName.csv'  delimiter = ',' ;
informat Var1 $2.;
informat Var2 anydtdte21.;

 format Var1 $2.;
 format Var2 anydtdte21.;

Input
  Var1 $
  Var2 $;

run;

retreving the data we can use import&infile also.
import:
proc import datafile='external file' 
out=<dataset name> dbms=csv replace;
getnames=yes;
proc print data=<dataset name>
run;

infile:
data code;
infile'C:\Documents and Settings\admin\Desktop\chiru.csv';
input<variable list>;
run;