sas编程

data a;
set sashelp.class;
proc print;

data scores;
infile cards truncover;
input name $1-10 sex $11 age 12-13;
cards;
Justine F12
Bob M13
;
run;

data;
/*input Univ $ Plc $Zip;*/
/*input Univ $12. Plc $Zip;*/
input Univ: $12. Plc$ Zip;
cards;
MIT Boston 100023
TsinghuaUniv Beijing 100084
;

data;
input firstname: $9. lastname: $9. age;
cards;
Xiaoni Ann 20
Jiani An 22
I.Altman hat 5
;
proc print;

data a;
input (name score1-score5)($9.,4*4.);
cards;
Whittaker 121 114 137 156 142
Smythe 111 125 456 785 892
;
proc print;

data a;
input name $1-9 score1 11-13 score2 15-17 score3 19-21 score4 23-25 score5 27-29;
cards;
Whittaker 121 114 137 156 142
Smythe 111 125 456 785 892
;
proc print;

data a;
input name: $9. score1 score2 score3 score4 score5;
cards;
Whittaker 121 114 137 156 142
Smythe 111 125 456 785 892
;
proc print;

data one;
input @2 Name$+1 age;
/*@从前数从第二个开始*/
/*+2是向后跳2位，空格集合算一位*/
cards;
sara 15
kitty 23
ann 58
;
proc print;

data ;
input a b c d;
cards;
1 2 3 4
5 6 7 8
;
proc print;

data;
input a b;
cards;
1 2 3 4
5 6 7 8
;
proc print;

data;
input a b@;
cards;
1 2 3 4
5 6 7 8
;
proc print;

data;
input a b@@;
cards;
1 2 3 4
5 6 7 8
;
proc print;

data ;
input a b c d;
cards;
1 2 3 4
5 6 7 8
;
proc print;

data;
input a b;
input c d;
cards;
1 2 3 4
5 6 7 8
;
proc print;

/*指针不换行*/
data;
input a b@;
input c d;
cards;
1 2 3 4
5 6 7 8
;
proc print;

/*指针停*/
data;
input a b@@;
input c d;
cards;
1 2 3 4
5 6 7 8
;
proc print;

FILENAME REFFILE '/folders/myfolders/AXN/table.xls';

PROC IMPORT DATAFILE=REFFILE
DBMS=XLS
OUT=AXN.'table'n;
GETNAMES=YES;
RUN;