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.
@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;
Show us your code 🙂
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.
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;
@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;
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.