Category "sas"

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