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

HI,

 

I have a set of data with percentages.

TotalC is a character variable.

 

TotalC

222,98

1,0.3

2,45

13,45

 

 

I need to extract only the part of string before , (210,1,2,13).

 

I need a numeric variable total:

 

Total

210

1

2

13

 

Please advise.

 

Thanks,

Archana

1 ACCEPTED SOLUTION

Accepted Solutions
2 REPLIES 2
ballardw
Super User

Where does the 210 come in? Did you mean the part before the comma:

 

A character variable could be:

 

 

Newvariable = scan(TotalC,1,',');

in a data step.

 

If you need more than before only the first comma then you will need to provide rules.

 

If there is no part before the comma what should the returned value be?

PGStats
Opal | Level 21

total = input(scan(totalc,1,","), best.);

PG

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 2 replies
  • 1563 views
  • 2 likes
  • 3 in conversation