topic numeric to character format in sas grc in SAS Programming

numeric to character format in sas grc

Ashwini — Fri, 11 May 2012 06:29:46 GMT

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

Re: numeric to character format in sas grc

Ksharp — Fri, 11 May 2012 07:25:06 GMT

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

Re: numeric to character format in sas grc

rakshit_shah — Fri, 11 May 2012 13:29:37 GMT

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

Re: numeric to character format in sas grc

Ashwini — Mon, 14 May 2012 02:03:46 GMT

Dear Kshap,

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

Regards,

Ashwini

Re: numeric to character format in sas grc

rakshit_shah — Mon, 14 May 2012 13:36:12 GMT

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