[工學(xué)]sas workshop-文庫吧
2024-10-03 23:42 本頁面
【正文】 at 3. / math 3.。 DATALINES。 John 89 95 University Information Technology Services Center for Statistical and Mathematical Computing November 10, 2021 SAS Data Management USING INFORMAT ? INFORMAT defines a format of data entry and FORMAT for data output ? COMMA and PERCENT INPUT ine COMMA9. saving PERCENT3.。 DATALINES。 170,200 89% 92,540 95% ? MMDDYY and DOLLAR INPUT dates MMDDYY10. sales 。 DATALINES。 10/01/2021 $343,750 10/05/2021 $9,784,650 University Information Technology Services Center for Statistical and Mathematical Computing November 10, 2021 SAS Data Management INFILE STATEMENT 1 ? INFILE specifies an external data file that is created in advance. INFILE ?c:\temp\sas\?。 INPUT name $6. id 5. stat math (3.)。 ? If the data file contains missing values, add the MISSOVER option to INFILE. ? The MISSOVER option treats all remaining variables without values as missing values. INFILE ?c:\temp\sas\? MISSOVER。 University Information Technology Services Center for Statistical and Mathematical Computing November 10, 2021 SAS Data Management INFILE STATEMENT 2 ? Alternatively, use FILENAME to make an alias of an external file. ? Like LIBNAME, FILENAME makes it easy to referring a file name especially when the name and path are long. FILENAME gFile ?c:\temp\?。 DATA 。 INFILE gFile MISSOVER。 INPUT name $6. id 5. stat math (3.)。 RUN。 University Information Technology Services Center for Statistical and Mathematical Computing November 10, 2021 SAS Data Management INFILE STATEMENT 3 ? DLM specifies a delimiter. More than one delimiter can be used. ., *iu* ? DSD (Delimiter Sensitive Data) assumes a ma delimiter and is needed for missing values INFILE DATALINES DLM=?,? DSD。 INPUT name $ id stat math。 DATALINES。 John,10091,89,95 Rachel,10100,99 … University Information Technology Services Center for Statistical and Mathematical Computing November 10, 2021 SAS Data Management READ ODD STRINGS ? What if a string variable is long and/or contain mas? Use ampersand (amp。) INFILE DATALINES DLM=?,? DSD。 INPUT name : $20. title amp。 $100.。 DATALINES。 Lindblom,”Still Muddling, Not Yet Through” Park, “Reading “”Small is Beautiful””” ? How to read quotation marks in a string? Use tilde(~) INPUT name : $20 title ~ $100.。 DATALINES。 Lindblom,”Still Muddling, Not Yet Through” University Information Technology Services Center for Statistical and Mathematical Computing November 10, 2021 SAS Data Management READ THROUGH NETWORK ? SAS can read external data files through TCP/IP ( and ftp) FILENAME masil URL 39。 DATA 。 INFILE masil FIRSTOBS=1。 INPUT name $6. id 5. stat math (3.)。 ? URL denotes HTTP (protocol) ? FIRSTOBS=1 tells SAS to read observations from the 1st row University Information Technology Services Center for Statistical and Mathematical Computing November 10, 2021 SAS Data Management VIEW A DATA SET ? PROC CONTENTS displays data structures of a data set. PROC CONTENTS DATA=。 RUN。 ? PROC MEANS displays summary statistics of a data set. PROC MEANS DATA=。 RUN。 ? PROC PRINT displays values of variables in a data set. PROC PRINT DATA=。 VAR stat math。 University Information Technology Services Center for Stati
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1