topic Re: Read data with % in SAS Programming

Read data with %

Ronein — Mon, 04 Nov 2019 09:10:33 GMT

Hello

What is the way to read well this data set please?

I get only one row with empty values

Data tbl1;
input  X1909	X1908	X1907	X1906	UCL1	UCL2;
cards;
4% 3% 6% 5.10% 5% 5.20%
3% 2% 2% 4.60% 4.50% 4.90%
5% 5% 5% 5% 7% 8%
;
run;

Re: Read data with %

Patrick — Mon, 04 Nov 2019 09:31:00 GMT

Assuming you want SAS to interpret your source data as numbers in percent and you want to read this data into numerical variables.

Data tbl1;
  input (X1909 X1908 X1907 X1906 UCL1 UCL2) (:percent.);
  format X1909 X1908 X1907 X1906 UCL1 UCL2 percent9.2;
  cards;
4% 3% 6% 5.10% 5% 5.20%
3% 2% 2% 4.60% 4.50% 4.90%
5% 5% 5% 5% 7% 8%
;
run;