topic How to get the desired output? in SAS Programming

How to get the desired output?

sasiroyal — Mon, 06 Nov 2023 17:51:41 GMT

Hi ,

data ds;

input x $ y $ z $;

cards;

ram is agoodboy

;

run;

output:

x y z a

ram is agoodboy ram

agoodboy

It is only one observation in the final output.

Anyone can help me how to get this output ?

Re: How to get the desired output?

Reeza — Mon, 06 Nov 2023 17:59:01 GMT

So a is the text with linefeeds? AFAIK there isn't a way to store data like that in a data set, but you can print it that way in a report or export to RTF. Not sure about Excel.

That's what would be called a display format, not a storage format.

Re: How to get the desired output?

Sajid01 — Mon, 06 Nov 2023 18:15:01 GMT

Please see this post that has the solution to your issue.

https://communities.sas.com/t5/SAS-Programming/Override-space-as-delimiter-in-reading-text-files/td-p/743879
With the above post in mind, your code would be like this.

DATA ds ;
  ATTRIB a LENGTH = $200 ;
  INFILE datalines TRUNCOVER;
  INPUT a $char200.;
  datalines;
ram is a good boy
; 
RUN ;

Re: How to get the desired output?

ballardw — Mon, 06 Nov 2023 18:18:35 GMT

If the question is "how do I insert carriage return and/or linefeed characters between values of a single variable the answer would be the CATX function. But the data set viewer won't honor them and they may get treated oddly by different display formats, RTF, PDF, HTML depending on the exact syntax used to display them.

data ds;
   input x $ y $ z $; 
   a=catx('0D'x,x,y,z); 
   output;
cards; 
ram is agoodboy
; 

proc print data=ds;
var x y z;
var a /style=[asis=on];
run;

But if you don't use the style override in Print the variable A appears on one line with spaces between bits.