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: 
sasuser123123
‎09-07-2021
  • 127 Posts
  • 29 Likes Given
  • 1 Solutions
  • 1 Likes Received

How to extract numeric values with out any note

by Quartz | Level 8 in SAS Programming
‎02-11-2021 10:16 AM
‎02-11-2021 10:16 AM
I have data Mixed Johnroy 17533 45688 BET32L MINE20 56 12 ALPHA65 So I need to create new variable that contains only numeric values I tried below code.. Data BMW; Set existing; If ~missing(compress(mixed,,"kd")) then Number=input(name,best.); Run; When I ran this code I got note as INVALID Argument to the function INPUT.....How to handle this situation..I put ?? before best. it works but I'm not satisfied with that one because it suppresses that note ..is there any possibilities to do that job... ... View more

Re: How to get numeric values and gives order

by Quartz | Level 8 in SAS Programming
‎02-10-2021 05:58 AM
‎02-10-2021 05:58 AM
Yes it works..but for few observations it's not working I have dataset with 350 observations out of that 330 observations got expected sorting number but for remaining 20 observations the sorting order is not coming expectedly. I don't know why. and 20 observations'S NAME have values like 10456788 10425786 887446 It gives sorting order 1,2,3... etc per ID ... View more

Re: How to get numeric values and gives order

by Quartz | Level 8 in SAS Programming
‎02-10-2021 05:32 AM
‎02-10-2021 05:32 AM
Im unable to understand this code and also not getting any other methods.. could you please help me out ... View more

Re: How to get numeric values and gives order

by Quartz | Level 8 in SAS Programming
‎02-10-2021 04:16 AM
‎02-10-2021 04:16 AM
ID Name  112 Org    112 Mineel 112 Ram 113 23  113 44  113 33  114 10741368 114 10741568  114 8789611 115  0 115  0 116 12  116 4   116 6  so  Im geting wrong sorting order for id 114 and didi not get any number for 115 ... View more

Re: How to get numeric values and gives order

by Quartz | Level 8 in SAS Programming
‎02-10-2021 04:04 AM
‎02-10-2021 04:04 AM
In above comment its not start its ID(sorry for mistake) ... View more

Re: How to get numeric values and gives order

by Quartz | Level 8 in SAS Programming
‎02-10-2021 04:03 AM
‎02-10-2021 04:03 AM
Yeah its working . i applied the same code to another dataset which contains start values like 107413601 107415618 87896111 so the code will give the output to this values is  1 2 3  I dont know why its coming like   and also I have 0 in Id variable the code not giving the sorting order for 0   could you please help me out ... View more

Re: How to get numeric values and gives order

by Quartz | Level 8 in SAS Programming
‎02-10-2021 03:00 AM
‎02-10-2021 03:00 AM
Im not getting desired output, in Id 103 first value is missing it should take it as 1 in new variable but it takes from next value of NAME variable of 103     ... View more

How to get numeric values and gives order

by Quartz | Level 8 in SAS Programming
‎02-10-2021 02:19 AM
‎02-10-2021 02:19 AM
Hi Everyone  i have a dataset having variables ID Name new input like this  ID   Name      New 101  Org 101  Mineel 101  Ram 102  23 102  44 102  33 103    103  40 103  42 104    104  clinic 104  Dale 105  12 105   4 105   6 106 106   Y 106   N 107 108 So I need to get numeric values from Name varible and sort the numerical values and store that sorting order in 'New' varible..and if ID value does not contain any value in Name it should not taken as numeric(ID 107,108)..output should be like     ID   Name      New 101  Org 101  Mineel 101  Ram 102  23            1 102  44            3 102  33            2 103                  1 103  40            2 103  42            3 104    104  clinic 104  Dale 105  12           3 105   4            1 105   6            2 106 106   Y 106   N 107 108 Could anyone please help me for how to do this job..   ... View more

Re: How to give all entry names at atime

by Quartz | Level 8 in SAS Programming
‎02-08-2021 02:34 AM
‎02-08-2021 02:34 AM
#Tom I ran that code so got output Memname row Description AEACN 1 memname=AEACN but my intention is not like that it should be Memname row Description AEACN 1 other action taken ... View more

Re: How to give all entry names at atime

by Quartz | Level 8 in SAS Programming
‎02-08-2021 01:41 AM
‎02-08-2021 01:41 AM
No actually it's not variable label it's variable (description) value present in catalog ... View more

Re: How to give all entry names at atime

by Quartz | Level 8 in SAS Programming
‎02-08-2021 12:13 AM
‎02-08-2021 12:13 AM
#Tom But my expected result is not like that. In description it should have corresponding value of AEACN like DESCRIPTION Other action taken ... View more

Re: How to give all entry names at atime

by Quartz | Level 8 in SAS Programming
‎02-07-2021 09:13 AM
‎02-07-2021 09:13 AM
#KurtBremser Yes that Catalog contains different entries (memname,type,format,name, source) The name have AEACN, AEDECODE,AESTDY,AESEV... When I ran above code it creates variable given in input statement and that variable contains description of AEACN.... ( ex.. Name Description AEACN other action taken ) If I ran program it would be value of description with new variable given in input statement.. Hope you understand my question.. ... View more

Re: How to give all entry names at atime

by Quartz | Level 8 in SAS Programming
‎02-06-2021 10:47 AM
‎02-06-2021 10:47 AM
So can I use dataset name as entryname insteadd of AEACN ... View more

How to give all entry names at atime

by Quartz | Level 8 in SAS Programming
‎02-06-2021 10:25 AM
‎02-06-2021 10:25 AM
Hi everyone. I have catalog contains 5 variables....AEACN,AETERM,AESTDY,AEBODSYS,AESEV and its description So Im trying to create dataset from catalog  should contain values of 5 variables. when I run below program it gives only AEACN value.so my doubt is instead of giving one entry name what command should we use for getting all desciptions of varibles to a new dataset. Can anyone please help me out.   filename mycat catalog "mine.one.AEACN.SOURCE"; data aeacn; infile mycat end=eof length=len; input @1 Description $varying32767. len; run; ... View more

Re: How to retain the values

by Quartz | Level 8 in SAS Programming
‎03-02-2020 09:45 AM
1 Like
‎03-02-2020 09:45 AM
1 Like
Thank you so much for your assistance ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-07-2021 02:03 PM
Likes given to
Likes from
View All
Quick links