Statistical Analysis System (SAS)

115

Solutions

137

Contributors

The Statistical Analysis System (SAS) programs consist of two steps, the DATA step and the PROC step. The DATA step reads data and prepares it for use by subsequent DATA or PROC steps. A SAS procedure (PROC) is a collection of statements that execute a certain task. SAS procedures have their own statements and commands, but many are shared among procedures. JMP is the graphical user interface for SAS, and is used in applications such as Six Sigma, quality control and engineering, design of experiments and scientific research.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi,
I would like to prepare data for regression analysis.
I can prepare data in two forms.
a) values
b) rankings.
example:
values  60,30,25,90
rankings 2,3,4,1
Which format would be most suitable or does it not matter ?
many thanks
Ian
0
Learn Ruby Fundamentals
LVL 12
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Hi everyone!
I am trying to do a few things in my bash script (script1.sh):  pass logicals/variables to my SAS program (program1.sas), execute SAS code (program1.sas), check with "errstat" for specific errors related to SAS code conditions that I set up in my SAS code, and also check with "logerrchk" SAS log file for any errors in the SAS log.  
I think most of the script is correct but I am not sure about both checking errors (errstat" and "logerrchk").

 Please note: variable/logicals (file1, file2, plog, and errstat) are also defined in the SAS program.  

 Please provide any suggestions or examples if you can.
 Here is what I have so far:

#!/bin/bash
#script1.sh

# Creating variables for directories
export DATADIR1=/root/alldirs/2018/data1
export DATADIR2=/root/alldirs/2018/data2
export DATADIR3=/root/alldirs/2018/data3
export PROGDIR1=/root/alldirs/2018/prog1

#Creating variables for data files that are used in program1.sas and final log file 
export file1=${DATADIR1}/sasdata1.sas7bdat
export file2=${DATADIR2}/sasdata2.sas7bdat
export plog=${DATADIR3}/sas_program.log

#executing SAS program
sas ${PROGDIR1}/program1.sas -log ${DATADIR3}/program1.log

#checking for errors in SAS log file
logerrchk=$?     
   if [[ "$logerrchk" !=0 ]]; 
   then 
       echo "--- Error: Abnormal end in program program1.sas. Check log file! ---" >> $plog
       exit 2
   else
       echo "--- Program1.sas run successfully! ---" >> $plog
   fi
  
#checking for specific errors 

Open in new window

0
Object oriented design is used to identify and define all program object that must work together.
0
I have created two sheets with date field, wrkorder no , hours and invoice count of technicians. One sheet shows day and other shows week numbers. The problem I’m facing is in the weeks sheet where even though the wrkorder happened twice in two dates the hours are adding up and sum of hours for each work order is showing. The total hours are accurate thought but invoicecount is getting wrong. Since a wrkorder happened in both days it is counted  as two but it showing me one.
0
Why Statistics is important for Data Analysis?
What is the role of Statistics in Data Analysis?

*Please share a real life example.*
0
Hello All Experts,
I am a student enthusiast in learning "Data Analytics" , which is the best platform to learn for FREE?
I want to Learn 'Data Science (Statistics)' & 'SAS/R' from scratch?
Any videos? Any websites? Any Blogs?

Thanks,

Regards,
Satish Kumar G N
0
Hello,
For testing and verification purposes, I am trying to compute the count of good duplicates found in both Data1 and Data2  and in Data3, and in one or the other. These are the steps I am trying to accomplish to get to my final results:

#1.  Create a list (Data4) of unique Data1 and Data2 where variable rec_flag=A, B, C, D.
#2.  Build a duplicate (Data5) file from the list in #1 by generating a record linking each two records where Var3 and Var4 are linked to the same Var6 and Var7.
#3.  Match Data5 file with Data3 where variable rec_flag=B, C, D using key variables Var3, Var4, Var6, and Var7.
#4.  Display in the output .lis the number of records in:
     #4.1 Both Data5 and Data3
     #4.2 Data5 only
     #4.3 Data3 only
 
The issue that I am having is with #2 where I need to build a duplicate file Data5.

Here is my SAS code below with missing step #2:

libname mydir "/home/myprofile/links"; 
%macro cnt_lnks;

 /*  #1 */
proc sort data=mydir.Data1
          out=Data1out(where=(rec_flag='A', 'B', 'C', 'D') keep=Var3 Var4 Var6 Var7 rec_flag);
          by Var3 Var4 Var6 Var7;
run;

proc sort data=mydir.Data2
          out=Data2out(where=(rec_flag='A', 'B', 'C', 'D') keep=Var3 Var4 Var6 Var7 rec_flag);
          by Var3 Var4 Var6 Var7;
run;

/*********************************************
 Datastep: merge Data1 & Data2
           by Var3 Var4 Var6 Var7
 ********************************************/
data all_links1;
  merge 

Open in new window

0
hi  i have code like this  File inputFile = new File(templateDownloadRequestDto.getTemplateName().trim() + ".xlsx");
this line is showing as path manipulation issue HP fotify scanning, from UI level i select a drop down value to download a file, then i hits a spring controller, from spring service we prepare xlsx sheet using apache poi ,here we are not validating any file names, because those are predefined names, so no need to validate file, how can i resolve this issue ?
0
Does anyone know that what would be used in SAS for LOGEST Function in Excel?
0
The curve on the tab "Curve fitting graphic" in the Excel "Distansomräkningstider" attached here is almost perfect. It is only the last part that is pointing too sharply upwards. It should be more flattened out (but never turn townwards, always continue to pointing slightly upwards) from around 2500 metres or 2600 metres, which seems to be a "breaking point" for two different curves.

The context is harness racing track times for different lengths of the races with the purpose of calculating re-calulation coefficients for different lengths of the races. Index is 2140 metres (x). The software I use is CurveExpert. I received help here at EE earlier at this thread:

Is there any online tool where I can enter x and y values to get a curve diagram displayed, and then enter more x values to get exact y values calculated?

In essence, this graph consists of 2 curves, and they cross each other at around 2500 or 2600 metres. The first curve is more favouring the speed of the horse (shorter distance, which means the horse is able to run much faster due to a short distance where strength and stamina is not required), whereas the second curve is more favouring the strength, or stamina, of the horse (longer distance, which means the horse can not run so much faster the more the curve moves to the right and the distance gets longer and longer).

My reliable five values I have now are these:

x=1640; y=0.913999
x=2140; y=1
x=2640; y=1.048999
x=3140; y=1.110999
x=4000; …
0
JavaScript Best Practices
LVL 12
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

We utilize a web based freight rate tool and i am trying to figure out how do i really know if the freight rate tool has helped us or are we paying for a tool that hasnt helped us gain more business, increase revenue and/or lost us?

I cant just look at yr over yr or month over month and assume its all due to our using the rate tool because of the many variables involved.

For example, say in 2015 we didnt use a rate tool and 2016 we do use a rate tool. In 2015 demand for truckload capacity was much higher than demand 2016 so numbers could be down in 2016 compared to 2015 so we couldnt blame that on rate tool being a failure. How do you contribute the success or failure to increase business revenue or profits...to our using a rate tool, so i can decide if its worth it to continue paying for it in 2017?

info on rate tool
rate tool takes our historic data and some other variables and it gives us what we should expect to pay for trucks that we service our shipping customers with.

demand for trucks needed to haul freight increased
0
Hi I would like to retrieve the data from SCOM API in order to make another Aggregated data set for other use. I have search around for books, video , forum and even seek Microsoft for help but Microsoft didn't come back to me yet. but other resource was just very few available discussing about the SCOM SDK.

Can anyone provide some help on that when I using powershell or if better using C# API to retrieve data.

Regards,
Zteffer
0
I am trying to program an SAS drive for an MMORPG. The game will hook up to any television and will have an interactive board connected via Bluetooth to the game. Can anyone assist me in how to program the drive for this game?
0

Statistical Analysis System (SAS)

115

Solutions

137

Contributors

The Statistical Analysis System (SAS) programs consist of two steps, the DATA step and the PROC step. The DATA step reads data and prepares it for use by subsequent DATA or PROC steps. A SAS procedure (PROC) is a collection of statements that execute a certain task. SAS procedures have their own statements and commands, but many are shared among procedures. JMP is the graphical user interface for SAS, and is used in applications such as Six Sigma, quality control and engineering, design of experiments and scientific research.

Top Experts In
Statistical Analysis System (SAS)
<
Monthly
>

No Top Experts for this time period. Answer questions to earn the title!