topic Re: Dots in output data in SAS? in SAS Programming

Dots in output data in SAS?

Zynep93 — Wed, 09 Oct 2024 19:13:13 GMT

Hello everyone,

I designed my data in Excel to run in SAS; however, SAS does not read the data. The output data shows some dots. Screenshot is attached.

I have my different fertilizers treatments (frt) in the first column, the second column is plant height (ph), and the third row is the week that I have, which will be for repeated measures. Since fertilizers are non-numeric values, I put the'' $'' sign next to ''frt''. Does anyone know what causes this issue and how to correct it?

Re: Fullstops in output data in SAS?

PeterClemmensen — Wed, 09 Oct 2024 19:11:08 GMT

I suspect you have tabs instead of spaces between your data values?

Re: Fullstops in output data in SAS?

PeterClemmensen — Wed, 09 Oct 2024 19:13:09 GMT

Try replacing them for spaces or put

dlm=’09’x

in your Infile Statement.

Re: Fullstops in output data in SAS?

Zynep93 — Wed, 09 Oct 2024 19:14:04 GMT

it could be yes, how could I remove that tab?

Re: Fullstops in output data in SAS?

Zynep93 — Wed, 09 Oct 2024 20:04:52 GMT

I put it before the input statement. Did not work.

Re: Fullstops in output data in SAS?

ballardw — Wed, 09 Oct 2024 20:10:49 GMT

Did not work is awful vague.

Are there errors in the log?: Post the code and log in a code box opened with the "</>" to maintain formatting of error messages.

No output? Post any log in a code box.

Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the "</>" icon or attached as text to show exactly what you have and that we can test code against.

The suggestion was an OPTION on an INFILE statement that reads an external file. If you don't have the INFILE point to the correct file, or any file, then it will not work.

Please include the LOG with the whole submitted code as text as shown above. We can't make copy/edit/paste corrections to code that appears in pictures.

Re: Fullstops in output data in SAS?

Zynep93 — Wed, 09 Oct 2024 20:28:47 GMT

there is no errors in the log! It did not work out, which means that when I ONLY run the datelines, I still see the dots. I also did put '' infile data lines dlm='09'x;'' after ''data'' statement on the top. I was not sure I put the infile statement in the correct place. This is the log:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69 data Waterford;
70 infile datalines dlm='09'x;
71 input frt$ ph Week;

72 datalines;

NOTE: Invalid data for ph in line 74 1-3.
NOTE: Invalid data for Week in line 74 5-80.

Re: Fullstops in output data in SAS?

Tom — Wed, 09 Oct 2024 21:48:29 GMT

If you have inserted actual TAB characters into your in-line data then you can use the EXPANDTABS option of the INFILE statement to have SAS replace them with the proper number of spaces to move to the next tab stop. Also add the TRUNCOVER option incase any of the lines have fewer values on them than the INPUT statement wants. If you need to represent a missing value in the data use a single period (for either numeric or character variables).

data Waterford;
  infile datalines expandtabs truncover ;
  input frt$ ph Week;
datalines;
XXX 1 2
YYY 2 3
ZZZ . 4
. 5 6
;

Note that most of the SAS editors (and most full functioning text editors) have an option to replace tabs with spaces when typing. So you can use the TAB key like you would on an actual typewrite, to move to the next tab stop, and the editor will insert the right number of spaces to get there.

Re: Dots in output data in SAS?

Ksharp — Thu, 10 Oct 2024 01:31:47 GMT

There are must have invisible/unprintable character at end of Week, like TAB CR..
Firstly try to read WEEK in by character type and get rid of these unprintable character in WEEK.

input frt $ ph Week $;
want=input(compress(week,'.', 'kd'),best32.);

Re: Fullstops in output data in SAS?

Zynep93 — Thu, 10 Oct 2024 13:26:57 GMT

Thank you for this. I created the data on Excel; I did not intentionally put or add tabs/spacers. Does Excel automatically add them when I copy from there to paste on SAS? Is there any other way to arrange the data without adding this statement for the next time? I have no problem, but I am just asking.

Re: Fullstops in output data in SAS?

Tom — Thu, 10 Oct 2024 13:50:12 GMT

Excel does insert tabs between cells when you copy and paste the values as text.

If you paste that into Display Manager Enhanced editor then the tabs remain. But when you submit the program from display manager then the tabs in the program editor are converted to spaces automatically.

So I suspect you are using SAS/Studio or some other front end tool for submitting your code where that does not happen. If you change your preferences in SAS/Studio to replace the tabs then they are NOT pasted into the program editor.

Re: Fullstops in output data in SAS?

Zynep93 — Thu, 10 Oct 2024 16:11:36 GMT

Yes, I use SAS studio.
Thank you very much again.