DATA Step, Macro, Functions and more

How to read this datalines and format them.

Reply
Occasional Contributor nrb
Occasional Contributor
Posts: 11

How to read this datalines and format them.

[ Edited ]

How do you  read in this data with the following datalines. CURR is stored in the first three columns, next three variables, namely, DDEP, PRICES, and GNP are stored in four columns each, WAGES is stored in the next three columns, the next three variables, namely, INCOME, POPULATION, and CONS are stored in the following four columns each, and variable YEAR is stored in the next two columns and the QUARTER is stored in the last column.  Furthermore, all the variables’ values are one decimal number except the last two variables, which are whole numbers.  *Do not change the formatting of the datalines because that's how you're supposed to read it in.

 

251 920 8993180154270015401739511

253 929 9033258157276215471743512

257 939 9103328158280515541774513

260 959 9223369161285315611809514

263 972 9163395163286315671817521

265 980 9243391163286615731855522

268 990 9303456167291715811893523

272 999 9303577170301215881930524

2751001 9263642173306015941950531

2771007 9333675174307916001967532

2781008 9393658176306416071976533

2781010 9363608177298516151977534  

282107810054347208357917402467581

283109310084383210359317462506582

284110610084514212370217542545583

285112210084644217383017622570584

287113310084740219392417692612591

289114110154869221404917762648592 

Super User
Posts: 5,500

Re: How to read this datalines and format them.

[ Edited ]

Here's a test you can run, so you can possibly figure this out for yourself.

 

Input @1 curr_test1 3.   @1 curr_test2 3.1   @1 curr_test3 3;

 

Then print the results and compare them to the original data.

Ask a Question
Discussion stats
  • 1 reply
  • 120 views
  • 1 like
  • 2 in conversation