Category "sas"

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