python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - sas-macro

How to convert xpt file into sas file by xpt2loc?

I tried to convert a xpt file called "ae.xpt" into sas file called ae as well. The original file was saved at "D:\sdtm\data_xpt", and I want the converted sas file to be saved at &...
test-img

Robin

sas

sas-macro

Votes: 0

Answers: 0

How to use SAS - PROC SQL, IF THEN statement and a Do loop in 1 script?

Hopefully somebody can help me with my problem. For the company I work for, I need to check if there is any data available in the dataset which is delivered monthly to me. If there is no data availabl...
test-img

Roontje

if-statement

sas

sas-macro

proc-sql

do-loops

Votes: 0

Answers: 1

Latest Answer

Sounds like you just need to create a dataset with the list of values you want to force to exist and merge it with your actual data. data required; do yearmonth = 202110, 202111 ; output; end...
test-img

Tom

Output from SAS CEM macro for measuring average treatment effect on variable of interest Y?

I'm running Gary King's CEM (Coarsened Exact Matching) macro (download here) in the SAS language for a case control study. I'm using the following macro call format: options source2; %include "D:...
test-img

RobertF

sas

sas-macro

Votes: 0

Answers: 1

Latest Answer

From looking over the macro, it looks like the output dataset is in &lib. and is called L1_finale; see if that exists and has what you expect in it.
test-img

Joe

SAS remove the last characters if special

I have a sas dataset with the variable called response, which has the following records: and so on. These are all the same records, I need to remove the last character wherever special and return the...
test-img

IndigoChild

sql

sas

substring

sas-macro

Votes: 0

Answers: 2

Latest Answer

Using PRXCHANGE prx=prxchange("s/^W*(.*?)\W*$/$1/",-1, response); will remove trailing special characters data have; length response $20.; response="Trailer*Offer";output; respons...
test-img

Kermit

Posts

Questions

Blogs

Jobs