Category "sas"

SAS Visual Analytics Report export detailed data not possible

After having updated an Visual Analytics report, the option to export "Detailed data" is not available anymore. Only the export of "Formatted data" is possible.

SAS: assign a value to a variable based on characteristics of other variables

I'd like to assign to an empty field a value based on many values of other entries. Here my dataset: input ID date $10. type typea $10. ; datalines; 1 10/11/

I don't see an explanatory legend in SAS proc freq

I have a problem with the legend not being visible at cross tabulation in porc freq in SAS. How can I show it? I see only a table: But I want to also see a leg

Setting the values ​of a COUNT(*)

I'm using SAS and I'm stuck when I want to relay this in SQL : I have a column that counts the number of line repetitions : DUPLICATES | NUMBER | DATE ------

SAS BigQuery Logistic Regression

Is there a way I can match SAS logistic regression results with BigQuery ML logistic regression results (coefficient / intercept values for same data)?

SAS- How Code an array from previous set of variables

I need to create a new variable in which is comprised of a list of other variables found in my dataset. HAD1 (1=yes 2=no 9=unknown), HAF10 (1=yes 2=no 9=unknown

How to run multiple Linux command line statements from SAS synchronously, with piped response?

I can run: filename my_com pipe "sleep 60s"; data _null_; file my_com; run; And the log shows a full 60 second wait: But if I run: filename my_com pipe "echo

how to reference a macro list in a filter of sas query editor

Hello Stackoverflow community. I need to insert a filter into SAS Enterprise Guide query builder. This filter should contain a huge list of product codes, the f

converting a SAS Macro to python with Pandas?

I'm converting a program of SAS code into a python equivalent. One section that i'm struggling with is how to convert a macro program in SAS when the variables

How to reduce time taken by sas macro code to run

I need help with my monthly report sas code below: Firstly the code takes too long to run while the data is relatively small. When it completes a message that r

How to sum individual entries from multiple tables in SAS

What I have: Team A Material Accommodation Travel Jan 8 12 10 Feb 8 15 30 Mar 9 12 20 Team B Material Accommodation Travel Jan 4 18 20 Feb 7 14 20 Mar 6 12 10

Formatting in SAS to Create Buckets

I use the following code to bucket my continuous variable in SAS, but it does not work: proc freq data = right; table Age; run; proc format; value AgeBucke

How to use SAS to split a string into two variables

I have a dataset as below: country United States, Seattle United Kingdom, London How can I split country into a data in SAS like: country

Writing ISO8859 data to MySQL in R (error:"could not run statement: Invalid utf8 character string")

I need to import an SAS Transfer File (.xpt) to MySQL. Because I don't own SAS, I tried a) first importing the .xpt in R b) then using dbWriteTable from the li