Solution
Vidhi answered on
Feb 24 2021
SAS files/code files/Analysis of Means 1.ctk
Analysis of Means
Analysis of means simultaneously compares treatment means to their overall mean.
ec0de2e2-e910-498d-95e2-7b2450166e70
ANOM
3.7
SAS Studio Task Reference Guide
The ANOM Procedure
SAS Tutorials
Response variable:
Group variable:
Group size variable:
Group analysis by:
DATA
DATA
Sort data before chart creation
Chart type:
Mean chart with boxes
Proportion chart
Rate chart
Mean chart
Group size:
Group size variable
Constant group size
Size of groups
ROLES
ADDITIONAL ROLES
OPTIONS
DECISION LIMITS
Method:
Compute from data
Probability of Type I e
or:
Use stored limits
To create a stored limits table, select the Save decision limits option on the OUTPUT tab.
INSET OPTIONS
Include inset table
Inset position:
Top left
Top right
Inset statistics
Significance level
Degrees of freedom
Average of group means
Mean square e
o
CHART OPTIONS
Display markers for groups
Display vertical needles
TABULAR OUTPUT
Display table of points that exceed limits
OUTPUT
OUTPUT DATA SETS
Save summary statistics and decision limits
Data set name:
Save decision limits
Data set name:
At least one inset statistic must be selected.
## build the inset statement
#if($insetCheck == "1")
#set($insetstmt = "inset")
#if($alpha2 == '1') #set($insetstmt = $insetstmt + ' alpha') #end
#if($dfe == '1') #set($insetstmt = $insetstmt + ' dfe') #end
#if($mean == '1') #set($insetstmt = $insetstmt + ' mean') #end
#if($mse == '1') #set($insetstmt = $insetstmt + ' mse') #end
#set($insetstmt = $insetstmt + '/position=' + $position + ';')
#else
#set($insetstmt = "")
#end
ods noproctitle;
ods graphics / imagemap=on;
#if($byVar.size() > 0 || $sortCheck == 1)
proc sort data=$dataset out=_anomSorted;
by
#if($byVar.size() > 0)
#foreach($item in $byVar) $item #end
#end
#foreach($item in $groupVar) $item #end;
#if ($dataset.getWhereClause() != '')
where $dataset.getWhereClause();
#end
run;
proc anom data=_anomSorted
#else proc anom data=$dataset
#end
#if ($methodCombo == 'storedlimits') limits=$limitsdata #end
;
#if($chartCombo == 'boxChart') boxchart
#elseif($chartCombo == 'pChart') pchart
#elseif($chartCombo == 'xChart') xchart
#else uchart
#end
#foreach($item in $responseVar) $item #end * #foreach($item in $groupVar) $item #end
#if($groupnCombo) groupn=
#if($groupnCombo == 'varselect') #foreach($item in $groupnVar) $item #end
#else $groupNum
#end
#end
#if($methodCombo == 'computelimits') alpha=$alpha #end
#if($markers == 1) markers #end
#if($needles == 0) noneedles #end
#if($tableCheck == 1) table(exceptions) #end
#if($outlimCheck == '1') outlimits=$outlim #end
#if($outtableCheck == '1') outtable=$outtable #end
;
#if($byVar.size() > 0) by #foreach($item in $byVar) $item #end;#end
$insetstmt
un;
#if($byVar.size() > 0 || $sortCheck == 1)
proc delete data=_anomSorted;
un;
#end
{"methodCombo":"computelimits","rolesGroup":"ROLES","outlim":"_outlimits0001","outtable":"_outtable0001","groupNum":"","needles":"1","chartGroup":"CHART OPTIONS","outputTab":"OUTPUT","tableCheck":"","nw":"Top left","xChart":"Mean chart","groupnVar":"","byVar":"","sasVersion":"9.450000000000001","insetCheck":"","outlimCheck":"","sortCheck":"1","dataTab":"DATA","markers":"","optionsTab":"OPTIONS","outtableCheck":"","groupVar":"json:[{\"value\":\"RAW\",\"type\":\"Numeric\",\"length\":8,\"format\":\"BEST.\",\"informat\":\"\",\"className\":\"RoleObject\"}]","storedlimits":"Use stored limits","otherRolesGroup":"ADDITIONAL ROLES","position":"nw","varselect":"Group size variable","limitsGroup":"DECISION LIMITS","numselect":"Constant group size","outputGroup":"OUTPUT DATA SETS","boxChart":"Mean chart with boxes","alpha2":"1","alpha":"0.05","mean":"1","sasOS":"Linux LIN X64 3.10.0-693.21.1.el7.x86_64","uChart":"Rate chart","tableGroup":"TABULAR OUTPUT","mse":"1","dataGroup":"DATA","computelimits":"Compute from data","chartCombo":"boxChart","insetGroup":"INSET OPTIONS","insetStats":"Inset statistics","groupnCombo":"varselect","pChart":"Proportion chart","responseVar":"json:[{\"value\":\"BOILED\",\"type\":\"Numeric\",\"length\":8,\"format\":\"BEST.\",\"informat\":\"\",\"className\":\"RoleObject\"}]","dfe":"1","dataset":{"li
arytable":"WORK.PETRO_EXCEL"},"ne":"Top right","limitsdata":{"li
arytable":"WORK.PETRO_EXCEL"},"limitsMessage":"To create a stored limits table, select the Save decision limits option on the OUTPUT tab."}
SAS files/code files/Bar Chart.ctk
Bar Chart
Bar charts compare numeric values or statistics between different values of a chart variable. Bar charts show the relative magnitude of data by displaying bars of varying height. Each bar represents a category of data.
A0EEED19-14E9-4AA8-9E3E-4F1B22B078F2
SGPLOT
3.7
SAS Studio Task Reference Guide
The SGPLOT Procedure
SAS Tutorials
Category:
Variable:
Subcategory:
URL variable:
Group analysis by:
Weight:
DATA
DATA
ROLES
ADDITIONAL ROLES
APPEARANCE
Include filter clause as footnote
Where clause:
TITLE AND FOOTNOTE
Title:
Font size (default: 14 pt):
Footnote:
Font size (default: 12 pt):
CHART ORIENTATION
Vertical
Horizontal
Options:
Display grouped bars:
Clustered side by side
Stacked on one anothe
Legend location:
Outside (default)
Inside
Measure:
Frequency count (default)
Frequency percent
Variable
Statistic:
Percent of the sum
Sum (default)
Mean
E
or bars:
(none)
Both
Uppe
Lowe
Type:
Confidence limit (default)
Standard deviation
Standard e
o
Specify a statistic multiplie
Multiplier:
Confidence level:
95% (default)
99%
90%
Use custom value
Custom confidence level (%):
BARS
Show labels
Set colo
Colo
Color transparency:
0% (default)
25%
50%
75%
100%
Details
Apply color gradient
Effect:
Gloss
Sheen
Crisp
Matte
Pressed
CATEGORY AXIS
Reverse tick values
Show tick values in data orde
Display label:
Label:
Rotate labels in case of tick collisions
Rotate by 45 degrees
Rotate by 90 degrees
Create a reference line
Reference value:
Reference value as label
Custom label
Label:
Line offset:
0 (default)
-0.5
-0.25
0.25
0.5
MEASURE AXIS
Show grid lines
Display label:
Display label:
Default label
No label
Statistics name in label
No statistics name in label
Custom label
Label:
Use logarithmic scale
Base value:
2
10 (default)
e
Axis baseline:
Rotate labels in case of tick collisions
Rotate by 45 degrees
Rotate by 90 degrees
Create a reference line
Reference value:
Reference value as label
Custom label
Label:
Specify minimum value
Minimum value:
Specify maximum value
Maximum value:
GRAPH SIZE
Units:
Inches (default)
Cms
Pixels
Width:
Height:
Width:
Height:
Width:
Height:
The maximum value of measure axis should be greater than or equal to the minimum value of measure axis.
##--Extract first item from list--##
#if($category.size()>0) #set($CAT=$category.get(0)) #end
#if($measure.size()>0) #set($RESP=$measure.get(0)) #end
#if($group.size()>0) #set($GRP=$group.get(0)) #end
#if($urlVar.size()>0) #set($URL=$urlVar.get(0)) #end
#if($byVar.size()>0) #set($BY=$byVar.get(0)) #end
#if($weight.size()>0) #set($WGT=$weight.get(0)) #end
##--Set Graph Size--##
#if($dimType=="in")
#set($WIDTH="$inchWidth$dimType")
#set($HEIGHT="$inchHeight$dimType")
#end
#if($dimType=="cm")
#set($WIDTH="$cmWidth$dimType")
#set($HEIGHT="$cmHeight$dimType")
#end
#if($dimType=="px")
#set($WIDTH="$pixelWidth$dimType")
#set($HEIGHT="$pixelHeight$dimType")
#end
##--Set output size--##
ods graphics / reset width=$WIDTH height=$HEIGHT imagemap;
#if($BY)
##--Sort data by BY variable--##
proc sort data=$dataSource out=_BarChartTaskData;
by $BY;
un;
#end
##--SGPLOT proc statement--##
proc sgplot data= #if($BY) _BarChartTaskData #else $dataSource #end#if($dataSource.getWhereClause()!="")(where=($dataSource.getWhereClause())) #end;
#if($BY)
##--BY Variable--##
by $BY;
#end
##--Build qouted strings for title and footnote to clean up any quotes provided by user--##
#if($titleString!="") #set($qTitleString=$CTMUtil.doubleQuoteString($titleString)) #end
#if($footnoteString!="") #set($qFootnoteString=$CTMUtil.doubleQuoteString($footnoteString)) #end
##--TITLE and FOOTNOTE--##
#set($pt="pt")
#if($titleString!="")
#set($titleSizePt="$titleSize$pt")
title height=$titleSizePt $qTitleString;
#end
#if($footnoteString!="" || ($dataSource.getWhereClause()!="" && $includeAsFootnote=='1'))
#set($footSizePt="$footnoteSize$pt")
#if($dataSource.getWhereClause()!="" && $includeAsFootnote=='1') footnote justify=left height=$footSizePt
#set($whereStr="$whereClause $dataSource.getWhereClause()") $CTMUtil.doubleQuoteString($whereStr);
#end
#if($footnoteString!="")
footnote2 justify=left height=$footSizePt $qFootnoteString;
#end
#end
#if(($useColor && $useColor=='1') || $barTrans!='0') #set ($SETATTRS='Yes')
#else #set($SETATTRS='No')
#end
##--Bar chart settings--##
#if($barOrient=='vertical') vbar $CAT
#else hbar $CAT
#end /
#if($RESP) response=$RESP #end
#if($URL) url=$URL #end
#if($GRP)
group=$GRP groupdisplay=$groupDisplay
#end
#if($SETATTRS=='Yes') fillattrs=(
#if($useColor=='1') color=$barColor #end
#if($barTrans!='0') transparency=$barTrans #end)
#end
#if($barStatLabels=='1') datalabel #end
#if($barLimits)
#if($barLimits!='none')
limits=$barLimits limitstat=$barLimitStat
#if($barNumStdChkbox && $barNumStdChkbox=='1') numstd=$barNumStd #end
#if($barLimitStat=='clm')
## Calculate alpha from confidence level
#if($confLevelCombo=="confLevel99Choice") alpha=0.01 #elseif($confLevelCombo=="confLevel90Choice") alpha=0.10
#elseif($confLevelCombo=="confLevelCustomChoice") #if($confLevel!=95) alpha=%sysevalf((100-$confLevel)/100) #end
#end
#end
#end
#end
#if($fillGradient=='1') fillType=gradient #end
#if($RESP)
#if($statChoiceResponse!='sum') stat=$statChoiceResponse #end
#else
#if($measureCombo!='freq') stat=$measureCombo #end
#end
#if($barSkin!='none') dataskin=$barSkin #end
#if($RESP)
#if($displayRespLabel1=='statsLabel') statlabel
#elseif($displayRespLabel1=='noStatsLabel') nostatlabel
#end
#end
#if($logAxis=='1') baseline=$logBaseline #end
#if($WGT) weight=$WGT #end
;
#set($catAxis=0)
#if($displayCatLabel!='defaultLabel' || $sortByData=='1' || $catReverse=='1' || $catLabelRotation=='1') #set($catAxis=1) #end
#if($catAxis=='1')
##--Category Axis--##
#if($barOrient=='vertical') xaxis
#else yaxis
#end
#if($sortByData=='1') discreteorder=data #end
#if($catReverse=='1') reverse #end
#if($displayCatLabel=='noLabel') display=(nolabel) #end
#if($displayCatLabel=='customLabel') label=$CTMUtil.doubleQuoteString($catLabel) #end
#if($catLabelRotation=='1') valuesrotate=#if($catTickRotate=='catDiagonalRotation') diagonal #else vertical #end #end
;
#end
#set($respAxis=0)
#if(($measureCombo=='measureChoiceVar' && $measure.size()>0 && ($displayRespLabel1=='noLabel' || $displayRespLabel1=='customLabel'))
|| ($measureCombo!='measureChoiceVar' && ($displayRespLabel2=='noLabel' || $displayRespLabel2=='customLabel'))
|| $showRespGrid=='1' || $logAxis=='1' || $respLabelRotation=='1' || $respAxisMin=='1' || $respAxisMax=='1') #set($respAxis=1) #end
#if($respAxis=='1')
##--Response Axis--##
#if($barOrient=='vertical') yaxis
#else xaxis
#end
#if($respAxisMin=='1') min=$respAxisMinValue #end
#if($respAxisMax=='1') max=$respAxisMaxValue #end
#if($showRespGrid=='1') grid #end
#if(($measureCombo=='measureChoiceVar' && $measure.size()>0 && $displayRespLabel1=='noLabel') || ($measureCombo!='measureChoiceVar' && $displayRespLabel2=='noLabel')) display=(nolabel) #end
#if(($measureCombo=='measureChoiceVar' && $measure.size()>0 && $displayRespLabel1=='customLabel') || ($measureCombo!='measureChoiceVar' && $displayRespLabel2=='customLabel')) label=$CTMUtil.doubleQuoteString($respLabel) #end
#if($logAxis=='1')
type=log #if($logBaseCombo!='10') logbase=$logBaseCombo #end
#end
#if($respLabelRotation=='1') valuesrotate=#if($respTickRotate=='respDiagonalRotation') diagonal #else vertical #end #end
;
#end
#if($catRefLine=='1')
##--Category Reference Line--##
refline #if($CAT.get('type')=='Char') $CTMUtil.doubleQuoteString($catRefLineValue) #else $catRefLineValue #end
#if($barOrient=='vertical') axis=x
#else axis=y
#end
lineattrs=(thickness=2 color=blue)
#if($catRefLineOffset!='0') discreteoffset=$catRefLineOffset #end
label#if($catRefLabel=='catRefCustom')=$CTMUtil.doubleQuoteString($catRefCustomLabel) #end
labelattrs=(color=blue)
;
#end
#if($respRefLine=='1')
##--Response Reference Line--##
refline $respRefLineValue
#if($barOrient=='vertical') axis=y
#else axis=x
#end
lineattrs=(thickness=2 color=green)
label#if($respRefLabel=='respRefCustom')=$CTMUtil.doubleQuoteString($respRefCustomLabel) #end
labelattrs=(color=green)
;
#end
#if($GRP && $legendLoc=='inside')
##--Legend Settings--##
keylegend / location=$legendLoc;
#end
un;
##--Clean up--##
ods graphics / reset;
#if($titleString!="") title; #end
#if($footnoteString!="" || ($dataSource.getWhereClause()!="" && $includeAsFootnote=='1'))
#if($dataSource.getWhereClause()!="" && $includeAsFootnote=='1') footnote; #end
#if($footnoteString!="") footnote2; #end
#end
#if($BY)
proc datasets li
ary=WORK noprint;
delete _BarChartTaskData;
un;
#end
{"customLabel":"Custom label","catLabelRotation":"0","lower":"Lower","statsLabel":"Statistics name in label","respAxisMinValue":"","confLevelCombo":"confLevelDefaultChoice","inchWidth":"6.4","appearanceTab":"APPEARANCE","barTrans50Choice":"50%","catRefLineOffset50Choice":"0.5","barsGroup":"BARS","footnoteString":"","barTrans100Choice":"100%","catRefLineOffset":"0","confLevelCustomChoice":"Use custom value","graphSize":"GRAPH SIZE","logBaseCombo":"10","statChoiceResponse":"sum","orientation":"CHART ORIENTATION","barOrient":"vertical","respRefCustomLabel":"","catDiagonalRotation":"1","respAxisMin":"0","respAxisMax":"0","measureChoicePercent":"Frequency percent","category":"json:[{\"value\":\"BOILED\",\"type\":\"Numeric\",\"length\":8,\"format\":\"BEST.\",\"informat\":\"\",\"className\":\"RoleObject\"}]","horizontal":"0","titleString":"","includeAsFootnote":"0","cmWidth":"16","outside":"Outside (default)","sortByData":"0","respDiagonalRotation":"1","respVerticalRotation":"0","pressed":"Pressed","catRefValue":"1","groupedBarStyle":"Display grouped bars:","catRefLabel":"catRefValue","displayRespLabel1":"defaultLabel","CLM":"Confidence limit (default)","displayRespLabel2":"defaultLabel","title":"TITLE AND FOOTNOTE","cmHeight":"12","statChoicePercent":"Percent of the sum","catRefCustomLabel":"","sheen":"Sheen","sasOS":"Linux LIN X64 3.10.0-693.21.1.el7.x86_64","barLimits":"none","barTrans25Choice":"25%","catRefLineOffsetNegative50Choice":"-0.5","barTrans75Choice":"75%","statChoiceSum":"Sum (default)","dataGroup":"DATA","groupDisplay":"cluster","urlVar":"","barTransDefaultChoice":"0% (default)","barDetails":"Details","crisp":"Crisp","catRefLineOffsetNegative25Choice":"-0.25","gloss":"Gloss","catRefLine":"0","catTickRotate":"catDiagonalRotation","displayCatLabel":"defaultLabel","stdE
":"Standard e
or","respRefCustom":"0","logAxis":"0","stdDev":"Standard deviation","rolesGroup":"ROLES","whereClause":"Where clause:","vertical":"1","respTickRotate":"respDiagonalRotation","both":"Both","statChoiceMean":"Mean","respRefValue":"1","matte":"Matte","catRefLineOffset25Choice":"0.25","pixelWidth":"640","logBase2":"2","measureCombo":"freq","measureAxis":"MEASURE AXIS","logBase10":"10 (default)","pixelHeight":"480","barSkin":"none","catReverse":"0","none":"(none)","measureChoiceFreq":"Frequency count (default)","barNumStd":"1","byVar":"","sasVersion":"9.450000000000001","logBaseE":"e","logBaseline":"","respAxisMaxValue":"","dataTab":"DATA","defaultLabel":"Default label","confLevel99Choice":"99%","catRefLineValue":"","catLabel":"","subcatGroup":"Options:","confLevelDefaultChoice":"95% (default)","cm":"Cms","barColor":"#CAD5E5","respRefLineValue":"","catRefCustom":"0","stack":"0","dataSource":{"li
arytable":"WORK.PETRO_EXCEL"},"weight":"","measure":"","respRefLine":"0","upper":"Upper","inchHeight":"4.8","catRefLineOffsetDefaultChoice":"0 (default)","noStatsLabel":"No statistics name in label","barLimitStat":"clm","measureChoiceVar":"Variable","titleSize":"14","footnoteSize":"12","confLevel90Choice":"90%","useColor":"0","showRespGrid":"1","fillGradient":"0","noLabel":"No label","barTrans":"0","respLabel":"","dimType":"in","in":"Inches (default)","barStatLabels":"0","respRefLabel":"respRefValue","respLabelRotation":"0","px":"Pixels","catVerticalRotation":"0","legendLoc":"outside","inside":"Inside","barNumStdChkbox":"0","cluster":"1","confLevel":"95","addRolesGroup":"ADDITIONAL ROLES","categoryAxis":"CATEGORY AXIS","group":"","statisticGroup":"Statistic:"}
SAS files/code files/Box Plot.ctk.log
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 70 71 /* Generated Code (IMPORT) */ 72 /* Source File: qfile_636864736100254912_124745_2.xlsx */ 73 /* Source Path: /home/shaziyaislam260 */ 74 /* Code generated on: 2/24/19, 3:56 PM */ 75 76 %web_drop_table(WORK.IMPORT); NOTE: Table WORK.IMPORT has been dropped. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 45.56k OS Memory 27300.00k Timestamp 02/24/2019 11:32:47 AM Step Count 32 Switch Count 2 Page Faults 0 Page Reclaims 58 Page Swaps 0 Voluntary Context Switches 11 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 77 78 79 FILENAME REFFILE '/home/shaziyaislam260/qfile_636864736100254912_124745_2.xlsx'; 80 81 PROC IMPORT DATAFILE=REFFILE 82 DBMS=XLSX 83 OUT=WORK.IMPORT; 84 GETNAMES=YES; 85 RUN; NOTE: The import data set has 26 observations and 2 variables. NOTE: WORK.IMPORT data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 2603.31k OS Memory 29864.00k Timestamp 02/24/2019 11:32:47 AM Step Count 33 Switch Count 2 Page Faults 0 Page Reclaims 633 Page Swaps 0 Voluntary Context Switches 13 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 264 86 87 PROC CONTENTS DATA=WORK.IMPORT; RUN; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.04 seconds user cpu time 0.04 seconds system cpu time 0.00 seconds memory 2358.90k OS Memory 29100.00k Timestamp 02/24/2019 11:32:47 AM Step Count 34 Switch Count 0 Page Faults 0 Page Reclaims 290 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 6 Block Input Operations 0 Block Output Operations 16 88 89 90 %web_open_table(WORK.IMPORT); 91 proc import datafile = '/home/shaziyaislam260/qfile_636864736100254912_124745_2.xlsx' 92 out = petro_excel 93 dbms = xlsx 94 replace 95 ; 96 run; NOTE: The import data set has 26 observations and 2 variables. NOTE: WORK.PETRO_EXCEL data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 2607.50k OS Memory 31144.00k Timestamp 02/24/2019 11:32:47 AM Step Count 35 Switch Count 2 Page Faults 0 Page Reclaims 599 Page Swaps 0 Voluntary Context Switches 16 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 264 97 98 99 100 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 112
SAS files/code files/Data Exploration.ctk.log
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 70 71 /* Generated Code (IMPORT) */ 72 /* Source File: qfile_636864736100254912_124745_2.xlsx */ 73 /* Source Path: /home/shaziyaislam260 */ 74 /* Code generated on: 2/24/19, 3:56 PM */ 75 76 %web_drop_table(WORK.IMPORT); NOTE: Table WORK.IMPORT has been dropped. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 45.56k OS Memory 27300.00k Timestamp 02/24/2019 11:32:47 AM Step Count 32 Switch Count 2 Page Faults 0 Page Reclaims 58 Page Swaps 0 Voluntary Context Switches 11 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 77 78 79 FILENAME REFFILE '/home/shaziyaislam260/qfile_636864736100254912_124745_2.xlsx'; 80 81 PROC IMPORT DATAFILE=REFFILE 82 DBMS=XLSX 83 OUT=WORK.IMPORT; 84 GETNAMES=YES; 85 RUN; NOTE: The import data set has 26 observations and 2 variables. NOTE: WORK.IMPORT data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 2603.31k OS Memory 29864.00k Timestamp 02/24/2019 11:32:47 AM Step Count 33 Switch Count 2 Page Faults 0 Page Reclaims 633 Page Swaps 0 Voluntary Context Switches 13 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 264 86 87 PROC CONTENTS DATA=WORK.IMPORT; RUN; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.04 seconds user cpu time 0.04 seconds system cpu time 0.00 seconds memory 2358.90k OS Memory 29100.00k Timestamp 02/24/2019 11:32:47 AM Step Count 34 Switch Count 0 Page Faults 0 Page Reclaims 290 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 6 Block Input Operations 0 Block Output Operations 16 88 89 90 %web_open_table(WORK.IMPORT); 91 proc import datafile = '/home/shaziyaislam260/qfile_636864736100254912_124745_2.xlsx' 92 out = petro_excel 93 dbms = xlsx 94 replace 95 ; 96 run; NOTE: The import data set has 26 observations and 2 variables. NOTE: WORK.PETRO_EXCEL data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 2607.50k OS Memory 31144.00k Timestamp 02/24/2019 11:32:47 AM Step Count 35 Switch Count 2 Page Faults 0 Page Reclaims 599 Page Swaps 0 Voluntary Context Switches 16 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 264 97 98 99 100 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 112
SAS files/code files/download.pdf
2/24/2019 Results: Program 2
1/1
SAS files/code files/Log_ Program 2.pdf
2/24/2019 Log: Program 2
1/2
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
70
71 /* Generated Code (IMPORT) *
72 /* Source File: qfile_636864736100254912_124745_2.xlsx *
73 /* Source Path: /home/shaziyaislam260 *
74 /* Code generated on: 2/24/19, 3:56 PM *
75
76 %web_drop_table(WORK.IMPORT);
77
78
79 FILENAME REFFILE '/home/shaziyaislam260/qfile_636864736100254912_124745_2.xlsx';
80
81 PROC IMPORT DATAFILE=REFFILE
82 DBMS=XLSX
83 OUT=WORK.IMPORT;
84 GETNAMES=YES;
85 RUN;
NOTE: The import data set has 26 observations and 2 variables.
NOTE: WORK.IMPORT 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.00 seconds
memory 2608.43k
OS Memory 28840.00k
Timestamp 02/24/2019 10:51:06 AM
Step Count 18 Switch Count 2
Page Faults 0
Page Reclaims 938
Page Swaps 0
Voluntary Context Switches 14
Involuntary Context Switches 0
Block Input Operations 24
Block Output Operations 264
86
87 PROC CONTENTS DATA=WORK.IMPORT; RUN;
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.04 seconds
user cpu time 0.04 seconds
system cpu time 0.01 seconds
memory 2650.12k
OS Memory 28588.00k
Timestamp 02/24/2019 10:51:06 AM
Step Count 19 Switch Count 0
Page Faults 0
Page Reclaims 1109
Page Swaps 0
Voluntary Context Switches 2
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 8
88
89
90 %web_open_table(WORK.IMPORT);
91 Proc print REFFILE
_______
22
76
ERROR 22-322: Syntax e
or, expecting one of the following: ;, BLANKLINE, CONTENTS, DATA, DOUBLE, GRANDTOTAL_LABEL, GRANDTOT_LABEL,
GRAND_LABEL, GTOTAL_LABEL, GTOT_LABEL, HEADING, LABEL, N, NOOBS, NOSUMLABEL, OBS, ROUND, ROWS, SPLIT, STYLE,
SUMLABEL, UNIFORM, WIDTH.
ERROR 76-322: Syntax e
or, statement will be ignored.
92
93
94
95 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
96 ODS HTML CLOSE;
97 &GRAPHTERM; ;*';*";*/;RUN;QUIT;
NOTE: The SAS System stopped processing this step because of e
ors.
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 69.12k
OS Memory 28324.00k
Timestamp 02/24/2019 10:51:06 AM
2/24/2019 Log: Program 2
2/2
Step Count 20 Switch Count 2
Page Faults 0
Page Reclaims 89
Page Swaps 0
Voluntary Context Switches 12
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
98 QUIT;RUN;
99 ODS HTML5 (ID=WEB) CLOSE;
100
101 ODS PDF (ID=WEB) CLOSE;
NOTE: ODS PDF(WEB) printed 1 page to /saswork/SAS_workA9F00000DC50_odaws02-prod-sg/#LN00016.
102 FILENAME _GSFNAME;
NOTE: Fileref _GSFNAME has been deassigned.
103 DATA _NULL_;
104 RUN;
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 316.68k
OS Memory 22440.00k
Timestamp 02/24/2019 10:51:06 AM
Step Count 21 Switch Count 0
Page Faults 0
Page Reclaims 32
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
105 OPTIONS VALIDMEMNAME=COMPAT;
106 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK;
107
SAS files/code files/One-Way ANOVA.ctk
One-Way ANOVA
A one-way analysis of variance (ANOVA) tests and provides graphs for differences among the means of a single categorical variable on a single continuous dependent variable.
d4bcb606-8cbe-47de-bfbc-2eae932d5729
GLM
3.7
SAS Studio Task Reference Guide
The GLM Procedure
SAS Tutorials
Dependent variable:
Categorical variable:
DATA
OPTIONS
DATA
ROLES
TESTS
HOMOGENEITY OF VARIANCE
Test:
None
Bartlett
Brown and Forsythe
Levene
O'Brien
Welch's variance-weighted ANOVA
COMPARISONS
Comparisons method:
Bonfe
oni
Duncan multiple range
Dunnett two-tail
Dunnett lower one-tail
Dunnett upper one-tail
Ga
iel
Ryan-Einot-Ga
iel-Welch
Nelson
Scheffe
Sidak
Student-Newman-Keuls
Least significant difference (LSD)
Tukey
None
The LS-mean difference plot is not available with the Duncan multiple range comparison method
The LS-mean difference plot is not available with the Ga
iel comparison method
The LS-mean difference plot is not available with the Ryan-Einot-Ga
iel-Welch comparison method
The LS-mean difference plot is not available with the Student-Newman-Keuls comparison method
Control level:
Significance level:
0.10
0.05
0.01
Use custom value
Custom significance level:
PLOTS
Display plots:
Default plots
Selected plots
Suppress all plots
Box plot
Means plot
LS-mean difference plot
Diagnostics plot
Display as:
Individual plots
Panel of plots
Maximum number of plot points:
Default(5,000)
10,000
Use custom value
No limit
Custom maximum number of points:
OUTPUT
OUTPUT DATA SET
Create observation statistics data set
Data set name:
Predicted Values
Residuals
Influence Statistics
Standard E
ors
Predicted value
Confidence intervals for individual predicted value
Confidence intervals for mean predicted value
Residual
Studentized residual
Studentized residual with cu
ent observation removed
Standard e
or of residual
Standard e
or of mean predicted value
Standard e
or of individual predicted value
Cook's D influence
Covratio
Dffits
Leverage
Confidence level:
90%
95%
99%
Use custom value
Custom confidence level:
Select at least one statistic to include in the output data set.
Title;
ods noproctitle;
ods graphics / imagemap=on;
proc glm data=$dataset
#if($plotsCombo == 'suppressPlotsChoice') plots=none
#else
#if (!($boxPlot == 1 || $diagnosticPlots == 1 || $meanPlot == 1 || ($diffPlot && $diffPlot == 1)))
#else
#set($bool_maxpoints = 0)#if (!($maxpointsCombo == 'maxpointsDefault'))#set($bool_maxpoints = 1)#end
#if (!($plotsCombo == 'defaultPlotsChoice' && $bool_maxpoints == 0))
plots(
#if($bool_maxpoints == 1) maxpoints=
#if ($maxpointsCombo == 'maxpoints10000')10000
#elseif ($maxpointsCombo == 'maxpointsNoLimit')none
#elseif ($maxpointsCombo == 'maxpointsSpecify')$maxpointsValue
#end
#end
#if ($plotsCombo == 'selectedPlotsChoice') only#end
)
#if ($plotsCombo == 'selectedPlotsChoice' && ($diagnosticPlots == 1 || $boxPlot == 1))=(
#if ($boxPlot == 1)boxplot#end
#if ($diagnosticPlots == 1) diagnostics#if($unpackDiagnosticPlots == 'unpackChoice')(unpack)#end#end
)
#end
#end
#end
#end
;
#if ($dataset.getWhereClause() != '')
where $dataset.getWhereClause();
#end
class #foreach( $item in $independentVariable ) $item #end;
model #foreach( $item in $dependentVariable ) $item #end = #foreach( $item in $independentVariable ) $item #end;
#set($meansCompare=0)
#if ( $comparisonCombo == "DuncanChoice" || $comparisonCombo == "ga
ielChoice" || $comparisonCombo == "regwChoice" ||
$comparisonCombo == "snkChoice" ) #set($meansCompare=1)#end
#if ( $meansCompare==1 || !($hovTest == "hovTestNone") || $welchANOVA == "1")
means #foreach( $item in $independentVariable ) $item #end /
#if ( $meansCompare==1)
#if ( $comparisonCombo == "DuncanChoice" ) duncan
#elseif ( $comparisonCombo == "ga
ielChoice" ) ga
iel
#elseif ( $comparisonCombo == "regwChoice" ) regwq
#elseif ( $comparisonCombo == "snkChoice" ) snk
#end
alpha=#if($alpha=="alpha_05") .05 #elseif ($alpha=="alpha_01") .01 #elseif ($alpha=="alpha_10") .10 #else $alphaValue #end
#end
#if ($hovTest == "o
ien") hovtest=o
ien
#elseif ($hovTest == "levene") hovtest=levene
#elseif ($hovTest == "bartlett") hovtest=bartlett
#elseif ($hovTest == "
ownForsythe") hovtest=bf
#end
#if ($welchANOVA == "1" ) welch #end
plots=none;
#end
#set($lsmeansCompare=0)
#if ($comparisonCombo == "bonfe
oniChoice" || $comparisonCombo == 'DunnettTwoTailed' ||
$comparisonCombo == 'DunnettLowerOneTailed' || $comparisonCombo == 'DunnettUpperOneTailed' ||
$comparisonCombo == "nelsonChoice"|| $comparisonCombo == "scheffeChoice" ||
$comparisonCombo == "lsdChoice" ||
$comparisonCombo == "sidakChoice" || $comparisonCombo == "tukeyChoice" ) #set($lsmeansCompare=1)#end
#if ($lsmeansCompare == 1 || $meanPlot == 1 || $diffPlot == 1 || ($meansCompare==1 && $diffPlot == 1))
lsmeans #foreach( $item in $independentVariable ) $item #end
#if ($lsmeansCompare == 1)
#if ( $comparisonCombo == "bonfe
oniChoice") adjust=bon pdiff
#elseif ( $comparisonCombo == "DunnettTwoTailed" ) adjust=dunnett pdiff=control($CTMUtil.quoteString($dunnettControlLevel))
#elseif ( $comparisonCombo == "DunnettLowerOneTailed" ) adjust=dunnett pdiff=controll($CTMUtil.quoteString($dunnettControlLevel))
#elseif ( $comparisonCombo == "DunnettUpperOneTailed" ) adjust=dunnett pdiff=controlu($CTMUtil.quoteString($dunnettControlLevel))
#elseif ( $comparisonCombo == "scheffeChoice" ) adjust=scheffe pdiff
#elseif ( $comparisonCombo == "nelsonChoice" ) adjust=nelson pdiff
#elseif ( $comparisonCombo == "sidakChoice" ) adjust=sidak pdiff
#elseif ( $comparisonCombo == "tukeyChoice" ) adjust=tukey pdiff
#elseif ( $comparisonCombo == "lsdChoice" ) adjust=t pdiff
#end
#end
#if ($lsmeansCompare == 1 || ($meansCompare==1 && $diffPlot == 1))
alpha=#if($alpha=="alpha_05") .05 #elseif ($alpha=="alpha_01") .01 #elseif ($alpha=="alpha_10") .10 #else $alphaValue #end
#end
#if ($plotsCombo == 'selectedPlotsChoice' && ($meanPlot == 1 || $diffPlot == 1)) plots=(
#if ($meanPlot == 1) meanplot#end
#if ($diffPlot == 1) diffplot#end
)
#elseif ($plotsCombo == 'defaultPlotsChoice')
#else plots=none
#end
;
#end
#if ($outputDS == '1')
output out=$outputDSName
#if ($predicted=='1') p=predicted#end
#if ($lcl=='1') lcl=lcl ucl=ucl#end
#if ($clm=='1') lclm=lclm uclm=uclm#end
#if ($residual=='1') r=residual#end
#if ($student=='1') student=student#end
#if ($rstudent=='1') rstudent=rstudent#end
#if ($stdr=='1') stdr=stdr#end
#if ($stdi=='1') stdi=stdi#end
#if ($stdp=='1') stdp=stdp#end
#if ($cookd=='1') cookd=cookd#end
#if ($covratio=='1') covratio=covratio#end
#if ($dffits=='1') dffits=dffits#end
#if ($h=='1') h=leverage#end
#if ($lcl == 1 || $clm == 1)
## Calculate alpha from confidence
#if ($outputConfidence == "confidence95") #set( $clAlpha = 0.05 )
#elseif ($outputConfidence == "confidence99") #set( $clAlpha = 0.01 )
#elseif ($outputConfidence == "confidence90") #set( $clAlpha = 0.10 )
#else #set($clAlpha="%sysevalf((100-$confidenceValue)/100)")
#end
/alpha=$clAlpha
#end
;
#end
un; quit;
{"unpackChoice":"Individual plots","dffits":"","rolesGroup":"ROLES","alpha_01":"0.01","influenceStatsGroup":"Influence Statistics","
ownForsythe":"Brown and Forsythe","maxpointsSpecify":"Use custom value","diagnosticPlots":"0","meanPlot":"1","tukeyChoice":"Tukey","duncanNote":"The LS-mean difference plot is not available with the Duncan multiple range comparison method","alpha_05":"0.05","maxpointsValue":"","ga
ielNote":"The LS-mean difference plot is not available with the Ga
iel comparison method","outputTab":"OUTPUT","rstudent":"","lcl":"","stdi":"","student":"","hovTestGroup":"HOMOGENEITY OF VARIANCE","stdp":"","nelsonChoice":"Nelson","dunnettControlLevel":"59.529898245","stdr":"","stde
StatsGroup":"Standard E
ors","scheffeChoice":"Scheffe","sasVersion":"9.450000000000001","welchANOVA":"1","alpha_10":"0.10","unpackDiagnosticPlots":"panelChoice","independentVariable":"json:[{\"value\":\"BOILED\",\"type\":\"Numeric\",\"length\":8,\"format\":\"BEST.\",\"informat\":\"\",\"className\":\"RoleObject\"}]","suppressPlotsChoice":"Suppress all plots","dataTab":"DATA","optionsTab":"OPTIONS","residual":"","snkNote":"The LS-mean difference plot is not available with the Student-Newman-Keuls comparison method","selectedPlotsChoice":"Selected plots","clm":"","residualStatsGroup":"Residuals","ga
ielChoice":"Ga
iel","snkChoice":"Student-Newman-Keuls","hovTest":"levene","sidakChoice":"Sidak","maxpoints10000":"10,000","plotsGroup":"PLOTS","regwChoice":"Ryan-Einot-Ga
iel-Welch","maxpointsNoLimit":"No limit","outputConfidence":"confidence95","comparisonCombo":"tukeyChoice","boxPlot":"1","o
ien":"O'Brien","dependentVariable":"json:[{\"value\":\"RAW\",\"type\":\"Numeric\",\"length\":8,\"format\":\"BEST.\",\"informat\":\"\",\"className\":\"RoleObject\"}]","diffPlot":"1","bonfe
oniChoice":"Bonfe
oni","outputGroup":"OUTPUT DATA SET","DunnettUpperOneTailed":"Dunnett upper one-tail","outputDSName":"Oneway_stats","plotsCombo":"defaultPlotsChoice","outputDS":"","regwNote":"The LS-mean difference plot is not available with the Ryan-Einot-Ga
iel-Welch comparison method","maxpointsCombo":"maxpointsDefault","alphaValue":"","comparisonsGroup":"COMPARISONS","alpha":"alpha_05","defaultPlotsChoice":"Default plots","sasOS":"Linux LIN X64 3.10.0-693.21.1.el7.x86_64","testsGroup":"TESTS","noComparison":"None","dataGroup":"DATA","confidence95":"95%","hovTestNone":"None","panelChoice":"Panel of plots","covratio":"","DunnettLowerOneTailed":"Dunnett lower one-tail","confidenceValue":"95","maxpointsDefault":"Default(5,000)","confidence90":"90%","predicted":"","levene":"Levene","confidence99":"99%","DuncanChoice":"Duncan multiple range","h":"","bartlett":"Bartlett","lsdChoice":"Least significant difference (LSD)","alphaSpecify":"Use custom value","dataset":{"li
arytable":"WORK.PETRO_EXCEL"},"cookd":"","confidenceSpecify":"Use custom value","predictedStatsGroup":"Predicted Values","DunnettTwoTailed":"Dunnett two-tail"}
SAS files/code files/Partial Least Squares Regression.ctk
Partial Least Squares Regression
The Partial Least Squares task performs partial least squares analysis. It also performs principal components regression and reduced rank regression. These techniques combine dimension reduction of the predictors and/or dependent variables with predictive modeling.
1c220ff6-b860-43f6-a185-a7ed1fa2ae51
PLS
3.7
SAS Studio Task Reference Guide
The PLS Procedure
SAS Tutorials
Dependent variables:
Continuous variables:
Classification variables:
Group analysis by:
DATA
OPTIONS
DATA
ROLES
ADDITIONAL ROLES
Explanatory Variables
Treatment of Missing Values
An observation is excluded from the analysis if any variable in the model contains a missing value. In addition, an observation is excluded if any classification variable contains a missing value (regardless of whether the classification variable is used in the model).
MODEL EFFECTS
MODEL
Center the responses and predictors
METHODS
Method:
Partial least squares regression
De Jong's SIMPLS
Principal components regression
Reduced rank regression
Algorithm:
Iterative NIPALS
Singular value decomposition
Eigenvalue decomposition
Iterative RLGW
Details
Specify the number of factors
Number of factors:
Specify the maximum number of iterations
Maximum number of iterations:
Cross Validation
Cross validation method:
Exclude one observation at a time
None
Exclude every nth observation
Exclude blocks of consecutive observations
Exclude observations at random
Specify the nth observation to exclude
Nth observation to exclude:
Specify the number of blocks to divide the data
Number of blocks:
Specify the random seed
Random seed:
STATISTICS
Display statistics:
Default and selected statistics
Default statistics
Van der Voet's model comparison test
Display statistics:
Hotelling's T square statistic
Press statistic
Specify the cut-off probability
Cut-off probability:
Specify the random seed
Random seed:
Coefficients of final predictive model
Variation accounted for in responses and predictors
Details of the fitted model
Diagnostics
Analysis of influence
Analysis of residuals
Predicted values
PLOTS
Select plots to display:
Default plots
Default and additional plots
No plots
Co
elation loading plot
Diagnostics plots
Residuals of dependent by independent variables
Profiles of regression coefficients
Variable importance factors
Distance plots for X and Y models
Matrix of X-scores against Y-scores
Specify the number of factors to plot
Number of factors to plot:
OUTPUT
OUTPUT DATA SET
Create statistics data set
Data set name:
Leverage
Predicted values
Residuals for responses
Residuals for predictors
Press statistic
Extracted responses
Extracted factors
Standardized responses
Standardized predictors
...