BookmarkSubscribeRSS Feed
nrb
Fluorite | Level 6 nrb
Fluorite | Level 6

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 

1 REPLY 1
Astounding
PROC Star

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 621 views
  • 1 like
  • 2 in conversation