cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
HeatherNewton
‎07-16-2024
  • 413 Posts
  • 1 Likes Given
  • 0 Solutions
  • 21 Likes Received

dataset or macro variable

by Quartz | Level 8 in SAS Programming
‎11-14-2022 09:59 PM
‎11-14-2022 09:59 PM
data _NULL_; length out $5000.; set default_mth; retain out; out=Trim(out)||'staging.mthbal_'||default_mth; call symput("list",out); run; data mthbal; set &list; run; what I dont understand is the line 'set &list', I thought &list is a macro variable and not a dataset... why is it used this way?   also in the able, what is 'retain out' doing? there is no output dataset as _null_ is used, does 'retain out' means saving it for later use? ... View more

OUTPUT

by Quartz | Level 8 in SAS Programming
‎11-12-2022 05:08 AM
‎11-12-2022 05:08 AM
  data live_account; merge live_account(in=a) purge(in=b) plan(in=c); if a and ~b; by account_no; ; if card_type in ("PL" "TU") then do; if plan_num=60000 then output; end; else output; run; is output here a dataset name or it just means only if card_type in ("PL "TU") then if plan_num =60000 then output to dataset live_account? otherwise output everything that is not card_type in ("PL "TU") into dataset live_account?   ... View more

Re: Replicate match merge with Oracle SQL

by Quartz | Level 8 in SAS Programming
‎11-04-2022 03:52 AM
‎11-04-2022 03:52 AM
I have no log as I dont have real data to test yet ... View more

Re: Replicate match merge with Oracle SQL

by Quartz | Level 8 in SAS Programming
‎11-04-2022 03:07 AM
‎11-04-2022 03:07 AM
I have now looked into my datasets and realised the below points:   Normally the merge are done on of two datasets with the same 30 variables by 2 to 4 variables on a daily basis. Wdata.pil_master seems accumulative and _pil_master which is a delta file of each day.    Data wdata.pil_master; merge wdata.pil_master _pil_master; by org_code account_no plan_num ref_no; run; so am i right to say the followings: if the entries in _pil_master is not new, it will amend those in wdata.pil_master if the entries in _pil_master is new, it will be added to wdata.pil_master   is my understanding of merge in this case, correct?               ... View more

Proc sort - order of non BY variables

by Quartz | Level 8 in SAS Programming
‎11-01-2022 03:57 AM
‎11-01-2022 03:57 AM
Hi if i have a table with 10 column, and i asked to sort it by col a col b col c. Lets say i have 3 cols where col a col b col c are the same, once the table us sorted by col a col b col c, how are the rest of the columns arranged? What does it based on? ... View more

Re: Replicate match merge with Oracle SQL

by Quartz | Level 8 in SAS Programming
‎10-26-2022 09:43 AM
‎10-26-2022 09:43 AM
I dont mean I want the last one only but for sas match merge if I have eg data A     data B 1 a          1 d 1 b          1 e 1 c   result would be   1 a d 1 b e 1 c e   I mean the one extra on data A would merge to the last one in data B which is 1 e   this is a very strange kind of merge and when is this ever be useful   ... View more

Re: Replicate match merge with Oracle SQL

by Quartz | Level 8 in SAS Programming
‎10-26-2022 07:26 AM
‎10-26-2022 07:26 AM
Sorry guys! I was hoping writing out sas match merge logic is easier than understanding what program is actually doing to the data. Also want to have same output for Comparison with production data. In my project, i have lots and lots of sas programs with match merge which i cant tell why merge is used. Eg in a credit card project, on a daily basis, we merge the card application info dataset (which is accumulated daily) with new daily application data. Eg data application; merge application dataA dataB; by application_ref_no; run; Basically from physical data, they are many to many. What i dont understand is why merge is applicable as only last entry of dataA and dataB would be used for the same application_ref_no.. So i cant tell if using other join could work and if i used full join i will have much bigger output. ... View more

Left join same table twice

by Quartz | Level 8 in SAS Programming
‎10-26-2022 04:38 AM
‎10-26-2022 04:38 AM
Possible to left join same table twice on different variables? What is the significance of this combination? Proc sql; Create table staging.baselii_boo as Select a.*, b.BOOUK as ID_TYPE_BOO, c.BOOUK as BR_ID_TYPE_BOO from staging.baselii_boo a left join staging.boouk_id_type_mapping b on a.AMNA_USER_6_1=b.CMS left join staging.boouk_id_type mapping c on a.BR_nid_type=c.CMS; quit; ... View more

Wrong command

by Quartz | Level 8 in SAS Programming
‎10-26-2022 12:00 AM
‎10-26-2022 12:00 AM
X”mv &G_IFC_STG_PATH./map671.sas7bdat &G_IFC_STG_PATH./map671.sas7bdat”; Is this command valid? Not renaming or moving to another directory... ... View more

sas dataset with index

by Quartz | Level 8 in SAS Programming
‎10-25-2022 02:39 AM
1 Like
‎10-25-2022 02:39 AM
1 Like
Hi if I have created an index for my dataset, does that mean sorting is not required anymore for this dataset prior to merging? As I see this in some programs with index where sort is not added before merge..     ... View more

Replicate match merge with Oracle SQL

by Quartz | Level 8 in SAS Programming
‎10-24-2022 09:09 PM
‎10-24-2022 09:09 PM
Hi am i right to say this, when a sas merge is many to one or one to many, oracle sql full join works. If many to many, then no normal sql can do that. I will have to create own sql command. I am thinking if the best way is use full outer join then set conditions to remove excess observations. Any insights.. my friend suggests oracle merge into might do the trick, any tried? ... View more

Convert data step merge to SQL?

by Quartz | Level 8 in SAS Programming
‎10-22-2022 12:05 PM
‎10-22-2022 12:05 PM
data wdata.application (index=(application_ref_no)); merge wdata.appication pmam_static pmsm_static; by application_ref_no; run; If I have a merge case like this, how can I write it into sql and get exactly the same result? each of these data sets comes with many variables. what if it is one to many case  and what if it is many to many case? is it possible to write a program to interpret if if no joins in sql can produce same result? what do I need to know to start doing it... ... View more

Re: proc merge

by Quartz | Level 8 in SAS Programming
‎10-22-2022 11:06 AM
‎10-22-2022 11:06 AM
data samp_acct_card; merge samp_acct_card(in=a) relation (keep=relationship_no in =b); by relationship_no; if a; if b and samp_ex=" and IND_CENTRAL_LIMIT in ('Y','1') then samp_ex="DEFAULT_CENTRAL_LMT'; run; when I see the line 'if a', I'd like to think this is a left join, but with the next line 'if b....' I dont know what kind of join this is, please assist. thanks.   ... View more

Re: proc merge

by Quartz | Level 8 in SAS Programming
‎10-22-2022 09:56 AM
‎10-22-2022 09:56 AM
do you mean if it is not many to many, can be interpreted by left, right or inner join   if it is many to many then it cannot be replicated by any sql join and specific programming is required? ... View more

Re: Sas7bndx

by Quartz | Level 8 in SAS Programming
‎10-21-2022 01:12 PM
‎10-21-2022 01:12 PM
Because dataset alone already takes over 1 TB. If copy index too the vol is ever higher. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-16-2024 08:12 AM
Likes given to
View All
Likes from
Quick links