4/20/23, 11:33 PM Program Summary - Create_Datasets.
sas
Program Summary - Create_Datasets.sas
Execution Environment
Author: u63070480
File: /home/u63070480/Create_Datasets.sas
SAS Platform: Linux LIN X64 3.10.0-1062.12.1.el7.x86_64
SAS Host: [Link]
SAS Version: 9.04.01M7P08062020
SAS Locale: en_US
Submission Time: 4/20/2023, [Link] PM
Browser Host: [Link]
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/[Link]
User Agent:
Safari/537.36
Application Server: [Link]
Code: Create_Datasets.sas
FILENAME REFFILE '/home/u63070480/BAN110dataset(5).xls';
PROC IMPORT DATAFILE=REFFILE
DBMS=XLS
OUT=[Link];
GETNAMES=YES;
RUN;
PROC CONTENTS DATA=[Link]; RUN;
proc standard data=patient replace print out=patient_imputed;
var DBP;
format DBP 8.;
run;
proc print data=patient_imputed;
run;
Log: Create_Datasets.sas
Notes (9)
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69 FILENAME REFFILE '/home/u63070480/BAN110dataset(5).xls';
70 PROC IMPORT DATAFILE=REFFILE
71 DBMS=XLS
72 OUT=[Link];
73 GETNAMES=YES;
74 RUN;
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with
options MSGLEVEL=I.
NOTE: The import data set has 22 observations and 7 variables.
NOTE: [Link] data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.01 seconds
memory 1620.65k
OS Memory 26264.00k
Timestamp 04/21/2023 [Link] AM
Step Count 181 Switch Count 2
Page Faults 0
Page Reclaims 275
Page Swaps 0
Voluntary Context Switches 13
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 328
75 PROC CONTENTS DATA=[Link]; RUN;
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.03 seconds
user cpu time 0.04 seconds
system cpu time 0.00 seconds
memory 1744.90k
OS Memory 25768.00k
Timestamp 04/21/2023 [Link] AM
about:blank 1/3
4/20/23, 11:33 PM Program Summary - Create_Datasets.sas
Step Count 182 Switch Count 0
Page Faults 0
Page Reclaims 97
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 16
76 proc standard data=patient replace print out=patient_imputed;
77 var DBP;
78 format DBP 8.;
79 run;
NOTE: The data set WORK.PATIENT_IMPUTED has 22 observations and 7 variables.
NOTE: PROCEDURE STANDARD used (Total process time):
real time 0.01 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 930.25k
OS Memory 25768.00k
Timestamp 04/21/2023 [Link] AM
Step Count 183 Switch Count 2
Page Faults 0
Page Reclaims 156
Page Swaps 0
Voluntary Context Switches 13
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
80 proc print data=patient_imputed;
81 run;
NOTE: There were 22 observations read from the data set WORK.PATIENT_IMPUTED.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.03 seconds
user cpu time 0.04 seconds
system cpu time 0.00 seconds
memory 668.31k
OS Memory 25508.00k
Timestamp 04/21/2023 [Link] AM
Step Count 184 Switch Count 0
Page Faults 0
Page Reclaims 77
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 16
82
83 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
93
Results: Create_Datasets.sas
The CONTENTS Procedure
Data Set Name [Link] Observations 22
Member Type DATA Variables 7
Engine V9 Indexes 0
Created 04/20/2023 [Link] Observation Length 80
Last Modified 04/20/2023 [Link] Deleted Observations 0
Protection Compressed NO
Data Set Type Sorted NO
Label
Data Representation SOLARIS_X86_64, LINUX_X86_64, ALPHA_TRU64, LINUX_IA64
Encoding utf-8 Unicode (UTF-8)
Engine/Host Dependent Information
Data Set Page Size 131072
Number of Data Set Pages 1
First Data Page 1
Max Obs per Page 1635
Obs in First Data Page 22
Number of Data Set Repairs 0
Filename /saswork/SAS_work64510001F3A0_odaws01-[Link]/SAS_work2B960001F3A0_odaws01-[Link]/patient.sas7bdat
Release Created 9.0401M7
Host Created Linux
about:blank 2/3
4/20/23, 11:33 PM Program Summary - Create_Datasets.sas
Engine/Host Dependent Information
Inode Number 335565777
Access Permission rw-r--r--
Owner Name u63070480
File Size 256KB
File Size (bytes) 262144
Alphabetic List of Variables and Attributes
# Variable Type Len Format Informat Label
7 AE Char 14 $14. $14. AE
3 Age Num 8 BEST12. Age
4 DBP Num 8 BEST12. DBP
2 Gender Char 12 $12. $12. Gender
5 HR Num 8 BEST12. HR
1 Patno Char 14 $14. $14. Patno
6 Visit Char 10 $10. $10. Visit
The STANDARD Procedure
Standard
Name Mean Deviation N Label
DBP 95.111111 50.420979 18 DBP
Obs Patno Gender Age DBP HR Visit AE
1 1 F 40 80 56 11/12/2000 0
2 2 M 55 90 600 03/07/1999 X
3 3 F 60 95 58 12/31/1997 0
4 3 M 17 85 208 12/31/1998 1
5 2 M 85 90 72 05/07/1999 1
6 4 M 52 110 10 0
7 5 M 62 95 62 01/03/1996 1
8 M 14 300 81 1
9 5 M 98 86 702 01/03/1998 0
10 3 M 60 95 81 12/31/1998 0
11 Y M 78 75 55 V
12 M 18 95 65 06/08/1998 1
13 1 M 40 80 600 11/12/1998 0
14 X M 5 2 75
15 11 M 14 72 402 02/28/1990 0
16 4 F 90 110 100 1
17 M 90 95 92 2
18 11 M 14 72 98 02/28/1990 0
19 3 M 60 95 46 1
20 7 M 60 95 600 12/31/1998 0
21 3 M 17 85 208 12/31/1998 1
22 2 M 85 90 72 05/07/1999 1
about:blank 3/3
