BookmarkSubscribeRSS Feed
VRD
Calcite | Level 5 VRD
Calcite | Level 5
btext1btext2btext3trt1trt2trt3
sample1XXXXXXXXX
sample1ana1XXXXXXXXX
sample1ana1ban1XXXXXXXXX
sample1ana1ban2XXXXXXXXX
sample1ana1ban3XXXXXXXXX
sample1ana1ban4XXXXXXXXX

texttrt1trt2trt3
sample1XXXXXXXXX
ana1XXXXXXXXX
ban1XXXXXXXXX
ban2XXXXXXXXX
ban3XXXXXXXXX
ban4XXXXXXXXX

can any one help me in this?

3 REPLIES 3
Haikuo
Onyx | Level 15

Look up Coalescec() function and Keep/Drop statement.

Haikuo

stat_sas
Ammonite | Level 13

data want(drop=btext2 btext3);

set have;

if btext2 ne ' ' and btext3=' ' then btext1=btext2;

if btext3 ne ' ' then btext1=btext3;

run;

sas-innovate-2024.png

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!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 685 views
  • 0 likes
  • 4 in conversation