BookmarkSubscribeRSS Feed
Ronein
Meteorite | Level 14

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;
1 REPLY 1
Patrick
Opal | Level 21

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-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 321 views
  • 0 likes
  • 2 in conversation