Questions tagged [sas]

SAS is a proprietary cross-platform general-purpose statistical software package.

Filter by
Sorted by
Tagged with
0 votes
0 answers
6 views

Data access to SAS

I hope this question is not off-topic, and apologize if it is. I'm not a data scientist per se, but as the person in charge of data architecture in my organization, I'd like to check my understanding ...
mrgou's user avatar
  • 133
0 votes
0 answers
9 views

SAS Macro: dereferencing a macro variable in the name of a column name of a dataset

In SAS dereferencing this does not work: ...
babipsylon's user avatar
0 votes
0 answers
7 views

Rename a variable (column name) in a SAS dataset with unknow suffix

The ICT team provides me with a dataset with a column that changes name every month, but always starts with "Reality". It's always column 10. There are other variables that match these ...
babipsylon's user avatar
0 votes
0 answers
8 views

Replacing values in a dataset based on a IF statement

I have code for which this works perfectly, see code 1 below. But for code 2, it does not work at all. Very strange. Only difference is the way the tables were created, and the use of macro variables ...
babipsylon's user avatar
0 votes
0 answers
15 views

SAS: how to replace a value in column two in a dataset for which column one = x?

So, total SAS noob here (and I don't like it al all so far). I tried 4 different methods, which all do not work. So I guess in all of these code, something similar is wrong, something rather ...
babipsylon's user avatar
0 votes
0 answers
17 views

Interpreting PHREG frailty results

I am struggling to understand when, using proc phreg to produce a frailty model, one would use the "unadjusted" p-value vs. the adjusted. See, e.g., https://documentation.sas.com/doc/en/...
kat's user avatar
  • 1
0 votes
0 answers
35 views

Panda's SAS PROC transpose equivalent in case of only ID, multiple VARs

I would like to transform the following: week_no count mean std min max 24 762.0 774.002734 0.995213 771.0022 776.4584 25 2971.0 759.702417 4.241902 750.9586 767.6225 ... ... ... ... ... ... To: ...
matias's user avatar
  • 1
0 votes
1 answer
46 views

what are the best sources to learn about statistics?

am interested in quant analytics. hope statistics is heart for quant analysis. so, what are the best sources to learn core statistics (in depth) and what is the best approach to learn statistics?
tovijayak's user avatar
3 votes
1 answer
255 views

SAS Studio seems to imply that apparently non-normal data is normal

I have some data I'm trying to analyze in SAS Studio (university edition). I am using the Distribution Analysis feature to try to test some data for normality. It gives me the following histogram: ...
EJoshuaS - Stand with Ukraine's user avatar
0 votes
2 answers
1k views

What pandas function is most similar to the transpose procedure in SAS?

I am trying to transpose Amt by Txn_ID across Item_Desc in Python using pandas. Which pandas ...
Bojan's user avatar
  • 1
1 vote
0 answers
86 views

scaling credit risk scorecard

I need to build a credit risk scorecard using logistic and linear regression. The variables using to predict are all dummies, where each dummy is a bin of some variable. Let's say the variable age, I ...
user12195705's user avatar
0 votes
1 answer
270 views

Getting extra characters while loading data

While loading data using read_sas from sas dataset in Python getting b' along with every string. How can I fix this?
Dataworld_guy's user avatar
0 votes
1 answer
2k views

Making Prediction on logistic regression using SAS

...
Mr. Z's user avatar
  • 141
0 votes
1 answer
470 views

How to create a SAS Library Folder

I am trying to create a folder to use in the SAS library. I have tried to do this many different ways. Every time I run the code it always says that the path does not exist. Below is my error ...
Chris Kehl's user avatar
1 vote
1 answer
632 views

Drop NA Values with SAS

I have an xlsx file that I wish to delete the NA values in SAS. I'm new to ...
Chris Kehl's user avatar
0 votes
1 answer
126 views

How can I use a class variable with many possible values in logistic regression?

I am attempting to build a logistic regression model that determines the probability of an outcome based on a set of independent variables. For context, the data is based on a project in which sales ...
Henry Sumner's user avatar
1 vote
1 answer
164 views

Using by statement in proc esm

I was using proc een in SAS, for time series forecasting. I want to include two variables in by statement. My data contains four columns: Shop_id Item_id ...
saswata biswas's user avatar
3 votes
1 answer
3k views

How to make R or Python as fast as SAS for ODBC Oracle queries? [closed]

I want to use R or Python to query big structured SQL-type data, but they are very slow compared to SAS. I tried using R and Python to return a 1.3 million record Oracle ODBC passthrough query. The ...
Sean McCarthy's user avatar
1 vote
2 answers
227 views

Displaying date in SAS

I am trying to display a date in my result after running the below program in SAS. It runs properly but in the sas data table under DOB column I don't get anything except a period ...
Techievent.in's user avatar
0 votes
1 answer
116 views

SAS procedure IF THEN ELSE loop did not recognize the Roman letters or numbers as value

I have written the following SAS procedure to display Grades based on the salary: Not Working: This displays only 'I' for all observations irrespective of the else condition that says any salary less ...
Yash Saraiya's user avatar
3 votes
0 answers
303 views

Are SAS Data Storage Options designed for Big Data?

I understand that SAS has some data storage options in the form of Default Storage tables or SAS datasets - in the SAS library. Multi-dimensional Storage cubes - in the OLAP Server. Third Party ...
Minu's user avatar
  • 805
-1 votes
5 answers
197 views

which technology should I invest into SAS In-memory analytics or R? [closed]

As I'm starting my career in analytics, I have to choose between SAS in-memory analytics and Openware and largely adopted R, which one should I choose now so that I will have good market value in ...
Makarand's user avatar
1 vote
2 answers
4k views

Why do we need to use sysfunc when we call a SAS function inside a SAS macro

I saw this piece of code in my project: %let num = test; %let x=%sysfunc(trim(&num)); Why could not I write: ...
Victor's user avatar
  • 611
3 votes
1 answer
3k views

How is H2O faster than R or SAS?

I am trying to understand the abstract details that explain how h2o is faster than R and SAS for data science computations.
jaig's user avatar
  • 153
0 votes
1 answer
1k views

Logistic Regression in R models for 1 or 0?

According to this link, it says SAS models for 0, To model 1s rather than 0s, we use the descending option. We do this because by default, proc logistic models 0s rather than 1s What happens in ...
Srikanth Guhan's user avatar
0 votes
1 answer
164 views

SAS. How to write "OR" [closed]

How to write "OR" in this example? DATA a1; set a; if var1=1 OR 2; run; P.S. va1 is the categorial (with categories: 1, 2, 3)
Beginner's user avatar
2 votes
0 answers
590 views

SAS Nested Likelihood Ratio Test for a Logistic Model

Using SAS Studio (online, student version)... Need to do a "nested likelihood ratio test" for a logistic regression. Entirety of instructions are: "Perform a nested likelihood ratio test comparing ...
Lauren's user avatar
  • 21