BookmarkSubscribeRSS Feed
SASPhile
Quartz | Level 8

0ANUEL
0HRISTOPHE
1009
121
121ST
133NB2
137
1635
19ND72
1COTT


I want to create two datasets separating the above data based on only numbers and mix of numbers and alpha.
like 1009,121,137,1635 go into one dataset and other values into another dataset

1 REPLY 1
ballardw
Super User

Data digits alpha;

     set have;

     if anyalpha(charactervariablename) > 0 then output alpha;

     else output digits;

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
  • 1 reply
  • 579 views
  • 0 likes
  • 2 in conversation