C:StatesDatacrime.dat
?
filename crime 'c:statesdatacrime.dat';
filename crime c:statesdatacrime.dat;
fileref crime 'c:statesdatacrime.dat';
filename 'c:statesdatacrime' crime.dat;
options obs=7; proc import data="C:users est.txt" out=exam dbms=dlm replace; getnames=yes; run; proc print data=exam; run;
options obs=7; proc import datafile="c:users est.txt" out=exam dbms=dlm replace; delimiter='.'; getnames=yes; run; proc print data=exam; run;
proc import datafile="c:users est.txt" out=exam dbms=dlm replace; delimiter=' '; getnames=no; run; proc print data=exam (obs=7); run;
proc import datafile="c:users est.txt" out=exam dbms=csv replace; delimiter=','; getnames=no; run; proc print data=exam; options obs=7; run;
getnames=no;
datarow=1;
guessingrows=1;
getnames=yes;
filename workbook 'C:certdataclass1.csv'; proc import datafile=workbook.class dbms=csv out=class1 replace; getnames=yes; run;
filename workbook 'C:certdataworkbook.txt'; proc import datafile=workbook dbms=dlm out=workbook replace; getnames=yes; run;
filename workbook 'C:certdataworkbook.txt'; proc import datafile=class01 dbms=dlm out=class01work replace; getnames=yes; run;
Region&State&Month&Expenses&Revenue Southern&GA&JAN2001&2000&8000 Southern&GA&FEB2001&1200&6000 Southern&FL&FEB2001&8500&11000 Northern&NY&FEB2001&3000&4000 Northern&NY&MAR2001&6000&5000 Southern&FL&MAR2001&9800&13500 Northern&MA&MAR2001&1500&1000
"Africa","Boot","Addis Ababa","12","$29,761","$191,821","$769" "Asia","Boot","Bangkok","1","$1,996","$9,576","$80" "Canada","Boot","Calgary","8","$17,720","$63,280","$472" "Eastern Europe","Boot","Budapest","22","$74,102","$317,515","$3,341" "Middle East","Boot","Al-Khobar","10","$15,062","$44,658","$765" "Pacific","Boot","Auckland","12","$20,141","$97,919","$962" "South America","Boot","Bogota","19","$15,312","$35,805","$1,229" "United States","Boot","Chicago","16","$82,483","$305,061","$3,735" "Western Europe","Boot","Copenhagen","2","$1,663","$4,657","$129"
Region State Capital Bird South Georgia Atlanta 'Brown Thrasher' South 'North Carolina' Raleigh Cardinal North Connecticut Hartford Robin West Washington Olympia 'American Goldfinch' Midwest Illinois Springfield Cardinal