topic Re: COnverting the numeric part of a numeric variable into its corresponding fraction. in SAS Data Management

Converting the numeric part of a numeric variable into its fraction

Antaralib — Sun, 24 Apr 2016 10:17:45 GMT

HI,

I have a dataset of 14 columns.

One of those variables show the percentage of students. e.g 25%

I need to remove the % and replace it with it's corresponding fraction. e.g 25/100 = .25

Please let me know if I can do this together.

However, what I have doen is just stripped the % from the column. How to go about the next part in the same column.

thanks

COnverting the numeric part of a numeric variable into its corresponding fraction.

Antaralib — Sun, 24 Apr 2016 10:18:41 GMT

HI,

I have a dataset of 14 columns.

One of those variables show the percentage of students. e.g 25%

I need to remove the % and replace it with it's corresponding fraction. e.g 25/100 = .25

Please let me know if I can do this together.

However, what I have doen is just stripped the % from the column. How to go about the next part in the same column.

thanks

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

data_null__ — Sun, 24 Apr 2016 11:15:54 GMT

@Antaralib wrote:

HI,

I have a dataset of 14 columns.

One of those variables show the percentage of students. e.g 25%

I need to remove the % and replace it with it's corresponding fraction. e.g 25/100 = .25

Please let me know if I can do this together.

However, what I have doen is just stripped the % from the column. How to go about the next part in the same column.

thanks

If we assume the variable is character and not numeric being displayed with PERCENT format you can read it using the INPUT function into a numeric variable with value .25.

40         data _null_;
41            pct = '25%';
42            pct2 = input(pct,percent.);
43            put _all_;
44            run;

pct=25% pct2=0.25 _ERROR_=0 _N_=1

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

Antaralib — Sun, 24 Apr 2016 11:40:52 GMT

Thanks for the prompt response. However the variable is in best32. format.

I tried :

data _null_;
41            pct = '25%';
42            pct2 = input(pct,percent.);
43            put _all_;
44            run;

with the parameters actually in question. Although the log shows

pct=25% pct2=0.25 _ERROR_=0 _N_=1

I don't see the column with the value 0.25. It still shows 25. I need it to reflect that fraction.

Thanks

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

data_null__ — Sun, 24 Apr 2016 11:51:55 GMT

If the variable you have is numeric and has format best32 then it will not display with a percent sign. Please show output from PROC CONTENTS for the variable in question and show it looks with PROC PRINT.

Also my program was and example not the exact code you need to execute. Especially with new information the variable is numeric.

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

data_null__ — Sun, 24 Apr 2016 11:56:45 GMT

Now I see you do mention numeric variable in the title of you question.

In that case you simply need to change or remove the associated format which must now be PERCENT. or PERCENTN.

Do you know how to change a format?

Re: Converting the numeric part of a numeric variable into its fraction

TomKari — Sun, 24 Apr 2016 13:15:53 GMT

First, a question.

Is your variable a numeric variable with the % sign applied using a format? Or is it a character variable?

Tom

Re: Converting the numeric part of a numeric variable into its fraction

Antaralib — Sun, 24 Apr 2016 13:55:40 GMT

THanks Tom.

My variable looks like :
international_students
25%
27%
33%
22%
And the informat for it is best32.

Now I want to have column that would look like its corresponding fractions:

.25
.27
.33
.22

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

Antaralib — Sun, 24 Apr 2016 13:57:22 GMT

Thanks for the response.

Do you mean changing the format in the infile statement?

Or,

Storing the percent in the numeric value?

Although, I need a separate/same column variable that would show the fractions of the percentages.

e.g instead of 25%

33%,

it should show

.25

.33

Thanks

Antara

Re: Converting the numeric part of a numeric variable into its fraction

TomKari — Sun, 24 Apr 2016 14:58:30 GMT

If you have a best32. informat, that means that your variable is numeric.

In that case, you should be able to get your desired appearance by changing the format.

This should work nicely:

proc datasets lib=work nolist;

modify have;

format TestVar 5.2;

run;

Tom

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

Reeza — Sun, 24 Apr 2016 16:54:03 GMT

Although both @TomKari and @data_null__ have posted correct solutions, you can also fix this in your import process, if you're using an infile statement to read the code.

Leave the informat as is, and add a format statement in the data step to format the data as it's read in.

If you can't figure it out, or it doesn't work post your full code.

Something like the following would work:

format variable best8.;

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

Antaralib — Mon, 25 Apr 2016 03:54:12 GMT

Thanks. APpreciate the help.

However,

proc datasets lib=dm nolist;
modify timeseries_1;
format international_Students 5.2;
run;

proc datasets lib=dm nolist; (dm is my lib name and timeseries_1 is my file name)
modify timeseries_1;
format international_Students best8.;
run;

gives me upto 2 decimal places. eg. 25.00, 33.00.

But I want the fraction .25, .33 etc.

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

Antaralib — Mon, 25 Apr 2016 04:00:53 GMT

Even,

format international_Students FRACT2.;

did not work.

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

Antaralib — Mon, 25 Apr 2016 04:03:34 GMT

Hey all,

I want to crrect one error.

If the variable data value is 25%, I need it to display 1/4 and not .25.

Apologies.

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

Reeza — Mon, 25 Apr 2016 04:13:55 GMT

Use the FRACTw. format.

Format variable fract8.;

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

Reeza — Mon, 25 Apr 2016 04:16:31 GMT

If your number is 25 you'll have to divide it by 100 first, either in your import or a separate data step.

Data sample;
Input value;
Value_fract=value/100;
Format value_fract fract8.;

Cards;
25
33
45
67
;
Run;

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

Antaralib — Mon, 25 Apr 2016 05:32:46 GMT

Thanks Reeza.

This did not work.

data dm.timeseries_1;
input international_students;
international_students_fract = international_students/100;
format international_students_fract fract8.;
run;

I simply tried this and it did work:

data dm.timeseries_1;
set dm.timeseries;
international_students_fract = international_students/100;
format international_students_fract fract8.;
run;

But the still my issue remains, converting a number into it's fraction in the same column itself.

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

Reeza — Mon, 25 Apr 2016 09:00:03 GMT

Does my sample code work?

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

ballardw — Mon, 25 Apr 2016 17:15:53 GMT

Show the actual input values, the actual output values, the desired output and describe exactly how it "doesn't work": no output, incorrect output, close but not quite what is wanted.

And run PROC contents on your data set and show the results.

Re: COnverting the numeric part of a numeric variable into its corresponding fraction.

Reeza — Mon, 25 Apr 2016 17:33:13 GMT

@Antaralib wrote:

But the still my issue remains, converting a number into it's fraction in the same column itself.

I don't know what doesn't work means.

If you want it in the same column then divide the value by 100 and apply the format to the variable - using the same name. Or write a custom format, but I wouldn't recommend that.

 data dm.timeseries_1;
set dm.timeseries;
international_students = international_students/100;
format international_students fract8.;
run;