Help using Base SAS procedures

can anyone help me

Reply
New Contributor lm
New Contributor
Posts: 4

can anyone help me

I am doing validation for a dataset

I have two datasets

dataset A has usubjid, trt, studywk

dataset B has usubjid  visit

dataset A has studywk as 1 2 3 ...11...99

dataset B also has studywk as s01 s02 s03 ....s11,s12,,,s99  B datasets has more number of observations but i need visit only from dataset B and studywk also.

what is the best proc sql method to get this two datasets merged.

Super User
Posts: 9,687

Re: can anyone help me

if variable studywk in dataset A is character type. it is first starting:

select b.*

from b,a

  where b.studywk contains strip(put(a.studywk,z2.)) ;

Ksharp

Ask a Question
Discussion stats
  • 1 reply
  • 143 views
  • 3 likes
  • 2 in conversation