About Jagadishkatam

Jagadishkatam · ‎08-23-2018

you should use dot instead of comma please try data foo; format y percent7.1; y=-0.01259870; run; proc print data=foo; run;

Jagadishkatam · ‎08-23-2018

proc sql; create table want as select mem length=100,sum(mem in ('F' 'C')) as freq, sum(percent) as percents from have where mem in ('F' 'C') group by mem; insert into want (mem, freq, percents) select 'Grand Total' as mem length=100, count(*) as freq, sum(percent) as percents from have; quit;

Jagadishkatam · ‎08-23-2018

please try the below i applied the filter new=%sysfunc(inputn(&end.,best.)); if input(char_ddate,best.)<new; %let start=1612; /*Must start from end of quarter :Dec March June Sep*/ %let end=1807; %let date_start=%sysfunc(inputn(&start.,yymmn4.)); %let date_end=%sysfunc(inputn(&end.,yymmn4.)); %put &date_start.; %put &date_end.; Data want_month; do j=0 to intck('QUARTER',&date_start.,&date_end.) ; ddate=intnx('QUARTER', &date_start., j, 's'); char_ddate = put(ddate, YYMMn4.); /*Var_Macro_name=compress('m'||put(J,2.));*/ Var_Macro_name='m'||strip(put(J,2.)); call symputx('m'||strip(put(J,2.)), char_ddate); new=%sysfunc(inputn(&end.,best.)); if input(char_ddate,best.)<new; output; end; format ddate date9.; Run; PROC SQL Noprint; select count(*) INTO:n from want_month ; QUIT;

Jagadishkatam · ‎08-22-2018

data want; set Hierarchy; /*ARRAY to group the variables together*/ array lhs(8) L1-L8; array lhsn(8) L1_name L2_name L3_name L4_name L5_name L6_name L7_name L8_name; do i=1 to 8; do j=1 to 8; /*IF logic to determine if the values are the same and if so, set the repeat value to missing*/ if i ne j and lhs(j)=lhs(i) then lhs(j)=' '; if i ne j and lhsn(j)=lhsn(i) then lhsn(j)=' '; end; end; /*this section of the code checks to see if a value is missing and if so, shifts the non-missing values to the left*/ /*if the values are not to be shifted over, then leave this section of the out*/ do k=1 to 8; if lhs[k] = '' then do; do l= k+1 to 8; if lhs[l] ne '' then do; lhs[k] = lhs[l]; lhs[l] = ''; leave; end; end; end; end; do k=1 to 8; if lhsn[k] = '' then do; do l= k+1 to 8; if lhsn[l] ne '' then do; lhsn[k] = lhsn[l]; lhsn[l] = ''; leave; end; end; end; end; drop i j k l; run;

Jagadishkatam · ‎08-22-2018

I agree with @FredrikE please try to use noprint as in the code Proc Report data=Test; Column CombinedCode ('July 2018' ( TotalJuly2018,(pctsum) RankedJuly2018 TotalJuly2018)) ('July 2017' ( TotalJuly2017,(pctsum) RankedJuly2017 TotalJuly2017)) ('2017-18 Financial Year' ( Total201718,(pctsum) Ranked201718 Total201718)) ; Define CombinedCode / DIsplay; Define TotalJuly2018 / DIsplay 'Number of Exits' f=comma9.; Define RankedJuly2018 / DIsplay 'Ranking' order order=Internal; Define TotalJuly2017 / DIsplay f=comma9.; Define RankedJuly2017 / DIsplay; Define TotalJuly201718 / DIsplay f=comma20.; Define RankedJuly2017 / DIsplay; define pctsum /noprint 'Percentage' format=percent7.1; rbreak after / ol summarize; run;

Jagadishkatam · ‎08-21-2018

if you could send the code you have it will help me to see where we could update the code. since you have not used the FITPOLICY, I would suggest you to try using it as shown in the example below, proc sgplot data=example noautolegend noborder; vbar name / response=height dataskin=pressed nostatlabel baselineattrs=(thickness=0) fillattrs=graphdata3 filltype=gradient; xaxis display=(nolabel noline noticks) fitpolicy=SPLITALWAYS SPLITCHAR=" "; yaxis display=(noline); run;

Jagadishkatam · ‎08-21-2018

Could you please send us the code you are using to generate the graph. could you please also check your code to see if you are using the XAXIS option FITPOLICY, it controls how text for tickmarks displays.

Jagadishkatam · ‎08-21-2018

Could you please provide more details on the actual variable name, is nums/time a variable label. I do not think there will be variable name like nums/time. In SAS we cannot have variable name with / or any special character.

Jagadishkatam · ‎08-21-2018

please try the below code which will output only the expected records, i wrote in datastep data temp; input ID TS HR; informat TS datetime20.; format TS datetime20.; datalines; 188 18Jul17:15:27:00 97 188 18Jul17:15:28:00 88 188 18Jul17:15:39:00 85 188 18Jul17:15:55:00 88 188 18Jul17:16:00:00 88 188 18Jul17:16:17:00 87 188 18Jul17:16:22:00 86 188 18Jul17:16:35:00 88 188 18Jul17:16:45:00 88 188 18Jul17:17:01:00 85 188 18Jul17:17:29:00 83 188 18Jul17:17:31:00 84 188 18Jul17:18:10:00 83 188 18Jul17:19:00:00 82 188 18Jul17:21:00:00 81 ; run; proc sort data=temp; by id ts; run; data temp2; set temp; by id ts; retain ts2; if first.id then ts2=ts; hour=(intck('hour',ts2,ts)*60); minutes=intck('minute',ts2,ts); diff=abs(hour-minutes); format TS2 datetime20.; run; proc sort data=temp2; by id hour diff; run; data temp3; set temp2; by id hour diff; if first.hour; run;

Jagadishkatam · ‎08-21-2018

please try data want; set have; by event_id; if results='N' then ord=0; else if results='P' then ord=1; run; proc sort data=want; by event_id ord; run; data want2; set want; by event_id ord; if last.event_id; run;

Jagadishkatam · ‎08-21-2018

Hi Kriss Harris, could you please try the below code, hope it will work. ods pdf file=’~path\final.pdf’; ods pdf(a) file="~path\a.pdf"; ods pdf(a) close; ods pdf(b) file="~path\b.pdf"; ods pdf(b) close; ods pdf close;

Jagadishkatam · ‎08-21-2018

please try the below code the min is the final dataset name which has the flag variable. if you subset min on flag=1 you will get the expected records. hope it helps. data temp; input ID TS HR; informat TS datetime20.; format TS datetime20.; datalines; 188 18Jul17:15:27:00 97 188 18Jul17:15:28:00 88 188 18Jul17:15:39:00 85 188 18Jul17:15:55:00 88 188 18Jul17:16:00:00 88 188 18Jul17:16:17:00 87 188 18Jul17:16:22:00 86 188 18Jul17:16:35:00 88 188 18Jul17:16:45:00 88 188 18Jul17:17:01:00 85 188 18Jul17:17:29:00 83 188 18Jul17:17:31:00 84 188 18Jul17:18:10:00 83 188 18Jul17:19:00:00 82 188 18Jul17:21:00:00 81 ; run; proc sort data=temp; by id ts; run; data temp2; set temp; by id ts; retain ts2; if first.id then ts2=ts; hour=(intck('hour',ts2,ts)*60); minutes=intck('minute',ts2,ts); diff=abs(hour-minutes); format TS2 datetime20.; run; proc sql; create table min as select distinct a.id,a.ts,a.hr,a.hour,a.diff, case when a.diff ne 0 and a.diff=b.min then 1 else 0 end as flag from temp2 as a left join (select id,ts, min(diff) as min from temp2 group by id, hour) as b on a.id=b.id and a.diff=b.min and a.ts=b.ts; quit;

Jagadishkatam · ‎08-21-2018

I like the approach of @Laurie F, Here is an alternate approach %let macvar = %sysfunc(cats(test,+++)); %put &=macvar;

Jagadishkatam · ‎08-21-2018

Though the datastep approach is not asked, I am writing this if it helps proc sort data=have; by id indicate ; run; data want(where=(id=1)); set have; by id indicate; retain sum; if first.id then sum=var; else sum+var; if last.id; run;

Jagadishkatam · ‎08-21-2018

You can also try below sql approach proc sql; create table want as select a.indicate,b.* from have as a left join (select id, sum(var) as sum from have group by id) as b on a.id=b.id having a.indicate=1; quit;

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: Percent format for comma values

Re: grouping some of the members of a variable and adding a grand tota...

Re: series of YYMM in end of quarters between start to end

Re: Deduplication across rows - extension

Re: Removing a column heading from a proc report

Re: How can I give a very long label for one of the xaxistable groups?

Re: How can I give a very long label for one of the xaxistable groups?

Re: drop column contain "/"

Re: How to extract a timestamp with one hour interval

Re: if one of these statements is true-PLEASE HELP ME

Re: Combine PDF files using SAS

Re: How to extract a timestamp with one hour interval

Re: Concatenate a symbol to a text string to create a macro variable

Re: summing a variable longitudinally

Re: summing a variable longitudinally