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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.