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
1
vote
3 answers

SAS studio, I cannot open a dataset

I cannot open a dataset using SAS Studio. I am following this online resource (https://stats.idre.ucla.edu/sas/dae/probit-regression/). After downloading the data " binary.sas7bdat" and uploading the data inside SAS studio's personal folder, I…
Mark Vitale-Ferrari
  • 13
  • 3
1
vote
1 answer

Single and multi factor analysis in SAS

I am looking to conduct a single factor and multi factor analysis on some data I have. The issue is that I am researching the topic at the moment and I feel the weight of conflicting and unclear search engine results. Sometimes It refers to ANOVA,…
78282219
  • 593
  • 5
  • 21
1
vote
1 answer

Proc reg: checking the best three variables in parallel

I am working on a macro for regressions using the following code: %Macro Regression; %let index = 1; %do %until (%Scan(&Var2,&index," ")=); %let Ind = %Scan(&Var2,&index," "); ods output SelectionSummary = SelectionSummary; proc reg data =…
78282219
  • 593
  • 5
  • 21
1
vote
2 answers

Proc means - Calculating the share / weight

I am using a proc means to calculate the share of the payments made by business line, the data looks like this: data Test; input ID Business_Line Payment2017; Datalines; 1 1 1000 2 1 2000 3 1 3000 4 1 4000 5 2 500 6 2 1500 7 2 3000 ; run; i'm…
78282219
  • 593
  • 5
  • 21
1
vote
1 answer

Sas Autocall Macro Library Not working

I've been using a macro library to find and compile my macro codes until recently, where SAS cannot load the macro. The code I use is: options mautosource sasautos=MacLib; filename MacLib "C:\Users\your.name.here\Documents\Macro_Library"; My macro…
78282219
  • 593
  • 5
  • 21
1
vote
1 answer

Left Join collapses data

I am working with some bonds data and I'm looking to left join the interest rate projections. my data set for the bonds date looks like: data have; input ID Vintage Reference_Rate Base2017; Datalines; 1 2017 LIBOR_001M 0.01 1 2018 …
78282219
  • 593
  • 5
  • 21
1
vote
1 answer

Import Error even when variable is dropped SAS

I'm importing a semi-colon delimited file as such ID Segment Number Date Payment 1 A1 103RTR 10OCT17 10 2 A1 205FCD 11OCT17 11 ... the SAS doesn't like the mixture of numbers and characters when I import…
78282219
  • 593
  • 5
  • 21
1
vote
2 answers

Nested If do statements SAS

I have a dataset which looks like this: ID 2017 2018 2019 2020 2017 30 24 20 18 2018 30 24 20 18 2019 30 24 20 18 2020 30 24 20 18 I am looking to create an…
78282219
  • 593
  • 5
  • 21
1
vote
1 answer

Finding and saving present directory of a SAS-Studio-program in a Linux server

I am trying to make a macro variable in SAS Studio which saves the "present working directory" as a macro variable. The SAS-program is run in a "CPF" process flow file in SAS Studio, and the whole SAS-file and processes are saved and run in a…
user3714330
  • 679
  • 12
  • 32
1
vote
1 answer

In free SAS University Edition convert .sas7bdat to .csv

I am using the free SAS university edition in the browser and would like to convert a data set into a csv format. How do I do this? I have tried this but it doesn't work since the browser version doesn't use a traditional file path.
user18101
  • 626
  • 3
  • 13
  • 22
1
vote
2 answers

Plotting 3d graphs in SAS University Edition

I'm using SAS University edition and I'm trying to find a way to output 3d graphs. I know about the procedures: g3d g3grid However they are not available in my SAS edition, and I was looking for something similar with no avail.
pabloxrl
  • 285
  • 2
  • 12
0
votes
0 answers

I using SAS Studio and dont have access to any scheduling tools, does anyone have a macro that will work to execute code on a certain date?

As mentioned, I dont have any access to scheduling software at work and have a growing list of ongoing reports to keep up with. I'd like to build code or use some sort of functionality within SAS Studio to automate the execution of my code. Below is…
Ctine
  • 1
0
votes
2 answers

Is there an easy way to convert Excel files to SAS format using SASonDemand on a Macbook?

I have several data sets on exel. I am a Macbook user and I use SASonDemand (the online version). How can I convert the excel files to SAS format? I need the files for further analysis on SAS. I tried to watch YouTube videos but I am too new to…
7CP
  • 1
  • 2
0
votes
1 answer

SAS Studio - Count and filter over multiple columns from a macro variable list

I am currently checking a large number of tables for linking keys(all with different names) between datasets. My current code checks for how many records exist and for how many records have a 0 key value. My code looks like this: %let table =…
sassane
  • 21
  • 5
0
votes
2 answers

SAS STUDIO - Selecting columns based on their name

I'm looking to select columns based depending on if they contain the string "time" in the column name. My first attempt looks like this, but I understand there are some issues, and I'm getting the following - ERROR: The following columns were not…
sassane
  • 21
  • 5
1 2
3
4 5 6 7