topic Horizontally aligned data in SAS Software for Learning Community

Horizontally aligned data

Younes10 — Sat, 26 Feb 2022 04:55:23 GMT

Hey guys, I'm stuck in a project. My code will only print 3 obs but I need it to print 5 as you can see the other two obs are aligned horizontally from the first and second lines of data. How do I make them print with the other 3 data lines without touching the data itself?

This is what it prints.

But I need it to print like this. Can someone please help me?

THANKS!

Re: Horizontally aligned data

SASKiwi — Sat, 26 Feb 2022 05:39:55 GMT

Split your DATALINES rows into 5 lines, after your date variable, then it will import and print correctly.

Re: Horizontally aligned data

Younes10 — Sat, 26 Feb 2022 05:43:36 GMT

I cannot touch the datalines. My professor said I have to write a code for it.

Re: Horizontally aligned data

Patrick — Sat, 26 Feb 2022 07:10:02 GMT

Lookup in the SAS Documentation for the INPUT statement what the @ can get used for.
Then adopt below sample to your code and data.

data test;
  infile datalines dlm=',';
  input a b @@;
  datalines;
1,2
1,2,3,4,5,6
1,2,3,4
;

proc print data=test;
run;

Re: Horizontally aligned data

Younes10 — Mon, 28 Feb 2022 01:57:21 GMT

Thank you so much! it helped!

Re: Horizontally aligned data

Tom — Mon, 28 Feb 2022 03:04:35 GMT

There is no alignment required here. Just read the values.

If you want SAS to keep reading from the same line to get the next observation then use double trailing @ on the INPUT statement.

Also read the numbers as numbers, not strings.

And add formats to display the numbers the way you want. Avoid MDY or DMY ordering for dates as either choice will confuse half of your audience. Use YMD order or DATE format.

  input price :comma. sqft tax date :anydtdte. @@;
  format price dollar10.2 date yymmdd10.;