About Jagadishkatam

Jagadishkatam · ‎08-05-2018

%macro rrjow(x,branchP); %do x=100 %to 1000 %by 100; PROC SQL; create table tbl_&x. as select * from input_data where branchP=&x. ; QUIT; %end; %mend rrjow; %rrjow;

Jagadishkatam · ‎08-05-2018

why dont we remove the distinct from the below code, it should get you the expected result proc sql; select count(User_ID) into :NObs from have; select distinct User_ID into :customer1-:customer%left(&NObs) from have; select State into :states from have; ; quit;

Jagadishkatam · ‎06-06-2018

data have; input ID Name$ State$; cards; 1 John CA 2 Amy FL 3 Tim MD 4 Seth NM 5 John VA ; proc sort data=have; by name; run; data want; do until(last.name); set have; by name; retain cnt; if first.name then cnt=1; else cnt+1; end; do until(last.name); set have; by name; if cnt>1 then name=cats(name,put(id,best.)); output; end; run;

Jagadishkatam · ‎04-15-2018

data have1; input Date:ddmmyy10. Sedol Price; format date date9.; cards;; 13/03/2000 4010470 118 14/03/2000 4010470 117 15/03/2000 4010470 116 16/03/2000 4010470 115 13/03/2000 4012625 18 14/03/2000 4012625 17 15/03/2000 4012625 16 16/03/2000 4012625 15 13/03/2000 4383934 8 14/03/2000 4383934 7 15/03/2000 4383934 6 16/03/2000 4383934 5 ; ; data have2; input Sedol event_date:ddmmyy10.; format event_date date9.; cards; 4010470 14/03/2000 4010470 04/01/2002 4012625 18/12/2008 4383934 02/02/1996 4383934 10/07/2013 ; proc sql; create table test as select a.*,b.event_date from have1 as a , have2 as b where a.sedol=b.sedol order by a.sedol,b.event_date; quit;

Jagadishkatam · ‎04-15-2018

Hi. First create the bourne shell script file as below. this file should end with .sh then open the unix terminal from the location where this file is located and run with sh command as should below. the files will run one after the other. Hope this is what you were expecting to know. let me know if you need any further information.

Jagadishkatam · ‎04-14-2018

data _null_; length x $22 ; x='2017-10-05T13:00'; value=input(x,e8601dt19.); put value=datetime19.; run;

Jagadishkatam · ‎04-14-2018

Isn't the date 2017-10-05T13:00 in CDISC IS8601 format. This is the format. You want to convert this into a numeric format. Please confirm in which format you want to convert this date. So we could suggest.

Jagadishkatam · ‎04-14-2018

Please try the proc sql with union data have1; input Entrance $ PassNumber PartySize Age; cards; S 43 3 27 S 44 3 24 S 45 3 2 ; data have2; input Entrance $ PassNumber PartySize Age; cards; N 21 5 41 1 N 87 4 33 3 N 65 2 67 1 N 66 2 7 1 ; proc sql; create table want as select *, case when age < 3 then 0 when age < 65 then 35 when age eq . then . else 27 end as amountpaid from (select * from have1 union select * from have2); quit;

Jagadishkatam · ‎03-24-2018

could you please try this code, it is the same I provided earlier not sure if you tried earlier but if you could try it will help you proc sort data=have ; by descending date; run; data want; set have; by descending date ; retain count; if first.date then count+1; run; proc sort data=want; by id date; run;

Jagadishkatam · ‎03-19-2018

Since you have used the macro variables of dates in titles, the best way is to derive the macro variables by proc sql Hope it is what you are expecting. Proc SQL; Select min(Date) as mindate, max(Date) as maxdate into: mindate, :maxdate From Test; Quit;

Jagadishkatam · ‎03-19-2018

please try data have ; input Top Date: mmddyy10. ; format date date9.; cards; 1 02/01/2018 2 02/05/2018 3 03/01/2018 ; proc sort data=have ; by descending date; run; data want; set have; by descending date ; retain count; if first.date then count+1; run;

Jagadishkatam · ‎03-18-2018

Another approach, data test; input adverse $ 1-12 count1; cards; Diarhoea [1] 170 Diarhoea 100 Rash [2] 174 Rash 145 Nausea [3] 123 Nausea 67 Anemia [4] 156 Cardiac 167 Fatigue 174 ; run; data want; set test; by adverse notsorted; adverse1=scan(adverse,1,'[ '); run; data want2; length adverse2 $200; set want; retain adverse2; by adverse1 notsorted; if first.adverse1 then adverse2=adverse; run; data want3(rename=(adverse2=adverse)); set want2; by adverse2 notsorted; if last.adverse2; drop adverse1 adverse; run;

Jagadishkatam · ‎08-26-2017

PLease try data want; set a; by group; retain x; if first.group then x=.; if var ne . then x=var; run;

Jagadishkatam · ‎08-26-2017

I believe there is a correction required in the rename option, no comma is required to rename two or more variables. Please try the updated code data carz; set work.import(rename= (MSRP = MSRP1 Invoice = Invoice1)); MSRP = input(MSRP1, dollar12.); Invoice = input(Invoice1, dollar12.); format Invoice MSRP Dollar12.; drop MSRP1 Invoice1; run;

Jagadishkatam · ‎08-25-2017

Please provide a sample data of the variables you have with values. This will help to get better responses. Without the data it is very difficult to suggest the code.

Re: 2023 Customer Awards: WCG Clinical Endpoint Solutions - Visual Sto...

Re: next date as end date by subject

Re: next date as end date by subject

Re: Fill in missing IDs

Re: Help with charts - clustered bar graph (?)

Re: SGplot x axis ticks without lumping or losing data

Re: Proc transpose help

Re: Remove x axis percent values in proc sgplot

Re: defining before and after dates using changing dates

Re: unending lines in the series plot of proc template

Re: Remove x axis percent values in proc sgplot

Re: How to remove words in a column by another column values

Re: Assign values to a new var by 1st valid value of another var for a...

Re: Unicode for superscript b

Re: remove words from string if the word length is lower than 4

Re: SAS advanced Guide Chapter 1 quiz Q7

Re: Extract VARIABLE NAME and concatenate with other variable names ba...

Re: How to find the week number of a month?

Re: How to find the week number of a month?

Re: Removing quotation marks

Re: Macro

Re: How do I create a macro variable that is based on the values of an...

Re: Concatenate if duplicate

Re: Create table with repeated observations based on event date and co...

Re: Batch run in Unix

Re: Date isue

Re: Date isue

Re: How to combine 02 sets with proc sql

Re: Get count of rows

Re: Use Min and Max dates in the title

Re: Get count of rows

Re: How to select correct records from dataset?

Re: Filling a cell with the value above by group

Re: converting char to numeric variable

Re: drop observations with certain value