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; ... View more

It is possible to skip foreign keys when requesting. There is a table in which you want to write data. This table has a primary and foreign keys. The table entry is made from a temporary table. but an error occurs because there are no foreign keys in the temporary table. How can I solve this problem?   CREATE TABLE "MAIN"."TABLE_FOR_TEST2" ( "ONE" VARCHAR2(20 BYTE), "TWO" VARCHAR2(20 BYTE), CONSTRAINT "PRIMARY" PRIMARY KEY ("TWO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "U" ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "U" ; %macro test; %macro dummy; %mend dummy; data test(keep=ONE TWO); length ONE $20 TWO $20; ONE="wdq"; TWO="dadf"; run; proc sql noprint; create table test2(ONE char(20), TWO char(20), constraint prim primary key(TWO)); insert into test2 select * from test; quit; proc append base MAIN.TABLE_FOR_TEST2 data=test2 nowarn force ; quit; ... View more

Whether it is possible to write down the request for creation of a temporary table with instructions of external and internal key? for example,   % macro test; data(keep one two three); length one $50 two $50 three 8; %mend test;  I need to specify that one is the primary key. Can this be done?   ... View more

Hi! Running the code causes a truncation error. Although the input file has a length less than the maximum. This is a test code, but in fact there will come texts of large dimension. What could be the reason?   %macro test; %let temp=PGVudE5hbT7QntCR0KnQldCh0KLQktCeINChINCe0JPQoNCQ0J3QmNCn0JXQndCd0J7QmSDQntCi0JLQldCi0KHQotCS0JXQndCd0J7QodCi0KzQriAi0KHQotCg0J7QmNCi0JXQm9Cs0J3QkNCvINCa0J7QnNCf0JDQndCY0K8gItCS0JjQlCI8L2VudE5hbT4=; %put temp=&temp; %let decodedata =%qsysfunc(inputc(&temp,$base64x32767)); %put decodedata=&decodedata; %let DOCFILE = &TEST/tesе/2.xml; FILENAME DOCFILE "&DOCFILE" encoding='wcyrillic' LRECL=32767; data _null_; file DOCFILE LRECL=32767 recfm=f; length temp $32767; put "&decodedata"; run; %mend test; %test; ... View more