BookmarkSubscribeRSS Feed
Obsidian | Level 7



I have a sas dataset and in that dataset I have a column and there we should have 4 record in that column. for ie. JAN,FEB,MAR,APR. if any one is missing then its an issue and i have another icolumn with the name issue and that should get updated if any value is missing.



Quartz | Level 8

4 records only?


Why do you need SAS ?

Why do you need to automate ?


2 to 3 mins manual work will do plus that will help keep people stay employed 🙂

Obsidian | Level 7

This is because those 4 records can be duplicates. and it can reach to million.




Super User
You need to provide a lot more details of your actual problem. Please post a small sample data set and expected output, which would help a lot more.

For example, how do you know what values should exist? To me if I find Jan, Feb, March, I would say March is not correct because its more than 3 letters?
How do you know you need 4 rows?

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 3 in conversation