About kuridisanjeev

kuridisanjeev · ‎02-15-2013

Hi.. For your understanding i modified the code.. data checkListMerge; merge table1(in=a) table2(in=b) table3(in=c); by name; a1=a; b1=b; c1=c; run; suppose If the value of A1 variable is 1 ,it means BY variable value(in your code BY variable is Name) is Exist in Table1,if A1 value is 0 ,which means BY variable value not present in Table1. For Example Name 'e' is present in only Table2. So that is what for 'e' name,b1 value is 1 and A1,C1values are 0('e' not exist in Table1 and Table3).. Hope You understand the logic. Regards. Sanjeev.K Message was edited by: sajeev kuridi

kuridisanjeev · ‎02-15-2013

Hi.. How About.. data checkListMerge; merge table1(in=a) table2(in=b) table3(in=c); by name; ; if a then Table1='X'; if b then Table2='X'; if c then Table3='X'; run; Regards. Sanjeev.K

kuridisanjeev · ‎02-15-2013

Hi.. Try this Proc Report Code. Tested and working perfectly.. Data Test; input ID $5. COUNTRY $20. COUNT ; cards; A01 FINLAND 0 A02 FRANCE 0 A03 GERMANY 11 A04 ITALY 0 A05 UNITED KINGDOM . A06 UNITED STATES 23 ; run; Proc Report data=test out=t; columns ID Country Count; define ID/Display ; Define Country/Display; Rbreak after/summarize Dul Dol; Compute ID; If _BREAK_="_RBREAK_" then ID="Total"; endcomp; run; Thanks &Regards. Sanjeev.K

kuridisanjeev · ‎02-15-2013

Hi.. Your requirement can be easily achievable with Proc report as suggested. As you mentioned in above post ,i can provide the solution "Other then Proc Report".but i am not sure this is the right way to achieve your requirement. Here is the Solution for your requirement.. Data Test; input ID $4. COUNTRY $20. COUNT ; cards; A01 FINLAND 0 A02 FRANCE 0 A03 GERMANY 11 A04 ITALY 0 A05 UNITED KINGDOM 34 A06 UNITED STATES 23 ; run; Data t(Drop=Count1); Format ID $6.; set test end=last ;output; retain Count1 0; Count1=sum(Count1,Count); if last then do; ID="Total"; Count=Count1; COUNTRY=' ';output; end; run; Proc print; run; Thanks & Regards. Sanjeev.K

kuridisanjeev · ‎02-13-2013

Yes, Defiantly supports. I am using SAS 9.2 in win7 now. Regards. Sanjeev.K

kuridisanjeev · ‎02-12-2013

Hi... Value Creates Format, Invalue Creates an informat for reading and converting raw data values. Thanks&Regards. Sanjeev.K

kuridisanjeev · ‎02-04-2013

Hi Namrata. While merging two datasets in data step,you have to sort both dataset with the same BY variables. So You need to sort work.WB1 dataset based on country newyear variables.but in your code you are sorting WB1 dataset based on newyear year. Please check.That might be causing Error. Thanks & Regards. Sanjeev.K

kuridisanjeev · ‎02-01-2013

Hi... MONNAME. formats a DATE, not a month number. Monname format writes date values as name of the month,but your data don't have any date column. If your data comes in the same format as you have mentioned then you can define user defined format and then apply on the month variable. If you don't want to create User defined Format.Here is the Alternative.But i strongly recommend to use user defind format. data test(Drop=Month); format month1 monname3.; input month; month1=mdy(month,1,2013); datalines; 1 2 3 4 5 ; run; Proc print; run; Thanks &Regards. Sanjeev.K

kuridisanjeev · ‎01-24-2013

Hi.. "Why If condition won't work in Procedures"???? As Per my knowledge IF condition works only in Proc Report Procedure that too in Compute block only. Could any one explain me why IF won't works in all other procedures?? Thanks in Advance 🙂 Regards. Sanjeev.K

kuridisanjeev · ‎01-23-2013

Hi.. I don't think there is a option available to increase macro variable length.You may need to work out on your code to divide your macro variable into two parts. Go through bellow link for more info.. Thanks&Regards. Sanjeev.K

kuridisanjeev · ‎01-07-2013

Hello All.. Is it possible to concatenate date variable and numeric variable together in Proc Report??? I am having two variables in my dataset DOB and Age.. I want to show there variables together in date column like 21Jan1988(25) Is there any way??? Thanks &regards.. Sanjeev.K

kuridisanjeev · ‎01-04-2013

Thanks all for quick response ... Rgards.. Sanjeev.K

kuridisanjeev · ‎01-04-2013

Hi Jag.. Actually i am getting data from client.so i ca not use dataline or cards in this situation. Just for demonstration i used cards to create a dataset.. If i apply your solution i am getting bellow error.. data xyz; set test; informat date yymmdd8.; format date Date9.; run; ERROR : Variable date has been defined as both character and numeric Regards.. Sanjeev.K

kuridisanjeev · ‎01-04-2013

Hi.. Happy New year to all SAS People.. I had a question about variable conversion from char to date.. I am having a dataset and DOB is the one of the variable in that dataset. the value in that variable is like 20120131,20120215(YYYYMMDD). Now i want to convert this variable into date format.. i am using bellow logic and it working perfectly.. Data test; input date $20. ; cards; 20120102 20120108 20120110 20120131 ; run; data y; set test; Format date1 date9.; date=strip(substr(date,5,2)||'/'||substr(date,7,2)||'/'||substr(date,1,4)); date1 =input(substr(strip(date),1,10),MMDDYY10.); run; PRoc print; run; .but my strong believe is i am doing bit tricky ,we do this in more simple way by using formats and informats.. Could any body suggest me how to accomplish this task in a simple way??? Thanks in Advance.. Regards.. Sanjeev.K

kuridisanjeev · ‎01-02-2013

Hi.. Your Question was bit interesting but i think you can not do such data calculations in Proc Report, specially your 3rd rule.(Comparing rows). Any way lets wait for official comments from SAS people on your question.me too eagerly waiting for solution from SAS experts.. Thanks&Regards.. Sanjeev.K

Online Status	Offline
Date Last Visited	‎11-10-2023 08:27 AM

Re: assigning the colors to axis lines

assigning the colors to axis lines

Forest plot with Proc Template

Annotating in Proc Sgpannel Output

Re: Select observations that do NOT meet a criteria

Re: Select observations that do NOT meet a criteria

Re: how to group and compare first row with second row

Re: Specifying the width of format/informat.

Re: Base SAS 9.2 sample data set

Re: Next to last selection in datastep

Re: Annotating in Proc Sgpannel Output

Re: Do but not %do

Re: How to achieve Data step output with SQL Joins.

Re: I have 2 data sets one with mean value for each variable(proc mean...

Re: Need help with proc transpose...

adding a row by using DATA step

Re: What is the equivalent Proc SQL code?

Datalines VS Cards.

Re: global macro

Re: MONNAME3.

Re: Use match-merge or proc sql to combine datasets and conditionally ...

Re: Use match-merge or proc sql to combine datasets and conditionally ...

Re: SAS 9.2: Simple Total from a dataset

Re: SAS 9.2: Simple Total from a dataset

Re: Reg:Installation of SAS of windows 7

Re: diff b/n value and invalue in Proc Format

Re: Merging question

Re: MONNAME3.

Why If condition won't work in Procedures???

Re: Error due to Exceeding Length

Concatenating date variable with numeric variable

Re: How to Change Char variable into Date format.

Re: How to Change Char variable into Date format.

How to Change Char variable into Date format.

Re: Best practice for creating "specific" proc report?