Statistical Analysis System (SAS)

105

Solutions

120

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

Does anyone have experience integrating Google Analytics tracking code into a SAS Web Portal? It seems that SAS doesn't really have the granularity to tell me exactly what my users are doing on each portal page and how they are interacting with each. Was hoping someone out there has had a whack at this previously.

I've found this which works on version 9.4M4 http://blogs.sas.com/content/sasdummy/2017/04/14/using-sas-to-access-google-analytics-apis/

I have 9.3 M2 and would rather just have the data pipe directly in to GA instead of having it come back to SAS as shown in the previous blog post

Thanks in advance for any help you can provide
0
On Demand Webinar: Networking for the Cloud Era
LVL 10
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

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
Experts,

Does anyone know how to export a pipe delimited text file from a SAS dataset?
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
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)

105

Solutions

120

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!