BookmarkSubscribeRSS Feed
Saurabh_Amar
Calcite | Level 5

Hi,

What i need to do is create format for all possible values of a variable using proc format

For example if i have country_code and country_name as fields, what i want to do is

Proc format;

values $cntry

                    "US" = ""UNITED STATES OF AMERICA

                    "IND" = "INDIA"

                    ....

                    ....

                    till all possible values

run;

How can i do that in macros? What i did was took all possible values in different macros using call symput and count also but dont know how to write out the values part.

Regards,

Saurabh

1 REPLY 1
Linlin
Lapis Lazuli | Level 10

you can use your dataset to create format. search create format from sas dataset:

http://www2.sas.com/proceedings/forum2007/068-2007.pdf

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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
  • 1 reply
  • 1112 views
  • 1 like
  • 2 in conversation