Please post your problem as a new topic. ... View more

data want; string="4527488//ahdjs}hdu:34ahdgj:60A:283748 8q79979A B B C Dajhed}{-5 jkqedhkkh36929 82939 A D."; string2=prxchange('s/(}{.*)//oi',-1,strip(string)); run; ... View more

Thanks! it worked but how do I remove the y-axis label without removed the gridlines and also remove the legend? Proc sgplot data=work.toplot; where enrlfl='Y'; reg x=enrldt y=count / lineattrs=(pattern=shortdash); series x=enrldt y=count; yaxis grid; XAXIS DISPLAY=(NOLABEL); YAXIS DISPLAY=(NOLABEL); label count='Cumulative count'; run; ... View more

@Santt0sh wrote: Hi Super User, Thank you for the Solution, this was asked at an interview and this was for my learning and can be of great use in my current project or future projects and i missed to associate the count of the ID's to the ID's and i believe the Interviewer also was expecting the same answer. Even though i used the %put _User_ but missed looking at the Logs and the macro variables resolved. Considering some of the quality of "questions" we see that have appeared in interviews I really hope a lot of them are actually looking to see if you can ask for clarification in a concise and relevant manner. ... View more

Or even shorter 🙂 haha test carefully though plz-   data want; set have; by CUSTOMER_KEY; uniq=not first.CUSTOMER_KEY; run; ... View more

Agreeing with @Kurt_Bremser . You can't write macros and expect them to work until you have working code without macros.   So, here is your code when run as   %psql(dsname=sashelp.class,x=%str(sex ='F',Age desc)) &DSNAME is replaced by sashelp.class and &X is replaced by %str(sex='F',age desc), producing this incorrect SQL code   proc sql; select Name ,sex, Age from sashelp.class order by sex='F',Age desc; quit; Can you see why this SQL code doesn't work? So first, you have to write correct SQL code without macros and without macro variables, and fix the problems in the code immediately above. Show us correct SQL code that works, without macros and without macro variables, for this situation. ... View more

Thank you I tried below code and it worked   data want; set have; do i = 1 to count; output; end; run; ... View more

@learningsas101 wrote: Proc freq won't work for what I want.     Two others have already posted solutions that will likely work.  I'll test them out today or tomorrow and let everyone know.   But you haven't described what you are doing. When I see 15 variables with values of 0/1 I do not see any "counting" going on. ... View more

Date (UTC) User Username 2020-08-31:20:46:49 I combined my date and time columns to make the column DATE (UTC) as above and ran the code as follows (they where separate date and time columns) ;   data ral.Sigins_dups_Removed1; set ral.SIGNINS_COMBINED; by username 'Date (UTC)'n; if first.username; run;   It is not giving me the the first sigin by day anymore, any idea what I need to change? ... View more

Sorry for the delay all. I was on vacation and taking a break from all work. I tested the next 2 suggestions and they both work.   Thanks again 🙂 ... View more

Thanks for all your answers which I have found very helpful. The solution is good - on small dataset though as took a while to process, so agree would not be as effective if dataset is very large.  And thanks for the tip about posting in the community in future  ... View more