📄 m27 - reading hierarchical files - 28 of 30.mht
字号:
From: <Saved by Microsoft Internet Explorer 5>
Subject:
Date: Tue, 9 Mar 2004 11:51:12 +0800
MIME-Version: 1.0
Content-Type: multipart/related;
boundary="----=_NextPart_000_022D_01C405CC.D1E7C070";
type="text/html"
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
This is a multi-part message in MIME format.
------=_NextPart_000_022D_01C405CC.D1E7C070
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Content-Location: http://www.sas.com/apps/OLTRN/59080/m27/m27_28.htm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><!-- InstanceBegin template=3D"/Templates/summary.dwt" =
codeOutsideHTMLIsLocked=3D"false" -->
<SCRIPT language=3DJavaScript>=0A=
<!--=0A=
=0A=
function SymError()=0A=
{=0A=
return true;=0A=
}=0A=
=0A=
window.onerror =3D SymError;=0A=
=0A=
//-->=0A=
</SCRIPT>
<SCRIPT language=3DJavaScript=20
src=3D"http://www.sas.com/apps/OLTRN/59080/tut.js">=0A=
</SCRIPT>
<SCRIPT language=3DJavaScript>=0A=
setPageTitle();=0A=
setCookie();=0A=
fixedTitle=3D"Lesson Summary";=0A=
=0A=
// Drop down menu link- =A9 Dynamic Drive (www.dynamicdrive.com)=0A=
// For full source code and 100's more DHTML scripts, visit =
http://www.dynamicdrive.com=0A=
// Credit MUST stay intact for use -->=0A=
=0A=
</SCRIPT>
<!-- InstanceBeginEditable name=3D"extrascript" -->
<SCRIPT language=3DJavaScript>=0A=
</SCRIPT>
<!-- InstanceEndEditable --><LINK=20
href=3D"http://www.sas.com/apps/OLTRN/59080/tut.css" rel=3Dstylesheet>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR></HEAD>
<BODY bgColor=3D#fffff0 leftMargin=3D0 topMargin=3D0 rightMargin=3D0 =
marginwidth=3D"0"=20
marginheight=3D"0">
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"100%"=20
background=3Dhttp://www.sas.com/apps/elearning/images/en/navimages/banner=
.gif=20
border=3D0>
<TBODY>
<TR>
<TD noWrap colSpan=3D2 height=3D49><FONT face=3D"Arial, Helvetica, =
sans-serif"=20
color=3D#a6caf0 size=3D-1>
<SCRIPT>setCourseTitle()</SCRIPT>
</FONT><BR><STRONG><FONT face=3D"Arial, Helvetica, sans-serif"=20
color=3D#ffffff size=3D-1>
<SCRIPT>setLessonTitle()</SCRIPT>
</FONT></STRONG> <IMG height=3D8 alt=3D""=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/bullet.gif" =
width=3D8> <FONT color=3D#ffffff size=3D2><STRONG>
<SCRIPT>document.write(myPage+" of "+eval(myModule))</SCRIPT>
</STRONG></FONT> </TD>
<TD vAlign=3Dbottom width=3D357 rowSpan=3D3><IMG height=3D72 =
alt=3D""=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/logo_top.gif=
"=20
width=3D357 align=3Dbottom></TD></TR>
<TR>
<TD vAlign=3Dbottom noWrap colSpan=3D2><IMG height=3D19 alt=3D""=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/tableft.gif"=
=20
width=3D9><A=20
onmouseover=3D"rOver('back');window.status=3D'Display the previous =
page.';return true"=20
accessKey=3Db onmouseout=3D"rOut('back');window.status=3D'';return =
true"=20
href=3D"javascript:%20prevPage()"><IMG height=3D19 alt=3Dback=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/back.gif"=20
width=3D30 border=3D0 name=3Dback></A><A=20
onmouseover=3D"rOver('next');window.status=3D'Display the next =
page.';return true"=20
accessKey=3Dn onmouseout=3D"rOut('next');window.status=3D'';return =
true"=20
href=3D"javascript:%20nextPage()"><IMG height=3D19 alt=3Dnext=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/next.gif"=20
width=3D30 border=3D0 name=3Dnext></A>
<SCRIPT>writeLessonMenu()</SCRIPT>
<A=20
onmouseover=3D"rOver('path');window.status=3D'Display the Learning =
Path.';return true"=20
accessKey=3Dp onmouseout=3D"rOut('path');window.status=3D'';return =
true"=20
href=3D"http://www.sas.com/apps/OLTRN/59080/paths.htm"><IMG =
height=3D19=20
alt=3D"Learning Path"=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/path.gif"=20
width=3D48 border=3D0 name=3Dpath></A>
<SCRIPT>writeHelpMenu()</SCRIPT>
<IMG height=3D19 alt=3D""=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/tabright.gif=
"=20
width=3D28></TD></TR>
<TR>
<TD vAlign=3Dbottom colSpan=3D2 height=3D3><IMG height=3D3 alt=3D""=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/border.gif" =
width=3D"100%"></TD></TR>
<TR vAlign=3Dtop bgColor=3D#fffff0>
<TD noWrap> </TD>
<TD vAlign=3Dcenter><BR><IMG height=3D1 alt=3D""=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/cleardot.gif=
"=20
width=3D411><BR><FONT face=3D"Arial, Helvetica, sans-serif" =
color=3D#003399=20
size=3D3><STRONG>
<SCRIPT>document.write(fixedTitle)</SCRIPT>
</STRONG></FONT></TD>
<TD><IMG height=3D64 alt=3D""=20
=
src=3D"http://www.sas.com/apps/elearning/images/en/navimages/arch.gif"=20
width=3D357 align=3Dtop></TD></TR></TBODY></TABLE><BR>
<CENTER>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" align=3Dcenter =
border=3D0>
<TBODY>
<TR>
<TD align=3Dleft>
<P>This page contains </P>
<UL><!-- InstanceBeginEditable name=3D"links" -->
<LI><A onmouseover=3D"window.status=3D'Go to the text summary =
section.'; "=20
onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m27/m27_28.htm#Text">a text=20
summary of the material taught in the lesson</A>=20
<LI><A onmouseover=3D"window.status=3D'Go to the syntax =
section.'; "=20
onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m27/m27_28.htm#Syntax">syntax=
=20
for statements and options</A>=20
<LI><A onmouseover=3D"window.status=3D'Go to the sample program =
section.'; "=20
onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m27/m27_28.htm#Sample">sample=
=20
programs</A>=20
<LI><A=20
onmouseover=3D"window.status=3D'Go to the points to remember =
section.'; "=20
onmouseout=3D"window.status=3D''"=20
=
href=3D"http://www.sas.com/apps/OLTRN/59080/m27/m27_28.htm#Points">points=
=20
to remember</A>. <!-- InstanceEndEditable --></LI></UL>
<P>
<HR>
</TD></TR></TBODY></TABLE>
<P>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" align=3Dcenter =
border=3D0>
<TBODY>
<TR>
<TD align=3Dleft>
<H2><STRONG><A name=3DText>Text Summary</A></STRONG> </H2>
<P><EM>To go to the page where a task, programming feature, or=20
concept was presented, select a=20
link.</EM></P></TD></TR></TBODY></TABLE><BR><!-- InstanceBeginEditable =
name=3D"textsummary" -->
<P align=3Dcenter>
<CENTER>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" border=3D0>
<TBODY>
<TR>
<TD><STRONG>Hierarchical Raw Data Files</STRONG><BR>Raw data files =
can be=20
hierarchical in structure, consisting of a header record and one =
or more=20
detail records. You can build a SAS data set from a hierarchical =
file by=20
creating one observation=20
<UL>
<LI>per detail record and storing each header record as part of =
the=20
observation=20
<LI>per header record and combining the information from detail =
records=20
into summary variables. </LI></UL></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"85%" border=3D0>
<TBODY>
<TR>
<TD><STRONG>Creating One Observation per Detail =
Record</STRONG><BR>In=20
order to <A=20
onmouseover=3D"window.status=3D'Display details on creating one =
observation for each detail record.'; "=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
href=3D"http://www.sas.com/apps/OLTRN/59080/m27/m27_2.htm">create =
one=20
observation per detail record</A>, it is necessary to distinguish =
between=20
header and detail records. Having a field that identifies the type =
of the=20
record makes this task easier.=20
<P>As you write the DATA step, use a <A=20
onmouseover=3D"window.status=3D'Display details on the RETAIN =
statement.'; "=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
href=3D"http://www.sas.com/apps/OLTRN/59080/m27/m27_3.htm">RETAIN=20
statement</A> to keep the header record as a part of each =
observation=20
until the next header record is encountered.=20
<P>Next, you need to read the field in each record that identifies =
the=20
record's type. Remember to use the <A=20
onmouseover=3D"window.status=3D'Display details on the @ line-hold =
specifier.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
href=3D"http://www.sas.com/apps/OLTRN/59080/m27/m27_3.htm#input">@ =
line-hold=20
specifier</A> to hold the current value of each record type so =
that the=20
other values in the record can be read.=20
<P>Use an <A=20
onmouseover=3D"window.status=3D'Display details on the IF-THEN =
statement.';"=20
onclick=3DsuggestBack() onmouseout=3D"window.status=3D''"=20
href=3D"http://www.sas.com/apps/OLTRN/59080/m27/m27_6.htm">IF-THEN =
statement</A> to check for the condition that the record is a =
header=20
record. If the record is a header record, you need to execute an =
INPUT=20
statement to read the variable values for that record.=20
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -