About gsaba

gsaba · ‎08-15-2018

Hello guys, I need your help with a little issue here: I had a big database, then wrote Proc Sort, with some criterias and now have this: id date cam amount 4701 11JAN2018 1 $30.00 4701 09JAN2018 0 $30.00 16044 16JAN2018 1 $40.00 28563 30JAN2018 0 $10.00 this is the proc sort I wrote before: proc sort data=lib.RESULT out=lib.RESULT nodupkey; by id cam; RUN; the question is that now I want to add something in my proc sort to tell sas (if id is duplicated), select those values when date is smaller and 'cam' is 1. these are the priorities. how can I do that? can anobody help?

gsaba · ‎07-30-2018

now i wrote this: %macro appending (startmonth, endmonth); data file1; input(gsaba.products_2018_01, date9.); run; data file2; input(gsaba.products_2018_02, date9.); run; data file3; input(gsaba.products_2018_03, date9.); run; data file4; input(gsaba.products_2018_04, date9.); run; data file5; input(gsaba.products_2018_05, date9.); run; data appendedtables; set %do 'i'=&startmonth %to &endmonth; file&'i' %end; run; %mend; %appending (startmonth = 1, endmonth = 5); but it doesn't work 😞

gsaba · ‎07-30-2018

Hi Guys, I have a small issue about SAS Macro: i have 5 tables: trans2018_01, trans2018_02, trans2018_03, trans2018_04, trans2018_05. i need to append it with some kind of criteria. if i'll write 1,2,3 program has to be able to append first three tables. when 1,2,3,4 - 4 tables. they are titled by months. i have a small construction of code: input -> startyear, startmonth, endyear, endmonth %let startdate, %let enddate nummonths -> (for understanding how many months are in these period) proc sql; append; can anyone tell me how my code should really be?

gsaba · ‎07-26-2018

no, it is not a homework. at work, my boss, said that i should work in SAS. they know that i'm not quite well in this. there is one guy, who gives me daily tasks for exercising in SAS and he told, that i could make this tasks with help of internet. he thinks i will learn it better this way.

gsaba · ‎07-26-2018

Unfortunately, my task is to do all this stuff using Macro. for appending, now i have this: %MACRO gsabatask52 (1, 2, 3, 4, 5); %DO i=&1 %TO &3 ; %If &i.=&1 %Then %Do; Data Append_Data; Set A_&i.; Run; %End; PROC PRINT DATA = APPEND_DT; RUN; %MEND; %TEST(1 = work.products_2018_01, 2 = work.products_2018_02, 3 = work.products_2018_03, 4 = work.products_2018_04, 5 = work.products_2018_05); SAS returns a bunch of Errors, i think that my code is really very dummy. could you tell me what's right to do here? these tables i have on SAS desktop.

gsaba · ‎07-26-2018

Many thanks! It Works! Thank you really very much. now i have one question also if you could help me again: i have 5 tables with names: trans-1, trans-2, trans-3, trans-4, trans-5. in this macro, my task is to write a code, that can understand and append tables if i will mention that i want to append from trans-1 to trans-3. in this case, macro will append these three tables. is it possible?

gsaba · ‎07-26-2018

for some reason, when i Run this code, SAS returns ERROR message: ERROR: Expected %TO not found in %DO statement. My code is like this: %macro gsaba (a, b, c); %if &c = YES %then %do proc import datafile= "C:\Users\gitonishvili\Desktop\&b" dbms=xlsx out= &a replace; run; %mend; %gsaba (a = task5, b = SabadzeTask25.xlsx, c = YES); Before %if statement, code was: %macro gsaba (a, b); proc import datafile= "C:\Users\gitonishvili\Desktop\&b" dbms=xlsx out= &a replace; run; %mend; %gsaba (a = task5, b = SabadzeTask25.xlsx); and it worked.... what can i do?

gsaba · ‎07-26-2018

Thanks, i think that's the answer. But as i understand, i need to mention in bottom what is FILTER, isn't it true? like this: %macro gsaba (a, b, filter) %if &FILTER=YES %then %do; proc import out = &a datafile= "C:desktop\excelfiles\25excelfile.xlsx&b"; dbms=xlsx replace; run; %end; %mend %gsaba (a = datafile, b = 25excelfile.xlsx, FILTER = "YES") as soon as i will have a possibility to check this code, i'll write if this works... many thanks in advance.

gsaba · ‎07-26-2018

Hi, I'm new to SAS, so please don't judge me very harsh. I have one question about SAS Macro. I'm trying to make a macro which will import an Excel File. i have made that. with something like this: (I don't have here that code now, so i will try to remember it now) %macro gsaba (a, b) proc import out = &a datafile= "C:desktop\excelfiles\25excelfile.xlsx&b"; dbms=xlsx replace; run; %mend %gsaba (a = datafile, b = 25excelfile.xlsx) so, this works! but now my question is how to make a filter for release. i want to make something where i can write "YES" and in this case, macro will work and load output, but when entering "NO" macro will not work. how can i do that? can somebody help?

Online Status	Offline
Date Last Visited	‎08-16-2018 10:01 AM

Remove Duplicates with Proc Sort

Re: Macros - Loop

Macros - Loop

Re: Macros

Re: Macros

Re: Macros

Re: Macros

Re: Macros

Macros

Remove Duplicates with Proc Sort

Re: Macros - Loop

Macros - Loop

Re: Macros

Re: Macros

Re: Macros

Re: Macros

Re: Macros

Macros