- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Dear Kshap,
I unable to find the format in sas grc system .Could you please explain me how i decode the format.
Regards,
Ashwini
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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