About radha009

radha009 · ‎04-30-2018

Awesome. Thanks a lot.

radha009 · ‎04-30-2018

i have 4 datasets jan_Data,feb_data,march_data,April data All tables variable names are same ( ID,name,owner,val_requred (yes/No) jan_data - dataset: A451 oranges peter yes B345 Apples sam No B123 berry john yes Feb_data - dataset: A451 oranges peter No B123 berry john yes C125 grape rob yes Expected result: ID name owner val_req_jan val_req_feb val_req_mar A451 oranges peter yes No B123 berry john yes yes B345 Apples sam No C125 grape rob yes Thank you

radha009 · ‎04-30-2018

oops typo. i still got the same error

radha009 · ‎04-30-2018

Can you please help: i want to create a new column with type for matching Id. I am getting the error as ERROR: Subquery evaluated to more than one row Proc sql; alter table dash.fruits add type char(30) format = $30.; update dash.fruits as A set Type = (select b.type from dash.category as b where A.id-b.id); quit;

radha009 · ‎04-25-2018

my below data table has month and counts. month data displays dynamically it changes every month. To create SG Plot group graph i am transpose the data. To do transpose by month it gives error as sort the month. once i sorted the month is displaying in alphabetic order and my graph x asis names are displaying in same order. I am expecting the month order should be jan,feb and march Month TEST1 TEST2 TEST3 TEST4 TEST5 TEST6 TEST7 TEST8 January 284 238 421 231 287 217 917 281 February 296 306 556 181 358 250 773 189 March 277 245 568 278 329 227 1091 229 data dash.three_Month_Trend2; set dash.three_Month_Trend; run; proc sort data=dash.three_Month_Trend2; by Month; run; proc transpose data=dash.three_Month_Trend2 out=dash.three_Month_Trend2; by month; run; data dash.three_Month_Trend2; set dash.three_Month_Trend2 (rename=(col1=count)); BTO=_LABEL_; drop _NAME_ _LABEL_; run;

radha009 · ‎04-25-2018

How to sort the dataset by month order

radha009 · ‎04-25-2018

resolved by adding xaxis display=(nolabel) discreteorder=data;

radha009 · ‎04-25-2018

The app names are not constant.they are generated on different queries.

radha009 · ‎04-25-2018

i have table as below, How to change the order to display in month order Table: input Affected_CI count; datalines; '54JFY5 Prtfolios ledger - January' 10 '54JFY5 Prtfolios ledger - February' 17 '66ABC5 Fund Data Correction - -March' 7; run; result as below: expecting in order January,February and march x-as order.

radha009 · ‎04-24-2018

SAS 9.4 windows

radha009 · ‎04-24-2018

i have vbar bar graph. the x-axis labels are displaying very long.How can we wrap the text.

radha009 · ‎04-24-2018

Thanks a lot for the solution.it worked perfect. I am trying to display the percentage values in format 6%, i added the format statement in the dataset Mod, but in Sql the format is not displaying format per1-per8 percentn8.

radha009 · ‎04-24-2018

I am looking for exact pie to bar graph as below. .

radha009 · ‎04-23-2018

add the diff and % to the existing table at difference row and % row.

radha009 · ‎04-23-2018

How to create a pie to bar graph using below data. L1 - 23 L2 - 124 L3 33 L4 7 L5 5 test1 5 test2 5

Online Status	Offline
Date Last Visited	‎03-17-2020 03:22 PM

column name with / special char

Launch a url in the browser and click the link

Error on connect to DB2

Re: email body font size and grid changes

email body font size and grid changes

Re: Hyperlink which open pop up with data

Hyperlink which open pop up with data

Re: proc report display date next to the variable name

Re: proc report display date next to the variable name

proc report display date next to the variable name

Re: do looping issue

Re: How to create 3d clustered column chart in sas

Re: How to create 3d clustered column chart in sas

Re: How to update dynamically created variable names

Re: Change the x-axis order in SGPLOT

Re: how to get valiable names from multiple datasets

how to get valiable names from multiple datasets

Re: ERROR: Subquery evaluated to more than one row.

ERROR: Subquery evaluated to more than one row.

Re: How to sort the dataset by month order

How to sort the dataset by month order

Re: Change the x-axis order in SGPLOT

Re: Change the x-axis order in SGPLOT

Change the x-axis order in SGPLOT

Re: How to wrap x-axis text on SGplot

How to wrap x-axis text on SGplot

Re: subtract the values in a dataset

Re: Can we create a pie to bar graph in sas

Re: subtract the values in a dataset

Can we create a pie to bar graph in sas