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
4
votes
2 answers

Refreshing the macro library

I've been using a macro library so that I can use macros without compiling them first. The problem is that when I change the macro and save it, then refresh my filename for the macro lib, this is not enough to update and use the new macro? Anyone…
78282219
  • 593
  • 5
  • 21
4
votes
1 answer

How do you save a snippet of code in SAS Studio as an abbreviation?

In SAS Studio, is it possible to save a snippet of code, such as a header, as an abbreviation so you can pull-up the code in future programs without having to type the whole thing in again? This can be achieved is SAS EG by selecting "Program > Add…
heyydrien
  • 971
  • 1
  • 11
  • 28
3
votes
1 answer

Importing a flat file with row and column delimiters

I am importing a flat .txt file with both row and column delimiters. The problem is that the row delimiter is used to reduce file size and so often the rest of the columns are skipped. Another problem is that the length of the longest character is…
78282219
  • 593
  • 5
  • 21
2
votes
0 answers

Is there a method in SAS Studio to separate a variable with a bimodal distribution?

The variable that I am working with has a bimodal distribution. I need to figure out how to split the variable based on it's distribution. I want to do this programmatically in SAS studio instead of eyeballing it through a histogram.
AAA
  • 21
  • 2
2
votes
3 answers

Assign Year Variable to ID

I use the following code to assign the years 2017,2018,2019,2020 for each ID: proc sort data=Have; by ID; run; data Have2; set Have(keep=id); by id ; if first.id then do Vintage= 2017 to 2020; output; end; run; proc…
78282219
  • 593
  • 5
  • 21
2
votes
1 answer

SAS - Do looping from condition1 to condition2

I am looking to have a programme which cleans up some messy data I have, I am looking to do this for both the assets and liabilities side of the project i'm working on. My question is there a way to use a do loop to use the cleaning up data to first…
78282219
  • 593
  • 5
  • 21
2
votes
1 answer

Left join returns blanks

I have performed a left join where the left table has 500,000 observations. In some cases the left join has been successful for Business_Line = "Retail" where as the next observation is left blank, why is this? the code I used: proc sql; create…
78282219
  • 593
  • 5
  • 21
2
votes
1 answer

Bound my result to [-1,1] in SAS

I am calculating a fraction based on the payments made in four years and I wish to put a cap on my fraction such that it can only be between -1 and 1. Subsequently I'd like to make the following fractions 0 if the cap is maxxed out - an example…
78282219
  • 593
  • 5
  • 21
2
votes
1 answer

Error: array subscript out of range for i+2 years

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
2
votes
2 answers

SAS Studio-Dealing with Variable Names that have Spaces

When I load in an excel sheet through PROC IMPORT, locally installed SAS automatically replaces the variable names with spaces to an underscore (_). Such as Patient ID will become Patient_ID and Health Records will become Health_Records. However,…
Ehwic
  • 21
  • 1
  • 3
2
votes
1 answer

How can we import files from PC directly in SAS University Edition?

I am using SAS University Edition and i have to import files into SAS software. I have tried using 'infile' and 'proc import' statements but these are not working when accessing the files directly from PC. Is there a way to access the files directly…
Krishan Avtar Singh
  • 73
  • 1
  • 2
  • 7
1
vote
0 answers

How to copy the entire folder from one directory to another SAS studio?

How to create a SAS macro-function that can copy standard work folders based on different project types to the project folder? Standard work folders are saved in SAS Studio at： %let standard_work_A = "/aaa/standard_work/standard_work_A" %let…
Yumeng Xu
  • 179
  • 1
  • 2
  • 11
1
vote
0 answers

Writing mathematical equation for an ARIMA(0,1,1)(1,0,0)12

I would like to understand how to write the equation of an ARIMA(0,1,1)(1,0,0)12. I'm using SAS Studio to estimate the parameters and here is the result (https://i.stack.imgur.com/pHoSO.png) I've tried to substitutes the the estimated parameters to…
Ferisca
  • 11
  • 2
1
vote
0 answers

SuperNewbie_Asking(begging, really) WARNING: Library PBDATA does not exist

I have a raw data set in my files in SAS provided by the prof, she wants us to read the (.dat) file in SAS, use a LIBNAME, PROC IMPORT then PROC PRINT.... my proc import was working fine on it's own, now all I get is SAS import unsuccessful, I need…
user19235064
1
vote
1 answer

Accessing oracle DB through SAS

I am trying to access oracle server (I use sqldeveloper) through SAS studio and not able to figure out the right path libname oralib clear; libname oralib oracle path=? user=myuserid password=mypass connection=global; I am not sure what the path…
Giri
  • 11
  • 1
1
2 3 4 5 6 7