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: 
FredrikE
‎10-22-2025
  • 634 Posts
  • 259 Likes Given
  • 94 Solutions
  • 215 Likes Received

Re: SAS EG 7.1 - repeat a variable found once through following observ...

by Rhodochrosite | Level 12 in SAS Enterprise Guide
‎07-07-2017 07:53 AM
‎07-07-2017 07:53 AM
Something like this in a program entry? : data test; length REF_STAT ACCNT_NUM_tmp REPORT_DATE_tmp REPORT_TIME_tmp ACCNT_NUM REPORT_DATE REPORT_TIME $32; retain REF_STAT ACCNT_NUM REPORT_DATE REPORT_TIME; keep REF_STAT ACCNT_NUM REPORT_DATE REPORT_TIME; input REF_STAT ACCNT_NUM_tmp REPORT_DATE_tmp REPORT_TIME_tmp; if ACCNT_NUM_tmp ne '' then ACCNT_NUM = ACCNT_NUM_tmp; if REPORT_DATE_tmp ne '' then REPORT_DATE = REPORT_DATE_tmp; if REPORT_TIME_tmp ne '' then REPORT_TIME = REPORT_TIME_tmp; if REF_STAT ne '' then output; datalines; . . 05/13/17 08:57:55 . 0000010xxxxxxxx . . ACT . . . ACT . . . ACT . . . ; run; ... View more

Re: PROC FORMAT

by Rhodochrosite | Level 12 in SAS Procedures
‎07-07-2017 07:42 AM
‎07-07-2017 07:42 AM
Try this: data test; length id_var $32; input id_var; id_var = strip(put(input(id_var,32.),32.)); datalines; 0000000010000100 0000000010006377 0000000010042044 0000000010049190 ; run; ... View more

Re: Separate numbers with slash

by Rhodochrosite | Level 12 in SAS Programming
‎07-07-2017 07:37 AM
‎07-07-2017 07:37 AM
Very little information of what you really want to do 🙂 Do you want to read the file into sas and convert the date, do you want to change the file i.e write back the converted date. Why do you want to insert / into the date?   Anyhow, this little step adds / to the new variable outdate by reading the variable indate 🙂 data test; length indate $6 outdate $8; input indate; outdate = cats(substr(indate,1,2),'/',substr(indate,3,2),'/',substr(indate,5,2)); datalines; 160911 151111 ; run; BR Fredrik ... View more

Re: Joining across different datasets to create a shifted dataset

by Rhodochrosite | Level 12 in SAS Programming
‎07-04-2017 06:27 AM
‎07-04-2017 06:27 AM
Something like this?   data person; length refer_id 8 person $32; input refer_id person; datalines; 1 Song_1 1 Song_1 1 Song_1 2 Song_2 2 Song_2 2 Song_2 2 Song_2 2 Song_2 2 Song_2 2 Song_2 ; run;   data role; length refer_id 8 role $32; input refer_id role; datalines; 1 Role_1 1 Role_2 1 Role_3 2 Role_1 2 Role_2 2 Role_3 2 Role_4 2 Role_5 2 Role_6 2 Role_7 ; run; proc sort data=person nodupkey; by refer_id person; run; proc transpose data=role out=role_t(drop=_name_); by refer_id; id role; var role; run; data one; merge person role_t; by refer_id; run; ... View more

Re: SAS VA Bar chart

by Rhodochrosite | Level 12 in SAS Visual Analytics
‎07-04-2017 04:03 AM
‎07-04-2017 04:03 AM
  Strange, do you know which version of VA you are using? I tried it on 7.1 and it worked with ranking... //Fredrik ... View more

Re: Extracting patients based on number of observations

by Rhodochrosite | Level 12 in SAS Data Management
‎06-30-2017 10:33 AM
1 Like
‎06-30-2017 10:33 AM
1 Like
Replace my merge with: Proc sql; Create table new as select a.* from test as a inner join visits as b on a.id = b.id; quit; Then you don not need to have data sorted. ... View more

Re: Extracting patients based on number of observations

by Rhodochrosite | Level 12 in SAS Data Management
‎06-30-2017 10:16 AM
‎06-30-2017 10:16 AM
Something like this?   data test; length id visit $1; input id visit; datalines; a 1 a 2 a 3 a 4 b 1 c 1 c 2 c 3 d 1 ; run; proc sql; create table sel as select id from test group by id having count(visit) > 1 ; quit; data test1; merge test (in=a) sel (in=b); by id; if a and b; run;   //Fredrik ... View more

Re: Change the size of the Input put prompt in a store procedure

by Rhodochrosite | Level 12 in Developers
‎06-30-2017 07:48 AM
‎06-30-2017 07:48 AM
transform them in excel before you c&p them 🙂 Copy the rows in excel and then paste in again into excel and use the transform option of the paste....   BR Fredrik ... View more

Re: SAS VA Filter one object but not another

by Rhodochrosite | Level 12 in SAS Visual Analytics
‎06-30-2017 07:45 AM
‎06-30-2017 07:45 AM
I think(!) this is fixed in 7.4!   One way (hav'nt tested) could be to add another data source with the same information and then link these together, for every link you have to specify linking variables and then maybe you could get rid of these inherited links? 🙂   BR Fredrik ... View more

Re: Error using multiple values in a parameters

by Rhodochrosite | Level 12 in SAS Enterprise Guide
‎06-28-2017 10:36 AM
1 Like
‎06-28-2017 10:36 AM
1 Like
I actually don't know, as you says it's in EG somewhere. If you use prompts in queries, you can se the macro-statements in the code 🙂 BR Fredrik ... View more

Re: Error using multiple values in a parameters

by Rhodochrosite | Level 12 in SAS Enterprise Guide
‎06-28-2017 09:23 AM
‎06-28-2017 09:23 AM
Tom's solution is good, but you can also use EG's own macros: data ...;  set ....;  where %_eg_WhereParam( cod_segmento, segmento, IN, TYPE=S, IS_EXPLICIT=0 ) run;   Read more in this post: https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompt-Manager-question-with-SAS-EG/m-p/361199#M23740 ... View more

Re: SAS VA Bar chart

by Rhodochrosite | Level 12 in SAS Visual Analytics
‎06-28-2017 09:07 AM
‎06-28-2017 09:07 AM
Slect the bar chart and go to the propertietab to the left. On the Properties tab, select the Show overview axis check box. This will add an overview slider below the bar chart and you can scroll between values and even choose how many to show by resiziing the slider 🙂   Hope this helps you BR Fredrik ... View more

Re: SAS VA User Authentication from Database

by Rhodochrosite | Level 12 in SAS Visual Analytics
‎06-22-2017 07:25 AM
‎06-22-2017 07:25 AM
Hi! As SASKiwi says you can import users from external sources, you have to transform data into a sepecific database format (canonical tables), see: https://support.sas.com/rnd/papers/sgf07/sgf2007-syncmetadata.pdf http://support.sas.com/documentation/cdl/en/bisecag/69827/HTML/default/viewer.htm#p1ar98lajfgm4jn1wa1h6e19jjre.htm   In VA you can filter data on groups or identities, this is a good start: https://support.sas.com/resources/papers/proceedings15/SAS1779-2015.pdf   Good luck! ... View more

Re: Is OA or VA best for creating an web-based dashboard?

by Rhodochrosite | Level 12 in SAS Visual Analytics
‎06-22-2017 07:20 AM
‎06-22-2017 07:20 AM
I think it depends a bit upon waht you want to achieve and what kind of user interaction you will have. I the users "only" will view figures and graphs I would choose VA any day but if they will input things to the dashboard as for example target goals and other things that need dynamic changes then maybe OA is better.   I have created dashboards with both. One was made with excel and the add-in for office. The users adds information about their staff and targets and that information is merged with data from sas to get a full view of the business. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-22-2025 07:48 AM
Likes from
Quick links