Category "sas"

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