specifies variable alignment.
Valid in: | DATA step and PROC step |
Default: | YES |
Restriction: | Use only with SPD Server |
Engine: | SPD Engine only |
enables variable alignment.
disables variable alignment to allow the SPD Engine data set to be compatible with the SPD Server.
data testdata.size; length text $10 width 8 chars 8; text='Zero'; width=1; chars=4; output; text='Ten'; width=2; chars=3; output; text='Twenty'; width=2; chars=6; output; run; NOTE: The data set TESTDATA.SIZE has 3 observations and 3 variables. proc sql; select obslen from dictionary.tables where memname="SIZE"; Observation Length ----------- 32 select varnum, name, npos, length from dictionary.columns where memname="SIZE" order by npos; Column Number Column Column in Table Column Name Position Length -------------------------------------------------------------- 2 width 0 8 3 chars 8 8 1 text 16 10 quit; /* ------------------------------------------------------------------- */ data testdata.size (align=no); length text $10 width 8 chars 8; text='Zero'; width=1; chars=4; output; text='Ten'; width=2; chars=3; output; text='Twenty'; width=2; chars=6; output; run; NOTE: The data set TESTDATA.SIZE has 3 observations and 3 variables.
data testdata.size (align=no); length text $10 width 8 chars 8; text='Zero'; width=1; chars=4; output; text='Ten'; width=2; chars=3; output; text='Twenty'; width=2; chars=6; output; run; NOTE: The data set TESTDATA.SIZE has 3 observations and 3 variables. proc sql; select obslen from dictionary.tables where memname="SIZE"; Observation Length ----------- 26 select varnum, name, npos, length from dictionary.columns where memname="SIZE" order by npos; Column Number Column Column in Table Column Name Position Length -------------------------------------------------------------- 1 text 0 10 2 width 10 8 3 chars 18 8 quit; NOTE: The data set TESTDATA.SIZE has 3 observations and 3 variables.