cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
harshpatel
‎09-13-2023
  • 74 Posts
  • 6 Likes Given
  • 1 Solutions
  • 5 Likes Received

SAS Macro parameter

by Quartz | Level 8 in SAS Programming
‎04-08-2022 02:10 AM
‎04-08-2022 02:10 AM
Hi, Below is my requirement Column_A    Column_B ABC             21 ABC             23 XYZ             31 XYZ             33 We are creating a macro variable for ABC value but when someone will pass BAAC value instead of ABC then also it should read value of ABC Can anyone help me on this Thanks Harsh ... View more

SAS VA passing multiple parameters

by Quartz | Level 8 in SAS Visual Analytics
‎04-27-2021 06:00 AM
1 Like
‎04-27-2021 06:00 AM
1 Like
Hi, Please find the below screenshot I have a list check box and a list table I have a requirement to put those values for list check box in a list table but it should come in one line only  e.g. when i choosing 01 and 02 then it should come 01,02 in list table object. Kindly assist me.   Regards, Harsh ... View more

Re: Calculate growth rate by comparing current vs previous year

by Quartz | Level 8 in SAS Programming
‎03-17-2021 12:24 AM
‎03-17-2021 12:24 AM
Thanks, It works for me   Regards, Harsh  ... View more

Re: Calculate growth rate by comparing current vs previous year

by Quartz | Level 8 in SAS Programming
‎03-17-2021 12:02 AM
‎03-17-2021 12:02 AM
Thanks, it works for me   Regards, Harsh ... View more

Re: Calculate growth rate by comparing current vs previous year

by Quartz | Level 8 in SAS Programming
‎03-16-2021 09:45 AM
‎03-16-2021 09:45 AM
Hi Peter, Thanks for your response It may be different item not exact same for each year ... View more

Calculate growth rate by comparing current vs previous year

by Quartz | Level 8 in SAS Programming
‎03-16-2021 02:10 AM
‎03-16-2021 02:10 AM
Hello, I want to calculate growth rate by comparing current vs previous year in SAS coding ((Current year - Previous year)/Previous year) * 100 I have table structure like Year     Item        Sale     2018      Rice        2500      2018      Ghee      2000      2019      Rice        2000       2019      Ghee      1900      2020       Rice       2000      2020        Ghee     1500     Now i want to make a new column named as previous year column adjacent to sale e.g 2018 year the value should be 0 but against 2019 year the value should be of 2018 likewise   So i wanted below structure Year     Item        Sale     PreviousYear 2018      Rice        2500     0 2018      Ghee      2000     0 2019      Rice        2000      2500 2019      Ghee      1900      2000 2020       Rice       2000     2000   2020        Ghee     1500    1900 Kindly help me on this   Regards, Harsh ... View more

Number is getting truncate

by Quartz | Level 8 in SAS Programming
‎12-22-2020 11:20 PM
‎12-22-2020 11:20 PM
Hi Folks, I am trying to run below code data person; input name $ val; datalines; Mary 1236.52999991234 ; But after submitting the code, number is getting truncated after decimal places I am getting only 1236.5299999  Last four digits i.e. 1234 are not coming but i want to print the whole number as it is Is there any way?   Thanks, Harsh ... View more

Re: Keep same label name as column name

by Quartz | Level 8 in SAS Programming
‎12-15-2020 09:10 AM
‎12-15-2020 09:10 AM
Thanks, Will do that ... View more

Re: Keep same label name as column name

by Quartz | Level 8 in SAS Programming
‎12-15-2020 09:09 AM
‎12-15-2020 09:09 AM
Thanks, Great it works for me ... View more

Re: Keep same label name as column name

by Quartz | Level 8 in SAS Programming
‎12-15-2020 09:09 AM
‎12-15-2020 09:09 AM
Thanks, It works for me ... View more

Re: Keep same label name as column name

by Quartz | Level 8 in SAS Programming
‎12-15-2020 08:23 AM
‎12-15-2020 08:23 AM
Thanks, But if i am generating proc report then it is taking label instead of columns so what to do in this case, my code is as below:   proc report data=test; column idd description &names; define idd/'id'; define description/'desc'; &defines; run; ... View more

Keep same label name as column name

by Quartz | Level 8 in SAS Programming
‎12-15-2020 08:15 AM
‎12-15-2020 08:15 AM
Hi All, I have a table properties as below in which i want to keep label name same as column name Please help me on this Thanks, Harsh   ... View more

Re: Change column format

by Quartz | Level 8 in SAS Programming
‎12-14-2020 11:50 PM
‎12-14-2020 11:50 PM
Thanks, Superb, it works for me ... View more

Re: Change column format

by Quartz | Level 8 in SAS Programming
‎12-14-2020 11:39 PM
‎12-14-2020 11:39 PM
Thanks, Great, it works for me ... View more

Re: Change column format

by Quartz | Level 8 in SAS Programming
‎12-14-2020 08:19 AM
‎12-14-2020 08:19 AM
Hi, It is showing below error   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-13-2023 06:24 AM
Likes given to
Likes from
Quick links