BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
art297
Opal | Level 21

I agree with @Tom:

data ds2;
  infile datalines dlm='09'x missover;
  input @;
  do while (index(_infile_,'0909'x) gt 0);
    _infile_=tranwrd(_infile_,'0909'x,'092E09'x);
  end;
  if _infile_=: '09'x then _infile_='.'||_infile_;  input (var1-var8) ($);
  datalines;
2	"28 	4					29"	
	"28 	4					29"	
2	"28 	4					29"	
;
run;

Art, CEO, AnalystFinder.com

 

atul_desh
Quartz | Level 8

Thank you so much @art297and @Tom

 

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 16 replies
  • 4973 views
  • 3 likes
  • 6 in conversation