topic Reading Numeric data in New SAS User

Reading Numeric data

BrahmanandaRao — Mon, 03 Jun 2019 05:55:20 GMT

Hi Experts Good Morning

Here my dataset in this dataset input numbers using dollar sign data read like below without dollar sign missing

The SAS System

i want output

1,22, 6, 55,668 ,77

47 , 3, 55 98,66

data dsn;
input numbers $ 7. @@ ;
datalines;
1,22, 6, 55,668 ,77
47 , 3, 55 98,66 
run;

PeterClemmensen — Mon, 03 Jun 2019 06:07:27 GMT

data dsn;
input numbers $20.;
datalines;
1,22, 6, 55,668 ,77
47 , 3, 55 98,66 
run;

BrahmanandaRao — Mon, 03 Jun 2019 06:09:51 GMT

HI Draycut

i got solution thank you

i have doubt why should we use dollar sign even though it is numeric data

could you please clarify

ballardw — Mon, 03 Jun 2019 14:39:25 GMT

You should show examples of the actual file that was read and ideally the code used to read the data.

Also you should show what you expect the results to look like.

If you want to display numeric values as currency then the display format DOLLAR should be used.

Example;

data example;
  input x;
  put x Dollar16.2;

datalines;
123.45
0.57
123456789.89
;

The example code provided by @PeterClemmensen reads values as character.