import percent values

[VISHNU239]

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.

[PeterClemmensen]

Show us your code 🙂

[VISHNU239]

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.

[novinosrin]

informat can't be in length stmt

try

data abc;

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

input target_percent :  percent6. ;

run

or

data abc;

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

informat target_percent percent6. ;

input target_percent;

run;

[Tom · Accepted solution]

---

@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;

[VISHNU239]

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.