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
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
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
Dear Kshap,
I unable to find the format in sas grc system .Could you please explain me how i decode the format.
Regards,
Ashwini
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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.