KSharp, Long time no see or hear. I also have not seen or been in contact with Peter for some years now. If you want, you could always try to reach him via his LinkedIn page, namely:https://www.linkedin.com/in/petereberhardt/?originalSubdomain=ca ... View more

That was helpful! 🙂   Thank you.   - Dr. Abhijeet Safai ... View more

@SuryaKiran ,   Wonderful! Thanks a lot!   Thank you.   - Dr. Abhijeet Safai   ... View more

I see I need to post some updates to this.   By 2022-04-01 I have retired from paid work (I'm well into my sixties now). As you all know, SASGF 2020 went down the COVID drain, so that presentation was shelved for later. As it turned out, I would do it in September 2022 in San Francisco at WUSS. Which also meant we could attend Seahawks (my wife's favorite team) @ 49ers (my team) at Levi's stadium the following Sunday. An absolute blast, I can tell you.   The family band has expanded, now all our daughters play with us. We have keyboards, bass (electric and double), guitars, ukulele, drums, flute, all kinds of percussion in the family, and everybody sings, at least background. And the oldest daughter's husband is our sound engineer. ... View more

Got it, thanks @Tom !  ... View more

Thank you so much! I was copying code into Google Docs and worrying how much time it would take to format the colors. All I had to do was highlight my code, click the Copy Code button in SAS Studio and paste regularly (Ctrl+V or Cmd+V). Hope this helps others with lots to format! ... View more

Hi @SAS_Muggle , Assuming my understanding of your requirement is correct,  methinks your question presents a neat use case for Hash suminc method. Of course, Hash requires significant RAM, nevertheless should be quick.   data Have; input ID $ Type $; datalines; 1 A 1 A 1 B 1 B 1 A 1 A 1 A 1 C 1 C 2 A ; run; data want ; retain _iorc_ 1 ; if _n_=1 then do; dcl hash h (suminc:'_iorc_') ; h.definekey('id','type' ) ; h.definedone( ); end ; set have ; h.ref ( ) ; h.sum (sum : _count) ; if _count > 2 then flag = '*' ; drop _: ; run ; ... View more

Thank you. Your solution worked 🙂 ... View more

@kamal1974 wrote: FYI, I am using Windows not Unix,  Your desktop runs on Windows, but your SAS session runs on UNIX, as can be seen by this path (quote from your initial post): ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp/EXCEL_FILES (no drive letter, forward instead of backward slashes) ... View more

One way to do this is you can try filename statement with windows command to read all xls files in the directory, then save file name and path in sas dataset, to import and export them in the following data step using call execute routine.  The example code would be: filename xlslist pipe 'dir /b /s "C:\myfolder\*.xls" '; data temp; infile xlslist truncover; input filepath $200.; filename= scan(filepath, -1, '\'); proc print;run; data _null_; set temp end=eof; call execute("proc import datafile="||quote(filepath)||' '||"out="||scan(filename,1, '.')||' '||"dbms="||scan(filename, 2, '.')||"replace; run;"); if eof then do; call execute("proc export outfile="||quote(filepath)||' '||"data=work."||scan(filename,1, '.')||' '||"dbms=csv replace; run;"); end; run;  PS: I used proc import, and call execute routine is something I rarely use, so there could be more efficient ways to write this code.  ... View more

Thank you for mentioning ... ... View more

I have accepted the Python/Power BI Data analyst position.   I don't think the 200 hours I have spent on SAS is wasted, at least I was able to demonstrate my ability to learn a the basics of a new language and pass a difficult exam in less than three month during the interview.   Who knows, I might encounter SAS in the future if I happen to work for a government department or company that use SAS again, but at this stage, it looks like Python and Data Science is my future.     ... View more

I found that. data Want; set have; Week_start=intnx('Week.7',date,0,'b'); format Week_start mmddyy10.; run; ... View more

proc sort data=work.sales out=work.unique (keep=Country) nodupkey; by country; run; data _null_; set work.unique; call execute('data ' !! compress(Country) !! '; set work.sales; where Country = "' !! Country !! '"; run;'); run; ... View more

I was searching for 45 mins for the solution to this exact problem and this worked for me. Thank you so much!!! ... View more