Has anyone experience loading data from MS SQL 2016 server from SAS 9.4 M2? On the SAS support pages it says that we need to run at least SAS 9.4 M3! But how can we do that easy? I presume that the whole environment should be upgraded then?   Thanks in  advance. ... View more

Hi, I got a large numbers of events which is a sort of interval where I want to count days from a start event point (date)  to an end point(another date). I need the first start1 og end1/end2 in every interval. Do you have any smart suggestion to do that? after the specific observation has been output i will count the days by retain. Thanks in advance.   idx start1 -----> idx start1 idx start1 idx end1-------> idx start1 -----> idx start1 idx start1 idx end1-------> idy start1 -----> idy start1 idy start1 idy end2-------> ... View more

I have one stored proces where Iet the user select boss and unit and then run a proc report. On the proc report I have different links/URL in a data field where Iink to another Stored process. But how do I get the parameters transfered from the first stored process? and to be used in the URL???? I have tried to define it(marked with red) but it takes the text and not the macro value. Help ...   Thanks in advance.     ***some code; proc report data=ud1 ls=132 ps=58 nocenter missing nowd split=" "                                                                                                                                                                                                                                       style(report)=[just=right outputwidth=100% font_face=arial font_size=2 font_style=roman ]                                                                                                                                                                                                                           style(column)=[just=left /*outputwidth=100%*/ font_face=arial font_size=2 font_style=roman BACKGROUND=WHITE]                                                                                                                                                                                                            style(summary)=[font_face=arial font_size=2 font_style=roman ]                                                                                                                                                                                                                                                      style(header)=[foreground=#003366 font_face=arial font_size=2 font_style=roman ];                                                                                                                                                                                                                                   ; COLUMN   unitname boss kpi KPI_beskrivelse resultat KPI_Kommentarer opdat;  define unitname/DISPLAY width=10 spacing=1 left "unitname" style(column)={just=left}; define boss/DISPLAY width=10 spacing=1 left "boss" style(column)={just=left};                                                                                                                                                                          define kpi/DISPLAY width=10 spacing=1 left "KPI" style(column)={just=left}; define KPI_bem/DISPLAY width=20 spacing=1 left "Bem" style(column)={just=left}; define result/DISPLAY width=20 spacing=1 left "result" style(column)={just=left}; define KPI_K/DISPLAY width=10 spacing=1 left "KPI K" style(column)={just=left}; define opdat/COMPUTED  width=300 spacing=1 left "Opdatere" style(column)={just=left}; RBREAK BEFORE / SUMMARIZE SKIP OL UL ; compute opdat/char length=300; if kpi='YYYY' then opdat= '<A HREF="http://infbisas4wp.int.addom.dk/SASStoredProcess/do?_action=form,properties,execute,nobanner,newwindow&_program=%2FData+fra+forretningen%2FData+til+DWH%2FEnhedskontrakter%2FEnhedskontrakter_opdatereSTP2&maal=Kontroludtagning&boss=boss&unit=unit">Opdatere</a>'; if kpi='XXXX' then opdat= '<A HREF="http://infbisas4wp.int.addom.dk/SASStoredProcess/do?_action=form,properties,execute,nobanner,newwindow&_program=%2FData+fra+forretningen%2FData+til+DWH%2FEnhedskontrakter%2FEnhedskontrakter_opdatereSTP2&maal=Officiel statistik&boss=boss&unit=unit">Opdatere</a>'; endcomp; run; ... View more

I am working on a report (use proc report) where I want to link to a Stored Process.I need different link/call for each line. because it is a specific selection in the stored process . Is there a smart way of doing it ???.I use EG testing the link- But right now is my problem that it do not show the link at all (and I had not put any parameters there yet). Next step is how a call a specific parameter in the STP by specifying it in the link. Do you have any examples?   Thanks in advance.     My output so far is this text in the variable opdat:   <a href='http://infbisas4wp.int.addom.dk/SASPortal/viewItem.do?com.sas.portal.ItemId=StoredProcess%2Bomi%3A%2F%2FFoundation%2Freposname%3DFoundation%2FClassifierMap%3Bid%3DA5JEP4Y9.BD001U9L' >Opdatere     Here is some code and I marked my URL in RED: 　 proc report data=test ls=132 ps=58 nocenter missing nowd split=" " style(report)=[just=right outputwidth=100% font_face=arial font_size=2 font_style=roman ] style(column)=[just=left /*outputwidth=100%*/ font_face=arial font_size=2 font_style=roman BACKGROUND=WHITE] style(summary)=[font_face=arial font_size=2 font_style=roman ] style(header)=[foreground=#003366 font_face=arial font_size=2 font_style=roman ]; ; COLUMN kpi KPI_bem result KPI_com opdat;     define kpi/DISPLAY width=10 spacing=1 left "KPI" style(column)={just=left}; define KPI_bem/DISPLAY width=20 spacing=1 left "Besk" style(column)={just=left}; define result/DISPLAY width=20 spacing=1 left "result" style(column)={just=left}; define KPI_com/DISPLAY width=10 spacing=1 left "KPI com" style(column)={just=left}; define opdat/COMPUTED width=200 spacing=1 left "Opdatere" style(column)={just=left}; RBREAK BEFORE / SUMMARIZE SKIP OL UL ; compute opdat/char length=200; if kpi='GGGGGG' then opdat='http://infbisas4wp.int.addom.dk/SASPortal/viewItem.do?com.sas.portal.ItemId=StoredProcess%2Bomi%3A%2F%2FFoundation%2Freposname%3DFoundation%2FClassifierMap%3Bid%3DA5JEP4Y9.BD001U9L' >Opdate</a>"; endcomp; 　 run; ... View more