Stack Overflow
Stack Overflow

Questions tagged [sas-studio]

SAS Studio is a SAS thin client that runs in a web browser and allows a user to connect to a SAS server and execute SAS code. It is the client that is used to run the SAS University Edition free software, as well as many paid SAS products.

SAS Studio is a SAS thin client that runs in a web browser and allows a user to connect to a SAS server and execute SAS code. It is the client that is used to run the SAS University Edition free software, as well as many paid SAS products.

http://support.sas.com/software/products/sasstudio/

http://support.sas.com/software/products/university-edition/faq/main.htm

100 questions
0
votes
1 answer

Loops and output

I am trying to get a bit handy with my loop and output statements, currently I have a loan which amortizes like such: data have; input Payment2017 Payment2018 Payment2019 Payment2020; datalines; 100 10 10 10; run; I'm trying to create a maturity…
78282219
  • 593
  • 5
  • 21
0
votes
1 answer

Finding the midpoint of three years

I have a dataset which represents the volume of sales over three years: data test; input one two three average; datalines; 10 20 30 . 20 30 40 . 10 30 50 . 10 10 10 . ; run; I'm looking for a way to find the middle point of the three years, the…
78282219
  • 593
  • 5
  • 21
0
votes
1 answer

Array suddenly not working

I have been working with an array which has been working fine until the most recent update to the data. An example dataset can be constructed as follows: Data Have; input Fixed_or_floating $ ID Vintage Base2017 Base2018 Base2019 Base2020…
78282219
  • 593
  • 5
  • 21
0
votes
1 answer

Counting the ID and assigning a Year

I have a dataset that looks like this: data have; input ID P1 P2 P3 P4; datalines; ID P1 P2 P3 P4 12 10 15 20 30 12 - 20 5 3 12 - - 25 33 12 - - - 30 19 10 15 20 30 19 …
78282219
  • 593
  • 5
  • 21
0
votes
3 answers

Aggregating using proc means SAS

For a project, I have a large dataset of 1.5m entries, I am looking to aggregate some car loan data by some constraint variables such as: Country, Currency, ID, Fixed or floating , performing , Initial Loan Value , Car Type , Car Make I am…
78282219
  • 593
  • 5
  • 21
0
votes
2 answers

SAS date format returning censored

I have a column called Last Payment as such last payment 12DEC09:00:00:00 all the observations follow this structure, I've tried taking a substring such that data want; set have; last_payment=substr(last_payment,1,7); run; that doesn't work, I've…
78282219
  • 593
  • 5
  • 21
0
votes
1 answer

expanding a dataset with blanks

I have a dataset as follows: data have; input; ID Base Adverse Fixed$ Date RepricingFrequency 1 38 50 FIXED 2016 2 2 40 60 FLOATING 2017 3 3 20 20 …
78282219
  • 593
  • 5
  • 21
0
votes
2 answers

Working with an upper-triangular array in SAS (challenge +2 Points)

I'm looking to improve my code efficiency by turning my code into arrays and loops. The data i'm working with starts off like this: ID Mapping Asset Fixed Performing Payment 2017 Payment2018 Payment2019 Payment2020 1 …
78282219
  • 593
  • 5
  • 21
0
votes
1 answer

Sticky Macro variables in SAS

I am running a macro loop that contains macro functions like so: %macro loop; %do j=1 %to 1000; %macro variable; %end; %mend; The macro variable itself has some macro functions enclosed like so: %macro variable; %macro rename(x); proc sql; create…
78282219
  • 593
  • 5
  • 21
0
votes
0 answers

Working with exact observations in sas

I am working with a dataset as follows: YearZero YearOne YearTwo YearThree 10 2.5 2.5 5 0 0 0.625 0.625 0 0 0 0.15625 0 2.5 3.125 5.78125 I'm…
78282219
  • 593
  • 5
  • 21
0
votes
2 answers

Sas working with observations

I am new to SAS but familiar with R, MATLAB and Stata. One thing I haven't been able to find yet while researching is the ability to work with individual observations throughout the data set. Assume this dataset is what I'm working with each step of…
78282219
  • 593
  • 5
  • 21
0
votes
1 answer

PROC GENMOD in SAS Invalid Reference Value for Predictor Variable and No Valid Observations

I'm trying to model a binary outcome (p1ODD) on binary predictor variables (c1kdscc3, c1kdscc4 and c1kdscc5). When I try to do PROC GENMOD, my log indicates that I have an invalid reference value for c1kdscc3. It also tells me that there are no…
Irina Oltean
  • 1
  • 1
0
votes
1 answer

SAS Studio import error

I am trying to use SAS Studio in VirtualBox, when I run certain scripts though- I get numerous errors. Namely, when I run the following code: proc import datafile = "UTDCASESTUDYDATA1.xlsx" out = ti dbms = excel; run; I…
zsad512
  • 861
  • 3
  • 15
  • 41
0
votes
1 answer

Multiplying Columns in SAS using loop condition

Table from SAS In this table, the Trans_Date column continues up to 31/07/2016. How do I multiply the Value column to the Rate column (currency exchange for AUD in terms of NZD, CAD, GBP as seen in currency_conv for a particular date) under a loop…
metaGross
  • 15
  • 1
  • 1
  • 6
0
votes
1 answer

Custom tasks and default view in SAS Studio 3.5

I am creating a custom task in SAS Studio 3.5. I want to design a simple user interface so that users can select options and input parameters. When SAS Studio opens, there is a code and log window, when the task is opened there are then a few extra…
ChiPhi85
  • 61
  • 5
1 2 3 4 5
6
7