SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Ashwini
Calcite | Level 5


I am working in SAS GRC system .When i convert a numeric colomn into a character it show character value with the reference key.I want the content of the column .for example

Have dataset is

name    country
JOHN    US

RAM     INDIA

HERRY UK

name and country both are numeric .I want both column in character value with


name    country
JOHN    US

RAM     INDIA

HERRY UK

but when use put function it convert to character function but it shows reference key like


name    country name1
JOHN    US       1

RAM     INDIA    2

HERRY UK         3

Kindly help me how to connvert it character value like below dataset

name    country
JOHN    US

RAM     INDIA

HERRY UK

Regards,
Ashwini


1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

Maybe there is a format attached with your name variable.

You can use proc content to check what format the name variable has.

Then use

put(name, myformat. )

Ksharp

View solution in original post

4 REPLIES 4
Ksharp
Super User

Maybe there is a format attached with your name variable.

You can use proc content to check what format the name variable has.

Then use

put(name, myformat. )

Ksharp

Ashwini
Calcite | Level 5

Dear Kshap,

I unable to find the format in sas grc system .Could you please explain me how i decode the format.

Regards,

Ashwini

rakshit_shah
Calcite | Level 5

Hello Ashwini,

               I am also working on SAS EGRC system.....Can you please provide information that on which page of EGRC you are doing the same??

Regards,

Rakshit

rakshit_shah
Calcite | Level 5

Hello Ashwini,

          If you have SAS Enterprise guide or Base SAS, then you can findout the table on which you are working by navigating to the library i.e. sasoprisk or opdetail. Using PROC CONTENTS you can easily find out which format is associated with the variable you are using.

Regards,

Ashwini

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
  • 4 replies
  • 1100 views
  • 0 likes
  • 3 in conversation