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
0 answers

Why is the "root" logger required in my SAS log configuration file?

I set this logs config file for retrieve SAS Studio logs: Set-Content -Path "C:\SAS\ModelMgr\Lev1\Web\Common\LogConfig\SASStudio-log4j.xml" -Value @"
KuRu
  • 31
  • 5
0
votes
1 answer

Got a warning message in SAS Studio about it expiring

Got a warning message: ...when opening up Sas Studio. I do not pay for it (it has been free to use, have been using it for half a year at least) Not sure what should I do, because I would like to keep using it and I would like to keep all my…
PKaru
  • 1
0
votes
1 answer

How do I rename the rows in the observation

here I am using proc freq Proc freq data=external_raw; table Marital_status; run; this the table the shows up: Marital_status Frequency Percent Cumulative Frequency Cumulative…
0
votes
2 answers

ERROR: Physical file does not exist {on SAS studio (Academic ondemand-web based)}

I am combining two XPT files with following program code: LIBNAME DM XPORT '/home/u62208181\DEMO.XPT'; LIBNAME QX XPORT '/home/u62208181\CDQ.XPT'; LIBNAME OUT '/home/u62208181'; DATA OUT.CDQ_DEMO; …
Pkbti
  • 9
  • 3
0
votes
1 answer

SAS error thinking a variable is defined as both character and numeric

This is occurring in SAS Studio. I'll keep this as simple as possible. This problem has been driving me crazy for hours now. I've searched for similar issues and found none involving datasets as simple as the ones I'm working with. I have an…
Peetrius
  • 203
  • 1
  • 9
0
votes
2 answers

Sas create global variable based on cell value

Can anybody help me with the following: I have the a dataset that I filtered to only contain one row. I now want to create a global variable based on the value in a specific column. I tried the following: data _null_; last_dat_value = …
gumpy007
  • 65
  • 5
0
votes
2 answers

Is there a SAS function similar to an Xlookup?

I am working on a project that involves two separate CSV files. The first data set, "Trips" has seven columns, with a trip_id, bike_id, duration, from_station_id, to_station_id, capacity and usertype. User type is the only character values, the rest…
0
votes
1 answer

How to divide all the observations based on a sum of a column

I'm trying to do simple calculations but I'm new and SAS is not intuitive to me. Suppose I have this table. data money; infile datalines delimiter=","; input name $ return $ invested; datalines; Joe,10,100 Bob,7,50 Mary,80,1000 ; Which creates…
Lacrosse343
  • 491
  • 1
  • 3
  • 18
0
votes
1 answer

SAS studio / SQL, how to count and sum the columns and create a new column to store them?

This is the data set, what I want to do is to count how many Yes in each row, like the first row has 3 Yes so in my new column called Product_Held will have "3".
Alvin
  • 1
  • 2
0
votes
0 answers

Error code accessing SASHELP.ZIPCODE.DATA in SAS Studio

I am using SAS Studio in VirtualBox, when attempting to access the zip code data SASHELP file in SAS Studio libraries I get the following error: ERROR: User does not have appropriate authorization level for file SASHELP.ZIPCODE.DATA. Any idea why or…
llemke
  • 1
0
votes
1 answer

Left join a bucket value based on a greater than clause

I am looking to create an optimal bucketing macro. My first obstacle is to create equidistant buckets. I am using the sashelp.baseball dataset as an example. I take the range of logsalary and divide this by 100 to create the distance between each…
78282219
  • 85
  • 1
  • 8
0
votes
1 answer

SAS: Proc freq by group for all variables at once?

I use Proc freq to calculate the Somers' D between the dependent variable (log salary) and the independent variable (crhits, crhome, etc.) Is there a way to get the all the results in one proc freq statement? The code I use currently is DATA…
78282219
  • 85
  • 1
  • 8
0
votes
2 answers

Proc hpbin with minimum proportion per bin

I am using Proc HPBIN to split my data into equally-spaced buckets i.e. each bucket has an equal proportion of the total range of the variable. My issue is when I have extremely skewed data with a large range. Almost all of my datapoints lie in one…
78282219
  • 85
  • 1
  • 8
0
votes
1 answer

SAS: Can you save the input table of a SAS generated bar-line chart?

So I am generating a SAS bar-line chart in SAS with a dataset which looks like this: id date default var1 log_var1 square_var1 ... cubic_var1 1 1 1 5 -3.3 0.9 1.2 1 2 0 15 -9.9 2.7 3.6 2 1 …
78282219
  • 85
  • 1
  • 8
0
votes
1 answer

How does SAS proc stdize method=range work?

How does PROC STDIZE METHOD = RANGE work? I thought that it would work like this: Score = (Observation - Min) / ( Max - Min) However, the range is [1,100] and there is never a 0 i.e. when you would substract the min observation from itself on the…
78282219
  • 159
  • 1
  • 12