4/20/23, 11:26 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: ODAWS02-USW2-2.ODA.SAS.COM
SAS Version: 9.04.01M7P08062020
SAS Locale: en_US
Submission Time: 4/20/2023, 11:24:37 PM
Browser Host: 142.198.116.128
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0
User Agent:
Safari/537.36
Application Server: ODAMID00-USW2-2.ODA.SAS.COM
Code: Create_Datasets.sas
FILENAME REFFILE '/home/u63070480/BAN110dataset(5).xls';
PROC IMPORT DATAFILE=REFFILE
DBMS=XLS
OUT=DataPrep;
GETNAMES=YES;
RUN;
PROC CONTENTS DATA=DataPrep;
RUN;
*Creating a new dataset with HR value 600;
Data HR_600;
set DataPrep;
where HR=600;
This study source was downloaded by 100000862067749 from CourseHero.com on 04-20-2023 21:23:21 GMT -05:00
https://www.coursehero.com/file/143805150/BAN110-2docx/
run;
proc print data=hr_600 n;
run;
Log: Create_Datasets.sas
Errors (1)
Warnings (2)
Notes (8)
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=DataPrep;
73 GETNAMES=YES;
74 RUN;
NOTE: Import cancelled. Output dataset WORK.DATAPREP already exists. Specify REPLACE option to overwrite it.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 700.50k
OS Memory 25488.00k
Timestamp 04/21/2023 03:24:36 AM
Step Count 136 Switch Count 0
Page Faults 0
Page Reclaims 143
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
about:blank 1/3
4/20/23, 11:26 PM Program Summary - Create_Datasets.sas
75 PROC CONTENTS DATA=DataPrep;
76 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 1755.75k
OS Memory 25512.00k
Timestamp 04/21/2023 03:24:36 AM
Step Count 137 Switch Count 0
Page Faults 0
Page Reclaims 92
Page Swaps 0
Voluntary Context Switches 2
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 16
77 *Creating a new dataset with HR value 600;
78 Data HR_600;
79 set DataPrep;
80 where HR=600;
81 This study source was downloaded by 100000862067749 from CourseHero.com on 04-20-2023 21:23:21 GMT -05:00
____
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
82 https://www.coursehero.com/file/143805150/BAN110-2docx/
83 run;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.HR_600 may be incomplete. When this step was stopped there were 0 observations and 7 variables.
WARNING: Data set WORK.HR_600 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 929.09k
OS Memory 25512.00k
Timestamp 04/21/2023 03:24:36 AM
Step Count 138 Switch Count 0
Page Faults 0
Page Reclaims 93
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 8
84 proc print data=hr_600 n;
85 run;
NOTE: No observations in data set WORK.HR_600.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 619.59k
OS Memory 25252.00k
Timestamp 04/21/2023 03:24:36 AM
Step Count 139 Switch Count 0
Page Faults 0
Page Reclaims 51
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
86
87 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
97
Results: Create_Datasets.sas
about:blank 2/3
4/20/23, 11:26 PM Program Summary - Create_Datasets.sas
The CONTENTS Procedure
Data Set Name WORK.DATAPREP Observations 22
Member Type DATA Variables 7
Engine V9 Indexes 0
Created 04/20/2023 23:16:54 Observation Length 80
Last Modified 04/20/2023 23:16:54 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-usw2-2.oda.sas.com/SAS_work2B960001F3A0_odaws01-usw2-2.oda.sas.com/dataprep.sas7bdat
Release Created 9.0401M7
Host Created Linux
Inode Number 335558920
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
about:blank 3/3
