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;
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;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Save the date!
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.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!