topic Re: Write float name in tab_table in SAS Programming

Write float name in tab_table

Liliya95 — Wed, 15 Jan 2020 07:30:12 GMT

Hello!

Please,help, how can I write a number in the column name when creating the tap_table repository?

I need to create a table where the first column is called payment, and the rest have a name - numbers from 1 to 30.
All fields are of type float.

The code below indicates how the recording occurs.
but there is an error in the line payments.add_column (i_column_char, 'float');
It does not allow you to write a number as a name. How to write it down correctly?

Convert a number to varchar type. Did not help.
The translation was written as dcl varchar i_column_char; i_column_char= put(i_column ,4.0);　

 
method execute(varchar(50) AppId,double RtdmId, varchar(50) NaturalPersonID, double CreID, in_out double incomeBKI_out, in_out package tap_table payments); 　

 

dcl int i_column interval_out;　

dcl varchar i_column_char;　

i_column=1;　　

 

payments.add_column('payment','float');　

do while (i_column <= 30); 　

payments.add_column(i_column_char,'float');　

i_column=i_colimn+1;　

end; 　

　

end;

Re: Write float name in tab_table

Kurt_Bremser — Wed, 15 Jan 2020 07:52:00 GMT

Have the names start with a character or an underline.

Re: Write float name in tab_table

Liliya95 — Wed, 15 Jan 2020 07:54:51 GMT

so, I can't pass a variable to the column name?

Re: Write float name in tab_table

Kurt_Bremser — Wed, 15 Jan 2020 07:55:50 GMT

If the variable contains a valid SAS name, you can.

Re: Write float name in tab_table

Liliya95 — Wed, 15 Jan 2020 08:05:08 GMT

when I write

dcl varchar name;
name='one';
tap_table.add_column(name,'float');

I have error. Why?
name contains character

Re: Write float name in tab_table

Liliya95 — Wed, 15 Jan 2020 08:16:25 GMT

Work!
Thanks!

i_column=1;
_column_char='_payment';

payments.add_column('payment','float');
payments.add_column(_column_char,'float');
payments.add_column('payment'||i_column,'float');

my logs:
payment payment
payment _payment
payment payment1