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