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: 
USHAKS
‎09-10-2020
  • 13 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

sorting by multiple variable and getting the first observation

by Fluorite | Level 6 in SAS Programming
‎03-09-2020 07:49 PM
‎03-09-2020 07:49 PM
data work.resiSorted; set work.resi; by ID Career descending Term; run;   I am having many columns in work.resi. My data get sorted as I wish. When I want to get the 1st ID/career/Term details of the observation:-  it is not working;     proc sort data= work.resisorted; by ID; if first.id;   ... View more

Re: Proc report compute

by Fluorite | Level 6 in SAS Programming
‎03-04-2020 10:33 PM
‎03-04-2020 10:33 PM
compute ChangeN;   _c4_ = (_c3_ - _c2_);    endcomp;   C3 is 2020 sales c2 is 2019 sales   when it is c3 is 13 and c2 is 15 I get -2    Assume C3 is 2020 sales and it is 0 C2 2019 sales 2 I do not get -2   thanks,           ... View more

Proc report compute

by Fluorite | Level 6 in SAS Programming
‎03-04-2020 06:22 PM
‎03-04-2020 06:22 PM
compute ChangeN;   _c4_ = (_c3_ - _c2_);    endcomp;   when _C3_ is 2 and column _C2_  0 I want to see -2 but I am seeing in _c4_  0  how to solve it. ... View more

Re: Converting date time to character

by Fluorite | Level 6 in SAS Programming
‎03-04-2020 03:03 PM
‎03-04-2020 03:03 PM
Thank you that helped. ... View more

Re: Converting date time to character

by Fluorite | Level 6 in SAS Programming
‎02-27-2020 05:29 PM
‎02-27-2020 05:29 PM
here how it looks date time 16JUL2018:00:00:00      and character field  2018-07-19 ... View more

Re: Converting date time to character

by Fluorite | Level 6 in SAS Programming
‎02-27-2020 05:00 PM
‎02-27-2020 05:00 PM
I need help in calculating the day difference between the following date formats   MyDATE Char 10 $10. $10. MyDATE   APPDATE Num 8 DATETIME20. DATETIME20. APPDATE   ... View more

Re: Converting date time to character

by Fluorite | Level 6 in SAS Programming
‎02-26-2020 04:22 PM
‎02-26-2020 04:22 PM
I have a date two date fields I need help in calculating the day difference between the following date formats   MyDATE Char 10 $10. $10. MyDATE   APPDATE Num 8 DATETIME20. DATETIME20. APPDATE   date time 16JUL2018:00:00:00      and character format as per proc contents procedure 2018-07-19   ... View more

Converting date time to character

by Fluorite | Level 6 in SAS Programming
‎02-26-2020 03:56 PM
‎02-26-2020 03:56 PM
I need help in calculating the day difference between the following date formats   MyDATE Char 10 $10. $10. MyDATE   APPDATE Num 8 DATETIME20. DATETIME20. APPDATE   ... View more

Re: substring

by Fluorite | Level 6 in SAS Programming
‎01-16-2020 04:26 PM
‎01-16-2020 04:26 PM
in the where clause this script worked. AND( substr(ColumnOne,5,2) ='DB' OR ColumnOne like '%DB' ) ... View more

Re: substring

by Fluorite | Level 6 in SAS Programming
‎01-16-2020 02:29 PM
‎01-16-2020 02:29 PM
Thanks for the help CHEMDB MATHDBGS ... View more

substring

by Fluorite | Level 6 in SAS Programming
‎01-16-2020 02:18 PM
‎01-16-2020 02:18 PM
I want to give a filter on columnOne in the where clause I use the following code in SQL and I get what i want but when I write the same code in proc sql there is no errors but my code is not returning any rows? Please help! where year =2019 and right(left(ColumnOne, 6), 2) = 'DB' ... View more

Re: PROC EXPORT DBMS=EXCEL

by Fluorite | Level 6 in SAS Procedures
‎09-25-2018 10:56 AM
‎09-25-2018 10:56 AM
_ I get this error. Please help me to resolve it__ 22 202 ERROR 22-322: Syntax error, expecting one of the following: ;, ANCHOR, AUTHOR, BOX_SIZING, CATEGORY, CLOSE, COMMENTS, CSSSTYLE, DOM, DPI, FILE, GFOOTNOTE, GTITLE, IMAGE_DPI, KEYWORDS, NOGFOOTNOTE, NOGTITLE, OPTIONS, SASDATE, STATUS, STYLE, TEXT, TITLE, WORK. ERROR 202-322: The option or parameter is not recognized and will be ignored. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-10-2020 09:14 PM
Likes given to
Quick links