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

I found the code I think I need and made a few edits but my new vars are numeric rather than char. I need char vars;

data I have:

sp

doe, john;doe, jane;doe, jack

 

data i want:

sp1                   sp2            sp3

doe, john         doe, jane   doe, jack

 

 

Code:

data betty3;
set betty2;
array parsed_vars(*) sp1-sp3;
i=1;
do while(scan(sp, i, ";") ne "");
parsed_vars(i) =scan(sp, i, ";");
i+1;
end;
run;

1 ACCEPTED SOLUTION

Accepted Solutions
art297
Opal | Level 21

Specify that the array is character. e.g.

 

array parsed_vars(*)  $25. sp1-sp3;

Art, CEO, AnalystFinder.com

View solution in original post

2 REPLIES 2
art297
Opal | Level 21

Specify that the array is character. e.g.

 

array parsed_vars(*)  $25. sp1-sp3;

Art, CEO, AnalystFinder.com

collinelliot
Barite | Level 11

You need to specify that your array is character with a "$"

 

You also will probably want to assign some appropriate length to the variables you created or you might see truncation.

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
  • 2 replies
  • 1391 views
  • 2 likes
  • 3 in conversation