About J_J_J

J_J_J · ‎07-17-2023

Thank you, Paige Miller!

J_J_J · ‎07-17-2023

Hi! I'm trying to find the rank for the different count on values by month and year and to have first 3 positions (descending by num) for the each month. I have only one year data. Help me please to this in right way. data have; month=1; code='BB1111111'; year=2023; name='BB'; num=4; output; month=1; code='AA1111111'; year=2023; name='AA'; num=8; output; month=1; code='FF1111111'; year=2023; name='FF'; num=1; output; month=1; code='CC1111111'; year=2023; name='CC'; num=5134; output; month=1; code='DD1111111'; tyear=2023; name='DD'; num=525; output; month=1; code='EE1111111'; year=2023; name='EE'; num=125; output; month=2; code='QQ1111111'; year=2023; name='QQ'; num=4; output; month=2; code='CC1111111'; tyear=2023; name='CC'; num=5321; output; month=2; code='DD1111111'; year=2023; name='DD'; num=256; output; month=2; code='WW1111111'; year=2023;name='WW'; num=151; output; month=3; code='BB1111111'; year=2023; name='AA'; num=12; output; month=3; code='CC1111111'; year=2023; name='CC'; num=2860; output; month=3; code='CC1111111'; year=2023; name='DD'; num=655; output; month=3; code='CC1111111'; year=2023; name='EE'; num=62; output; month=4; code='AA1111111'; year=2023; name='AA'; num=2; output; month=4; code='BB1111111'; year=2023; name='BB'; num=12; output; month=4; code='CC1111111'; year=2023;name='CC'; num=1962; output; month=4; code='CC1111111'; tyear=2023;name='DD'; num=865; output; month=4; code='CC1111111'; year=2023;name='EE'; num=112; output; run; output I need: month year code name num rank 1 2023 CC1111111 CC 5134 1 1 2023 DD1111111 DD 525 2 1 2023 EE1111111 EE 125 3 2 2023 CC1111111 CC 5321 1 2 2023 DD1111111 DD 256 2 2 2023 WW1111111 WW 151 3 etc. ... ... ... ... ...

J_J_J · ‎05-11-2023

Photograph is from Excel and green triangle shows that it's number stored as text. How to export the data, that it will be number in excel.

J_J_J · ‎05-11-2023

Hello I created my format using code: proc format; picture thousand low-high = '000 000 000 009'; run; and export data to excel proc sql; create table work.mydata as select t.data format=thousand. from work.tabel t ;quit; proc print data=mydata noobs: title "My data"; run; and get result stored as text: How to convert it to numeric format in SAS?

J_J_J · ‎04-20-2023

Thank you, yabwon! It works!

J_J_J · ‎04-20-2023

Thank you, Kurt. It's with a syntax error.

J_J_J · ‎04-20-2023

Hi Is there any format in SAS that writes the numeric value with a space as thousands separator? NLNUMIw. writes with a comma (,) 1,000,000 Commax writes with a dot (.) 1.000.000 But I try to find solution for 1 000 000 Any help is appreciated

J_J_J · ‎04-05-2022

Thank you so much, Kurt_Bremser!

J_J_J · ‎04-05-2022

11th position is fixed and I search for specific character, it's always A, but numbers can vary.

J_J_J · ‎04-05-2022

Hi I try to find results that correspond to the rule: The character is on the 11th place and is followed by 7 digits, ex. 1234567891A1234567 Could you help me please?

J_J_J · ‎12-15-2021

Kurt, thank you so much for good solution!

J_J_J · ‎12-15-2021

Hi everyone! I have data like this: data have; ID='A'; year=2020; month=11; rate=50; output; ID='A'; year=2020; month=12; rate=20; output; ID='A'; year=2021; month=1; rate=70; output; ID='A'; year=2021; month=2; rate=50; output; ID='A'; year=2021; month=3; rate=50; output; ID='A'; year=2021; month=4; rate=45; output; ID='A'; year=2021; month=5; rate=40; output; ID='A'; year=2021; month=6; rate=35; output; ID='A'; year=2021; month=7; rate=30; output; ID='A'; year=2021; month=8; rate=25; output; ID='A'; year=2021; month=9; rate=25; output; ID='A'; year=2021; month=10; rate=25; output; ID='A'; year=2021; month=11; rate=20; output; ID='A'; year=2021; month=12; rate=15; output; ID='B'; year=2020; month=11; rate=65; output; ID='B'; year=2020; month=12; rate=35; output; ID='B'; year=2021; month=1; rate=85; output; ID='B'; year=2021; month=2; rate=65; output; ID='B'; year=2021; month=3; rate=65; output; ID='B'; year=2021; month=4; rate=60; output; ID='B'; year=2021; month=5; rate=55; output; ID='B'; year=2021; month=6; rate=50; output; ID='B'; year=2021; month=7; rate=45; output; ID='B'; year=2021; month=8; rate=40; output; ID='B'; year=2021; month=9; rate=40; output; ID='B'; year=2021; month=10; rate=40; output; ID='B'; year=2021; month=11; rate=35; output; ID='B'; year=2021; month=12; rate=30; output; ;run; and I'd like to find result to each row comparing previous month rate with next month rate: id year month rate result A 2020 11 50 A 2020 12 20 green A 2021 1 70 red A 2021 2 50 green A 2021 3 50 yellow A 2021 4 45 green A 2021 5 40 green A 2021 6 35 green A 2021 7 30 green A 2021 8 25 green A 2021 9 25 yellow A 2021 10 25 yellow A 2021 11 20 green A 2021 12 15 green B 2020 11 65 B 2020 12 35 green B 2021 1 85 red B 2021 2 65 green B 2021 3 65 yellow B 2021 4 60 green B 2021 5 55 green B 2021 6 50 green B 2021 7 45 green B 2021 8 40 green B 2021 9 40 yellow B 2021 10 40 yellow B 2021 11 35 green B 2021 12 30 green If next month rate is less than previous one then result is 'green', if gather then 'red' and if it doesn't change then it's 'yellow' Do you have any good ideas, how to do it without creating tables for each pair of months? Have a nice day

J_J_J · ‎12-07-2021

Thank you Sam! I solved this in the other way: ( 'parameter'p NotMissing ) AND ( ( 'character'n Contains UpCase( 'parameter'p) ) AND ( 'character1'n Contains UpCase('parameter1'p) ) ) AND ( 'character2'n Contains UpCase('parameter2'p) )

J_J_J · ‎12-03-2021

Hi! I have 5 characters and create a character parameter and assign it to a text input: ( ( 'parameter'p NotMissing ) AND ( 'character'n Contains UpCase('parameter'p ) ) ) OR ( ( 'parameter1'n NotMissing ) AND ( 'character1'n Contains UpCase( 'parameter1'n) ) ) OR ( ( 'parameter2'n NotMissing ) AND ( 'character1'n Contains UpCase( 'parameter2'n) ) ) OR ( ( 'parameter3'n NotMissing ) AND ( 'character1'n Contains UpCase( 'parameter3'n) ) ) OR ( ( 'parameter4'n NotMissing ) AND ( 'character1'n Contains UpCase( 'parameter4'n) ) ) But in this case one text input controle doesn't affect others text input controles, but would like to link a Text Input control to more than 1 category Example: where colour is 'parameter'p and 'character'n, name is 'parameter1'n and 'character1'n etc. I tied to do, using your advice, but I do something wrong: IF ( GetLength('parameter'p) > 0 ) RETURN ( (IF ('parameter'p NotMissing ) AND ( 'character'n Contains UpCase('parameter'p) ) ELSE ( 0 = 1 ) ) OR (IF ('parameter1'p NotMissing ) AND ( 'character1'n Contains UpCase('parameter1'p) ) ELSE ( 0 = 1 ) ) ELSE ( 1 = 1 ) Could you help me with it please?

J_J_J · ‎11-30-2021

Hi! I have 5 characters and create a character parameter and assign it to a text input: ( ( 'parameter'p NotMissing ) AND ( 'character'n Contains UpCase('parameter'p ) ) ) OR ( ( 'parameter1'n NotMissing ) AND ( 'character1'n Contains UpCase( 'parameter1'n) ) ) OR ( ( 'parameter2'n NotMissing ) AND ( 'character1'n Contains UpCase( 'parameter2'n) ) ) OR ( ( 'parameter3'n NotMissing ) AND ( 'character1'n Contains UpCase( 'parameter3'n) ) ) OR ( ( 'parameter4'n NotMissing ) AND ( 'character1'n Contains UpCase( 'parameter4'n) ) ) But in this case one text input controle doesn't affect others text input controles How to change it that user could add input to the first text input controle and then add the second input to the second text input controle so that it will narrow down the choices. Example:

Online Status	Offline
Date Last Visited	‎07-19-2023 12:37 PM

Re: Rank variables by group

Rank variables by group

Re: Convert my format to numeric

Convert my format to numeric

Re: space as thousands separator

Re: space as thousands separator

space as thousands separator

Re: The character is followed by 7 digits

Re: The character is followed by 7 digits

The character is followed by 7 digits

Re: day, month and year extraction

Re: consecutive numbers in to one column, and the rest characters in t...

Re: How to combine year and month columns into one column

Re: Reordering columns after PROC TRANSPOSE

Re: searching for the next not repetitive date

result comparing to previous month

Re: Rank variables by group

Rank variables by group

Re: Convert my format to numeric

Convert my format to numeric

Re: space as thousands separator

Re: space as thousands separator

space as thousands separator

Re: The character is followed by 7 digits

Re: The character is followed by 7 digits

The character is followed by 7 digits

Re: result comparing to previous month

result comparing to previous month

Re: Text Input linked to multiple categories in SAS VA

Re: Text Input linked to multiple categories in SAS VA

How to use text input for multiple text input controles in SAS VA?