topic Re: Insert data in SAS Programming

Insert data

Babloo — Thu, 26 Sep 2019 06:54:24 GMT

I'm trying to create a SAS dataset mentioned in table below. However the program which I used is not producing the desired output. Please note that there is a space in the value of the last variable PARAM_DESC. Appreciate your help here.

Program:

Desired Output:

Re: Insert data

KachiM — Tue, 24 Sep 2019 08:14:22 GMT

@Babloo

Missed a "&" for the last variable.

PARAM_DESC  & $

Re: Insert data

Babloo — Tue, 24 Sep 2019 08:20:32 GMT

Why we need a &? Also the values which I entered in the datelines are
correct? Should I put single quotes for the values which have spaces?

Re: Insert data

KachiM — Tue, 24 Sep 2019 08:46:18 GMT

@Babloo

Read SAS Documentation for List Input. From Docs:

The & (ampersand) format modifier enables you to read character values that contains one or more embedded blanks with list input and to specify a character informat. SAS reads until it encounters two consecutive blanks, the defined length of the variable, or the end of the input line, whichever comes first.

The single quotes surrounding the input string is not necessary (if you want).

Re: Insert data

Babloo — Thu, 26 Sep 2019 06:55:30 GMT

Re: Insert data

KachiM — Tue, 24 Sep 2019 09:32:53 GMT

@Babloo

There may be 'TAB' character as separator. Replace it by a single space and try.

Re: Insert data

Babloo — Tue, 24 Sep 2019 09:51:32 GMT

There is already one space between each of the values.

Re: Insert data

KachiM — Tue, 24 Sep 2019 10:02:41 GMT

@Babloo

You have mixed use of 'TAB' and 'Space' as delimiters.

In the first record, you have a 'TAB' character between second and third variables.(PRL*** prl_ifrs17_vlu).

Re: Insert data

Babloo — Wed, 25 Sep 2019 09:25:40 GMT

How to identify that I've the mixed use of 'TAB' and 'Space' as delimiters?