About Satora_In

Satora_In · ‎12-13-2023

Hello, When logging into SAS Enterprise Guide, I can access the application itself, but when I try to connect to another server, it asks for the login and password of the account. I enter them, and it shows as in the screenshot. I saw a post about this error, followed the instructions, but it didn't help. Can you assist with this? What could be the issue if the login and password are correct? I see this post https://support.sas.com/kb/57/382.html

Satora_In · ‎12-11-2023

Dear all, I have a problem in my code. I miss understood. %_eg_conditional_dropds(WORK.daily_contacts); PROC SQL; CREATE TABLE WORK.daily_contacts AS SELECT DISTINCT t1.dt FORMAT=ddmmyy10. LENGTH=8 LABEL='' AS dt, t1.USER_ID_HASH LENGTH=40 AS USER_ID_HASH, t1.ADVERT_ID LENGTH=20 AS ADVERT_ID, (1) LENGTH=8 AS cnt_contact, t2.cat LENGTH=40 AS cat, t2.cat_2 LENGTH=50 AS cat_2, t2.cat_3 LENGTH=50 AS cat_3 FROM WORK.MARKET_EVENTS t1 INNER JOIN SANDBOX.SSS_ t2 ON (t1.ADVERT_ID = t2.ID) WHERE t1.USER_ID_HASH NOT IS MISSING AND t1.ADVERT_ID NOT IS MISSING AND t1.dt >= &rep_dt AND t1.dt < &w_end; QUIT; ERROR: Index TEMPINDX cannot be created on file WORK.'SASTMP-000001416'n because the length of the index value (32767 bytes) is too large. The index page size (currently 32767) must be large enough to store three index values plus a small overhead structure. Reduce the length of the index value or use the IBUFSIZE= option to increase the index page size (up to a maximum of 32,767 bytes).

Satora_In · ‎11-27-2023

How I can communicate sas administration

Satora_In · ‎11-24-2023

Good afternoon, I have a question: when I want to update sandboxes via Excel, the following error appears, can anyone help? The data view cannot be displayed. Reason: Exception from HRESULT: 0x800A03EC The reason for this may be that another Excel table is partially overlapping the vertical or horizontal layout of the data that is currently being resized. In this case, the error can be avoided by reorganizing the Excel tables or changing the data increase settings on the Advanced tab of the Properties window for this data view. I don't understand what to do. Best Wishes Satora

Satora_In · ‎11-02-2023

Hey Guies. Good afternoon, If I put a project on the schedule, then manually deleted the stored process and the workflow, do I need to remove the project from the schedule or is it automatically removed when you delete the workflow and stored process?

Satora_In · ‎10-31-2023

Dear friends, I wrote a request only it has a problem that the number of columns is not static but dynamic. Because of this, in my guide they are displayed as a dot and for the catx functions, I have a problem that empty values appear as a dot and a comma (.;.;) in this format. How can I remove empty values to avoid this problem? Thanks for the help. I have attached my request. Perhaps it can be solved through the condition, help. data mytable; set WORK.QUERY_FOR_TRNSTRANSPOSED; length result $4100; result = catx(';',Столбец1,Столбец2,Столбец3,Столбец4,Столбец5,Столбец6,Столбец7,Столбец8,Столбец9,Столбец10,Столбец11,Столбец12,Столбец13,Столбец14,Столбец15, Столбец16,Столбец17,Столбец18,Столбец19,Столбец20,Столбец21,Столбец22,Столбец23,Столбец24,Столбец25,Столбец26,Столбец27,Столбец28,Столбец29,Столбец30,Столбец31,Столбец32, Столбец33,Столбец34,Столбец35,Столбец36,Столбец37,Столбец38,Столбец39,Столбец40); format result $char.; run;

Satora_In · ‎10-23-2023

my code works, I want to improve it

Satora_In · ‎10-18-2023

E PROC SQL; CREATE TABLE WORK. QUERY FOR TRNSTRANSPOSED 0000 AS SELECT DISTINCT t1. TELEPHONE1 AS TELEPHONE1, t1. ZARAZ NUMBER AS ZAKAZ NUMBER, /w gRit W (catx (;' input (put (t1. "Столбец1 'n, BEST11. ), $FREEl1. ) , input (put (t1. "Столбец2'n, BEST11. ), $FREE11. input (put (+1. 'Столбец3'п, BEST11. ),$FREE11. ), input (put (t1. 'Столбец4 'n, BEST11. ), $FREE11. ) , input (put (t1. "Столбец5 'n, BEST11. ), SFREE11. input (put (t1. 'Столбец6'n. BEST11 ),$FREE1Í. ) , input (put (+1. 'Столбец7 'n, BEST11. ),$FREE11. ) , input (put (t1. "Столбец8 'n, BEST11. ) ,$FREE11.) input (put (t1. 'Столбец4'n, BEST11 ) , $FREE11. ) , input (put (t1. 'Столбец4'n, BEST11. ), $FREE11. ), input (put (t1. "Столбец4 'n, BEST11. ), $FREE11 input (put (t1. 'Столбец4 'n, BEST11. ), $FREE11. ) , input (put (t1. 'Столбец9'n, BEST11. ),$FREE11. ), input (put (t1 "Столбец10'n, BEST11. ) , $FREE11.) input (put (t1. 'Столбец11'n, BEST11 ) "SFREE11. ), input (put (t1. "Столбец12 'n, BEST11. ), $FREE11. ) , input (put (t1. 'Столбец13'n, BEST11. ) , SFREE11.) input (put (t1. 'Столбец14'n, BEST11 . ) , $PREE11.) , input (put (t1. "Столбец15'n, BEST11. ) , $FREE11. ) , input (put (+1. "Столбец16'n, BEST11. ),$FREE11 ,input (put (t1. 'Столбец17'n, BEST11 ) , $FREE11. ) , input (put (t1. 'Столбец18'n, BEST11. ), $FREE11. ) ,input (put (t1. 'Столбец19'n, BEST11. ), $FREE11. ). input (put (t1. 'Столбец20 "n, BEST11. ), SFREE11. ), input (put (t1. 'Сполбец21'n, BEST11. ), $FREE11. ) , input (put (t1. 'Столбец22'n, BEST11. ),$FREE11. ). input (put (t1. 'Столбец23'n, BEST11. ), $FREE11. ), input (put (ti. "Столбец24'n, BEST11. ), $FREE11. ) , input (put (t1. 'Столбец25 'n, BEST11. ), $FREE11. input (put (t1. 'Столбец26'n, BEST11. ). ) ,$FREE11. ),input (put (t1. 'Столбец27'n, BEST11. ), $FREE11. ))) LENGTH=280 AS SKU FROM WORK.TRNSTRANSPOSED t1; QUIT; This code is working. I want it to always create a different number of columns

Satora_In · ‎10-18-2023

I asked for a solution

Satora_In · ‎10-18-2023

Dear guys, I upload a different number of columns every day and I want to write a script so that the macro accepts columns regardless of the number. I wrote a request and I can’t do it. help me please %_eg_conditional_dropds(WORK.QUERY_FOR_TRNSTRANSPOSED_0000); %macro dynamic_query(input_table, output_table); %let column_list = TELEPHONE1, ZAKAZ_NUMBER; %do i = 3 %to 100; %let column_list = &column_list, STOLOBC&i; %end; proc sql; create table %output_table as select distinct %column_list, catx(";", %do j = 1 %to 100; %if j ne 1 %then %do; %end; input(put(STOLOBC&j, BEST11.), $FREE11.) %end ) AS SKU FROM &input_table; quit; %mend; %dynamic_query(work.trnstransposed, work.query); PROC SQL; CREATE TABLE WORK.QUERY_FOR_TRNSTRANSPOSED_0000 AS SELECT DISTINCT t1.TELEPHONE1 AS TELEPHONE1, t1.ZAKAZ_NUMBER AS ZAKAZ_NUMBER, /* SKU */ LENGHT 280 AS SKU FROM WORK.TRNSTRANSPOSED t1; QUIT;

Satora_In · ‎10-05-2023

I want to know table size in library.Maybe you know how check table size.

Satora_In · ‎10-05-2023

You misunderstood, I want know size table in the library. How I can use the SQL? Could you write example

Satora_In · ‎10-05-2023

I met this problem but i used sas guide. how to fix this problem. Could you help me?

Satora_In · ‎10-05-2023

how?

Satora_In · ‎10-04-2023

Good afternoon I have a library and there are tables, how can I find out the table size in sas guide or sas console?

Online Status	Offline
Date Last Visited	‎06-02-2024 01:47 PM

Re: I can't open my project how to fix

Re: I can't open my project how to fix

I can't open my project how to fix

Re: Clickhouse

Re: Clickhouse

I have a problem with my project, when I deployed the project it deplo...

Clickhouse query from SAS

Re: I want if my project is not completed before the 14 pm project to ...

I want if my project is not completed before the 14 pm project to be k...

Re: I have error when i want to to open server SASAPP

Re: I have error when i want to to open server SASAPP

I have error when i want to to open server SASAPP

Enterprise Guide - "Previously Failed Login"

ERROR: Index TEMPINDX cannot be created on file WORK.'SASTMP-000001416...

Re: SAS Add-in for Office problem

SAS Add-in for Office problem

f I put a project on the schedule, then manually deleted the stored pr...

how remove empty values

Re: sas programming

Re: sas programming

Re: sas programming

sas programming

Re: Good afternoon I have a library and there are tables, how can I fi...

Re: Good afternoon I have a library and there are tables, how can I fi...

Re: I can't upload file on SAS OnDemand for Academics

Re: I can't upload file on SAS OnDemand for Academics

Good afternoon I have a library and there are tables, how can I find o...