About SasPro

SasPro · ‎07-29-2014

Hi, I mean Can we do Same SQL Unions operations by using Set statement? Using merge it may copy all variables but we can use Keep or drop statement. As Set statement is a concatenating operator so i am looking to perform Unions by SET statement,

SasPro · ‎07-05-2014

Hi All, I was wondering is there any alternate way to use data step to compare and execute SQL unions techinques. I want to write data step to perform SAS sql unions, like except, interest, union For example: i have two datasets Data one; input x A$; datalines; 1 a 1 a 1 b 2 c 3 v 4 e 6 g Run; Data TWO; input x A$; datalines; 1 x 2 y 3 z 3 v 5 w Run; SQL Except set operator to combine both table vertically. How to get same output in SAS data Step. proc sql ; select * from one except select * from two; Quit; SQL Intersect set operator to combine both table vertically. How to get same output in SAS data Step. proc sql; select * from one intersect select * from two; Quit; Thanks in advance.

SasPro · ‎06-30-2014

Hi Ballardw yes its 60% of Current transaction.

SasPro · ‎06-30-2014

Hi All, ID Date Total Transaction Total Revenue Ref_Point 1200330 2/4/2014 65905 1656.45 65308.5 1200330 2/5/2014 67780 1846.36 65308.5 1200330 2/6/2014 68191 1744.44 65308.5 1200330 2/7/2014 65441 1900.14 65308.5 1200330 2/10/2014 51353 1315.1 65308.5 1200330 2/11/2014 21169 527.51 65308.5 1200330 2/12/2014 28738 759.81 65308.5 1200330 2/13/2014 61536 1831.35 65308.5 1200330 2/14/2014 56801 1283.84 65308.5 1200330 2/17/2014 1832 65.42 65308.5 1200330 2/18/2014 62752 1534.1 65308.5 1200330 2/19/2014 62889 1594.25 65308.5 1200330 2/20/2014 65176 1643.18 65308.5 1200330 2/21/2014 64904 1411.64 65308.5 1200330 2/24/2014 61411 1637.59 65308.5 1200330 2/25/2014 64187 1780.06 65308.5 1200330 2/26/2014 35090 1193.06 65308.5 1200330 2/27/2014 68947 1736.58 65308.5 1200330 2/28/2014 62097 1467.95 65308.5 1200330 3/3/2014 61661 1679.16 65308.5 1. Flag out filter based on below condition: If (“current transaction” >= 60% and of the ref_Point) and (%change in "Current Transaction" w.r.t "Previous Transaction" is >-50%) , keep it. Make this the new ref_point and set the following value the new “current”. 2. Else, delete it and make the following value the new “current”. Below is the code which i tried to execute ..... Looking for your help ASAP. Will be really thankful for u. data output; set Input_dataset; /*ref_point_new=lag(DSQ_SUM);*/ if _n_=1 Then do ;ref_point_new=ref_point;end; if _n_>1 Then DO ; ref_point_new=lag(dsq_sum); outlier=0; end; if dsq_sum >= .6*ref_point_new and ((dsq_sum-lag(dsq_sum))/lag(dsq_sum)) > -.5 then do; outlier=0; end; else do outlier=1; ref_point_new=dsq_sum; end; ref_point_new= lag(dsq_sum); run; proc print data=output; Run;

SasPro · ‎10-21-2013

Thank you Anca telia, Your code is working perfect! I tried to execute with other logic it is also working file proc sort data = have;by var1 descending var2;run; data temp; set have; by var1 ; if first.var1 then output; Run; data want; merge have temp; by var1; run;

SasPro · ‎10-21-2013

Hi, I have 2 variables var1 and var2, Var1 is a grouping variable and var2 is reference variable. Here i want to create new variable called Required which takes values from Var2 from the group(var1) and should copy to new variable (Required). I tried with first. and last. My logic is not working for this data. as u can see then values may lie middle of the group. And in the third group you can see we have 2 values 90696x22 and GWYSGNx1afdMxcVGQb2x19, in this case i want to GWYSGNx1afdMxcVGQb2x19 to new variable. Hint is i want to copy only those values from var2 who's value is ending with "x19". It will be great full for your support. Thanks Var 1 Var 2 Required 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 00033F83EF8F58FB6AF3ACA6FFFFFFFF OmrsjLWkNxioc7M1Oj6$bex19 OmrsjLWkNxioc7M1Oj6$bex19 00033F83EF8F58FB6AF3ACA6FFFFFFFF OmrsjLWkNxioc7M1Oj6$bex19 00033F83EF8F58FB6AF3ACA6FFFFFFFF OmrsjLWkNxioc7M1Oj6$bex19 00033F83EF8F58FB6AF3ACA6FFFFFFFF OmrsjLWkNxioc7M1Oj6$bex19 00033F83EF8F58FB6AF3ACA6FFFFFFFF OmrsjLWkNxioc7M1Oj6$bex19 001EE2E43C3711D1A0193A08FFFFFFFF 90696x22 EU$GWYSGNx1afdMxcVGQb2x19 001EE2E43C3711D1A0193A08FFFFFFFF EU$GWYSGNx1afdMxcVGQb2x19 001EE2E43C3711D1A0193A08FFFFFFFF 90696x22 EU$GWYSGNx1afdMxcVGQb2x19 001EE2E43C3711D1A0193A08FFFFFFFF EU$GWYSGNx1afdMxcVGQb2x19 001EE2E43C3711D1A0193A08FFFFFFFF EU$GWYSGNx1afdMxcVGQb2x19 001EE2E43C3711D1A0193A08FFFFFFFF EU$GWYSGNx1afdMxcVGQb2x19 EU$GWYSGNx1afdMxcVGQb2x19 9FB83E1BFC68D743250F4D9AFFFFFFFF 05qOOZmsNxha0cM1Oj6$bex19 9FB83E1BFC68D743250F4D9AFFFFFFFF 05qOOZmsNxha0cM1Oj6$bex19 9FB83E1BFC68D743250F4D9AFFFFFFFF 05qOOZmsNxha0cM1Oj6$bex19 9FB83E1BFC68D743250F4D9AFFFFFFFF 05qOOZmsNxha0cM1Oj6$bex19 9FB83E1BFC68D743250F4D9AFFFFFFFF 05qOOZmsNxha0cM1Oj6$bex19 A0012E3CA47467275AD0EC12FFFFFFFF 05qOOZmsNxha0cM1Oj6$bex19 05qOOZmsNxha0cM1Oj6$bex19

SasPro · ‎10-21-2013

Hi, I have 2 variables var1 and var2, Var1 is a grouping variable and var2 is reference variable. Here i want to create new variable called Required which takes values from Var2 from the group(var1) and should copy to new variable (Required). I tried with first. and last. My logic is not working for this data. as u can see then values may lie middle of the group. And in the third group you can see we have 2 values 90696x22 and GWYSGNx1afdMxcVGQb2x19, in this case i want to GWYSGNx1afdMxcVGQb2x19 to new variable. Hint is i want to copy only those values from var2 who's value is ending with "x19". It will be great full for your support. Thanks Var1 Var2 Required 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 0000000000000000001800008640326A Hmas$ZYcNhrbd30NniiOc6x19 00033F83EF8F58FB6AF3ACA6FFFFFFFF OmrsjLWkNxioc7M1Oj6$bex19 OmrsjLWkNxioc7M1Oj6$bex19 00033F83EF8F58FB6AF3ACA6FFFFFFFF OmrsjLWkNxioc7M1Oj6$bex19 00033F83EF8F58FB6AF3ACA6FFFFFFFF OmrsjLWkNxioc7M1Oj6$bex19 00033F83EF8F58FB6AF3ACA6FFFFFFFF OmrsjLWkNxioc7M1Oj6$bex19 00033F83EF8F58FB6AF3ACA6FFFFFFFF OmrsjLWkNxioc7M1Oj6$bex19 001EE2E43C3711D1A0193A08FFFFFFFF 90696x22 EU$GWYSGNx1afdMxcVGQb2x19 001EE2E43C3711D1A0193A08FFFFFFFF EU$GWYSGNx1afdMxcVGQb2x19 001EE2E43C3711D1A0193A08FFFFFFFF 90696x22 EU$GWYSGNx1afdMxcVGQb2x19 001EE2E43C3711D1A0193A08FFFFFFFF EU$GWYSGNx1afdMxcVGQb2x19 001EE2E43C3711D1A0193A08FFFFFFFF EU$GWYSGNx1afdMxcVGQb2x19 001EE2E43C3711D1A0193A08FFFFFFFF EU$GWYSGNx1afdMxcVGQb2x19 EU$GWYSGNx1afdMxcVGQb2x19 9FB83E1BFC68D743250F4D9AFFFFFFFF 05qOOZmsNxha0cM1Oj6$bex19 9FB83E1BFC68D743250F4D9AFFFFFFFF 05qOOZmsNxha0cM1Oj6$bex19 9FB83E1BFC68D743250F4D9AFFFFFFFF 05qOOZmsNxha0cM1Oj6$bex19 9FB83E1BFC68D743250F4D9AFFFFFFFF 05qOOZmsNxha0cM1Oj6$bex19 9FB83E1BFC68D743250F4D9AFFFFFFFF 05qOOZmsNxha0cM1Oj6$bex19 A0012E3CA47467275AD0EC12FFFFFFFF 05qOOZmsNxha0cM1Oj6$bex19 05qOOZmsNxha0cM1Oj6$bex19

SasPro · ‎05-06-2013

Hey i got it Thank you %let name = %sysfunc(scan(%sysget(SAS_EXECFILENAME),1,'.'));

SasPro · ‎05-06-2013

Thank u Ksharp i am geting filename.SAS i wan to remove the extension.

SasPro · ‎05-06-2013

Hi Tom, Thanks you Tom for getting back I am executing the code by submit button(F3)

SasPro · ‎05-06-2013

Hi All, I am executing multiple SAS code which are to heavy . I am storing the Logs to an extenal text file. system is creating many log file i am confused which program is having which log file. So , Which i want to do is when i execute a SAS code by name firstprogram.SAS same name is to be taken by Log file fristprogram.log. Thanks in advance. SASPro

SasPro · ‎04-17-2013

data datasetA; set datasetB(firstobs=1 obs=1) datasetA; run; Hey got it thank u

SasPro · ‎04-17-2013

Hi all, I have two datasets, DatasetA ---------------- Name$ age place$ F 24 NJ D 85 NY B 34 AC DatasetB ---------------- Name$ age place$ C 45 BM F 54 NY I want to add the first OBS to from datasetB(C 45 BM) to datasetA the datasetA should the records as DatasetA ---------------- Name$ age place$ C 45 BM F 24 NJ D 85 NY B 34 AC thank you in advance

SasPro · ‎03-26-2013

Ok. thank you for helpful suggestion. will try any and get back to you.

SasPro · ‎03-26-2013

thanks for reply, executed proc option;run; code Group=MEMORY SORTSIZE=268435456 Size parameter for sort SUMSIZE=0 Upper limit for data-dependent memory usage during summarization MAXMEMQUERY=0 Maximum amount of memory returned when inquiring as to available space MEMBLKSZ=16777216 Size of memory blocks allocated to support MEMLIB and MEMCACHE options. MEMMAXSZ=2147483648 Maximum amount of memory allocated to support MEMLIB and MEMCACHE options. LOADMEMSIZE=0 Suggested memory limit for loaded SAS executables MEMSIZE=3941230080 Specifies the limit on the total amount of memory to be used by the SAS System REALMEMSIZE=0 Limit on the total amount of real memory to be used by the SAS System but i cant see the option to increase the RAM memory, Dataset has 850 columns and 100 thousand rows. code is quite big has 1000 line code complex macros,inline veiws and proc sql code are written. i have added index were ever necessary but still code is taking too much time to execute. system as 4GB ram and dual core processor.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:12 AM

Re: SQL Union and data Step

SQL Union and data Step

Re: Data Logic

Data Logic

Re: How to copy cell value to other cell within the group

How to copy cell value to other cell within the group

How to copy cell value to other cell

Re: How to get SAS File name

Re: How to get SAS File name

Re: How to get SAS File name

Re: SQL Union and data Step

SQL Union and data Step

Re: Data Logic

Data Logic

Re: How to copy cell value to other cell within the group

How to copy cell value to other cell within the group

How to copy cell value to other cell

Re: How to get SAS File name

Re: How to get SAS File name

Re: How to get SAS File name

How to get SAS File name

Re: How to add a new record at the top of dataset

How to add a new record at the top of dataset

Re: Allocating RAM memory to SAS system

Re: Allocating RAM memory to SAS system