About Aexor

Aexor · ‎02-15-2023

Thank you all for your response. I can not post my log here, due to privacy issue. I can't copy those datasets in my local . Coming to the solution part, As I didn't get any solution, I am trying to replace the complete macro step with a table cretion e.g proc sql; select xyz into : abc separated by ',' from large_data; quit; is replaced with proc sql; create table temp as select distinct xyz from large_data quit; Thanks!

Aexor · ‎02-14-2023

Thanks for your response. The issue is the distinct value , I need to use all in later steps. This distinct table won't be used later. I need to use list of values all together in later steps

Aexor · ‎02-14-2023

Hi @Erik , I have tried this, but issue is I need list of distinct values to be used in later step. I can't use those steps in loopmylist

Aexor · ‎02-13-2023

Thank you. Distinct value is around 6 thousand, and each value is of length 30 char

Aexor · ‎02-13-2023

Thank you! I will give it a try. Also good to know that is problem is known. We can find some solution.

Aexor · ‎02-12-2023

Hi , I need your help and suggestion in one of issue. I am creating a macro variable proc sql; select xyz into : abc separated by ',' from large_data; quit; I want to use all the values coming in abc macro variable in later steps. Due to large number of observation the I am getting error while using this "abc" macro variable . Need your help to understand what else I can do here so I can use all the values present in abc in further steps.

Aexor · ‎02-02-2023

I have a table present in postgress DB, I want to copy/ load same table in CAS. I tried with proc casutil but it didn't work for postgress table. Please help

Aexor · ‎02-02-2023

Hello Members, I need help in understanding , How can we update table same table after join in proc sql proc sql; create table &lbname..&inputTable select p.*, e.time_id as start_dt_sk from &lbname..&inputTable. p , &plan_lib..t_&inputTable._end e where p.%bquote(&time_dim.) between e.start_date and e.end_date; quit; ignore macro variable these are getting resolved perfectly. My doubt is can we create table like these where from table name and create table is same ? do we have replace option here in proc sql ? Also &lbname..&inputTable. table is having larger volume of records around 17M. Please help me with best possible way to resolve this. Thanks!

Aexor · ‎01-08-2023

Hi All, I need help in understanding How to copy data around 200GB effectively. Copying step is causing issue . It hampering compute session and compute session is getting killed. Thanks!

Aexor · ‎01-05-2023

Hi All, Need help in below query. I am trying to create a macro in pass through query proc sql; connect to POSTGRES as ab(user="xxxx" password="abcde" ); select dim_cnt into :dimcnt from connection to ab (select count(dimcnt) as dim_cnt from lib.tab); disconnect from ef; quit; %put &dimcnt; library connection worked but getting syntax error like below. Please help me in resolving this query ERROR 79-322: Expecting a (. 84 disconnect from ef; ---------------------------------------------------- 217 ERROR 217-322: Invalid statement due to first character being unprintable (hexadecimal representation: C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0). 85 quit;

Aexor · ‎09-15-2022

Yes. Done that. Just one more information . I have used this code and this also worked fine data have; input id name $ lastname $ number; infile datalines dlm = '|'; datalines; 1|John| |. 1| |Deo|. 1| | |8888 2|John| |. 2| |Deo|. 2| | |8888 ; run; data want; update have(obs=0) have; by id; /* if last.ID then output; */ run; Could you please tell me significance of last.id in your code.

Aexor · ‎09-15-2022

Thanks a ton!!!!!!!!!!!!

Aexor · ‎09-15-2022

Thanks. This code worked. Just a small request . Could you please explain how this update statement worked

Aexor · ‎09-15-2022

Hi All, Need help in below query. I need to get the total sum by each product id for a particular month in year. input product date sales a 1Jan2012 200 b 4Jan2012 300 c 2Feb2012 200 d 3Mar2012 200 d 5Mar2012 100 output is having detail of all month along with product and total sale in each month. if there is no sales then set value as missing. Output should look like this. product jan feb mar apr may jun jul aug sep oct nov dec a 200 . . . . . . . . . . . b 300 . . . . . . . . . . . c . 200 . . . . . . . . . . d . . 300

Aexor · ‎09-15-2022

let me check 🙂 I will id more ids with different combination and try

Online Status	Offline
Date Last Visited	‎03-11-2024 04:21 AM

Re: Getting duplicate value because of do loop

Re: Getting duplicate value because of do loop

Getting duplicate value because of do loop

Re: do loop is not working as expected

do loop is not working as expected

Re: ERROR: Required operator not found in expression

Re: ERROR: Required operator not found in expression

Re: ERROR: Required operator not found in expression

Re: ERROR: Required operator not found in expression

Re: ERROR: Required operator not found in expression

Re: do loop is not working as expected

Re: ERROR: Required operator not found in expression

Re: ERROR: Required operator not found in expression

Re: How to efficiently delete tables from a library

Re: How to efficiently delete tables from a library

Re: SAS VIYA : proc fed sql error

Split the non-key columns to separate tables with key column in both t...

Re: read a file delimited by string

Re: How to use a table instead of macro variable

Re: How to use a table instead of macro variable

Re: How to use a table instead of macro variable

Re: How to use a table instead of macro variable

Re: How to use a table instead of macro variable

How to use a table instead of macro variable

How to copy/load a table from postgress to Cas

How to update a same table using proc sql

facing issue while copying records in SAS VIYA

proc sql giving error

Re: Need the correct output

Re: Need the correct output

Re: Need the correct output

total sales in each month for a year

Re: Need the correct output