About Ankita

Ankita · ‎09-22-2016

Hi, Below is a data set, I need to find the identifier, its count and payout greater than 45 identiferpayoutregion 1 10 1 2 20 2 3 10 1 4 20 3 5 10 1 6 20 2 7 10 3 8 20 3 9 10 2 10 20 4 11 10 4 12 20 2 I want output like: regioncount identifiersum payout 2 4 70 3 3 50 How to group by in data step with aggregate functions using first. and last. Thanks and Regards, Ankita

Ankita · ‎05-09-2016

Hi All, Please help me with the difference between Missover Truncover and pad. Also Is there any method by which we can declare all variables in a file in input statement in one go? Thanks and regards, Ankita Roy

Ankita · ‎05-06-2016

Hi, I need to create an inbuild scheduler to send the SAS reports automatically to the required email ids in the required time. Can anyone please help? Regards, Ankita

Ankita · ‎04-24-2016

Thanks for suggesting me the code. I have written my code accordingly data Import_all; Infile "R:\sas\opt\april_2016_*.txt" EOV=skip; input @; if skip then skip=0; Else do; input Name$ Number Price; End; Run; In the output the header is getting eliminated from 2nd file onwards however there is a blank observation instead. Also for the first file partially header is getting displayed. Can you please please help as where exactly I am going wrong. Also, I have attached the output screen shot below. Obs 1 shows the name which is ideally the variable name. 14 and 27 is blank as they had headers. Regards, Ankita

Ankita · ‎04-23-2016

Thanks for your responses. I have used the option EOV=skip but still find the headers. Is there any advance method to resolve it. Regards, Ankita

Ankita · ‎04-22-2016

Q1. Do all of the files have the same structure? A1. Yes all the files have same structure. Q2. Is there a header row in each file? A2. Yes there is header in each file Q3.Do you have a program that will read one of the files? A3. No I dont have the program. Thanks, Ankita

Ankita · ‎04-22-2016

Hi, I have 1000 txt files with sequencially increasing naming convention in a shared location. i.e. april_1 april_2 april_3 april_4 : : april_1000 I need to be load all of them using SAS Macro to create one large file. Thanks and Regards, Ankita

Online Status	Offline
Date Last Visited	‎05-07-2017 05:53 AM

Group by in sas Data step

What is the difference between Missover Truncover and pad

write a sas code to create a scheduler so that the sas reports can be ...

Re: write a macro to import data from multiple files with sequentially...

Re: write a macro to import data from multiple files with sequentially...

Re: write a macro to import data from multiple files with sequentially...

write a macro to import data from multiple files with sequentially inc...

Group by in sas Data step

What is the difference between Missover Truncover and pad

write a sas code to create a scheduler so that the sas reports can be ...

Re: write a macro to import data from multiple files with sequentially...

Re: write a macro to import data from multiple files with sequentially...

Re: write a macro to import data from multiple files with sequentially...

write a macro to import data from multiple files with sequentially inc...