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.
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Register now!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.