topic Re: import percent values in SAS Programming

import percent values

VISHNU239 — Sun, 01 Jul 2018 04:37:52 GMT

Hi, i have data in .csv file. i am unable to read percent variables into sas enterprise guide. percent variables values are like 98%,92%. i tried percent6. in length and input statements but still percent values are not being read. i am using infile statement to import the file to sas. please help me.Thanks in advance.

Re: import percent values

PeterClemmensen — Sun, 01 Jul 2018 04:38:33 GMT

Show us your code 🙂

Re: import percent values

VISHNU239 — Sun, 01 Jul 2018 04:49:09 GMT

data abc;

infile "file path" dsd dlm=',' firstobs=2 missover;

length target_percent percent6.;

input target_percent;

run;

input file has target_percent values as 98%. i need to read 98% into target_percent in sas and it should be displayed as 98% in sas.Thank you.

Re: import percent values

novinosrin — Sun, 01 Jul 2018 05:23:08 GMT

informat can't be in length stmt

try

data abc;

infile "file path" dsd dlm=',' firstobs=2 missover;

input target_percent : percent6. ;

run

data abc;

infile "file path" dsd dlm=',' firstobs=2 missover;

informat target_percent percent6. ;

input target_percent;

run;

Re: import percent values

Tom — Sun, 01 Jul 2018 05:57:21 GMT

@VISHNU239 wrote:

Hi, i have data in .csv file. i am unable to read percent variables into sas enterprise guide. percent variables values are like 98%,92%. i tried percent6. in length and input statements but still percent values are not being read. i am using infile statement to import the file to sas. please help me.Thanks in advance.

You can use the PERCENT informat to read text strings that have %. You can use the PERCENT format to display values with %.

data want ;
  input p :percent. ;
  format p percent. ;
cards;
98%
.98
50%
0.5
;
proc print;
run;

Re: import percent values

VISHNU239 — Wed, 11 Jul 2018 17:27:46 GMT

Hi, Tom.

I changed the code to this way

data abc;

infile "file path" dsd dlm=',' firstobs=2 missover;

length target_percent 8. ;

input target_percent :percent. ;

run;

In the output of sas the percent values are being displayed as .50 instead of 50%. Any other suggestions. Your suggestion worked for calculation part but for the display it is showing as .50 instead of 50%. Thank you.