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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.