About MichaelLarsen

MichaelLarsen · ‎07-16-2018

My take on it using PROC SQL data groups; infile cards dlm=' '; length Column1 $30 group 8; input Column1 group; cards; Benefits,verify 1 claims,verify,benefits,verify 2 inquiry,type 3 claims,verify 4 ; run; proc sql noprint; create table test as select a.Column1, a.Group, part.PartOfGroup from groups a left join (select distinct a.Column1, a.group, case when (find(b.Column1,a.Column1,'it')) then b.group else . end as PartofGroup from groups a, groups b having PartofGroup ne a.group and PartofGroup ne . ) part on a.Column1 = part.Column1 ; quit;

MichaelLarsen · ‎07-13-2018

You are not missing anything, It has been a while since I deleted objects via a Project repository so I incorrectly assumed a check-in was neccessary. You are correct it should have disappeared. A couple of things to do: - Check the Metadata Server log , it might reveal the underlying problem. - Before checking out the object, select the Checkouts tab, right click and select Clear. That will clear your project repository in case corrupted data has been created. Now try and check-out your object again and delete it. If the problem persists you may have to do a Analyze/Repair of your metadata repositories. This is done from SAS Management Console. Remember to backup the metadata repositories before doing that. Repeat the Analyze/Repair until no more errors are found. If this does not help, please raise a track with SAS Tech Support.

MichaelLarsen · ‎07-11-2018

did you commit your delete? Regards, Michael

MichaelLarsen · ‎07-11-2018

When you select the URL for your Visual Analytics server, you are not actually reaching the VA Server first. There is a Web Server that gets your request and tries to forward that request to the VA Server. If the VA Server does not respond, this would be the message you would get. You will have to ask the persons responsible for the VA Server and ask why. Regards, Michael

MichaelLarsen · ‎07-11-2018

Try this: proc report data=tbl2 headline split='#' spacing=1 nowd style(report)={cellpadding=1 cellspacing=1} style(header)={font_size=2 font_weight=MEDIUM font_face=david background=cx99ccaa} style(column)={font_size=1}; columns branch branch=branch2 sales; define branch/ display "Branch" center; define branch2/ display "Branch unformatted" format=best. center; define sales/ order order=internal descending "SALES 2018"; Run; Regards, Michael

MichaelLarsen · ‎04-03-2017

You will need a macro to resolve the user selections into a single macro variable. I have created a macro function the will resolve the values for you. You may want to enhance it, using %symexist, to check if the specified macro varable actually exists. %macro GetPromptValues( promptvar /* Name of the macro variable containing the prompt selections */); %let SelectedValues=; %do i=1 %to &&&promptvar._COUNT; %let SelectedValues=&SelectedValues &&&promptvar.&i; %end; &SelectedValues %mend; %let NewClass=%GetPromptValues(Class); %put NewClass=&NewClass;

MichaelLarsen · ‎03-02-2017

The only way I can think of is to use the SPLIT= option and then insert the split character into the column headers. Example: proc report data=sashelp.class nowd split='*'; column name age height; define name / order 'N*a*m*e'; define age / 'A*g*e' format=3.; define height / 'H*e*i*g*h*t' format=8.2 ; quit;

MichaelLarsen · ‎02-16-2017

I don't think it is possible in one pass, you need to count in a sub-select and then create your macro variable string. proc sql noprint; select catx(' ',name, counts) into : names separated by ',' from ( select name, count(*) as counts from sashelp.class group by name ) ; quit; %put &names ; Which would give: %put &names ; Alfred 1,Alice 1,Barbara 1,Carol 1,Henry 1,James 1,Jane 1,Janet 1,Jeffrey 1,John 1,Joyce 1,Judy 1,Louise 1,Mary 1,Philip 1,Robert 1,Ronald 1,Thomas 1,William 1

MichaelLarsen · ‎02-10-2017

No. The By statement will create the automatic variables byvar.first and byvar.last. And will check to see if the sort order is correct in the input rows. The lag function does not know anything about the By statement so you need to add your own logic as I have shown you.

MichaelLarsen · ‎02-10-2017

How about using PROC TRANSPOSE instead? data have; input Company $ Composite_1-Composite_13; format Composite_1-Composite_13 percent5.2; idvar = 'Percent'; cards; A 0.75 0.60 0.75 0.60 0.75 0.60 0.75 0.60 0.75 0.60 0.75 0.60 0.75 B 0.72 0.90 0.72 0.90 0.72 0.90 0.72 0.90 0.72 0.90 0.72 0.90 0.72 C 0.40 0.42 0.40 0.42 0.40 0.42 0.40 0.42 0.40 0.42 0.40 0.42 0.40 ; run; proc transpose data=have out=want name=Composite ; by Company; id idvar; var Composite_1-Composite_13; run;

MichaelLarsen · ‎02-10-2017

Can you try this: proc sort data=work.sample out=work.sample; by clientid case; run; data sample; set sample; by clientid case; callbacktime=intck('day', lag(startdate), startdate); if first.case then callbacktime=.; /* For each new case set callbacktime to missing */ run;

MichaelLarsen · ‎02-07-2017

I am not a unix expert and do not have access to a unix where I am right now, but try this: export eval _call_list=${_call_list}

MichaelLarsen · ‎02-07-2017

How about this: data temporary; INPUT studyid$ Period StartDate : MMDDYY10. GI_C ; format Startdate yymmdd10.; datalines; 097531 1 02/01/2007 0 222482 1 06/02/2012 0 092203 1 05/07/2010 1 090624 1 06/16/2007 0 118646 1 04/28/2007 0 093507 1 03/16/2007 0 080279 1 04/18/2007 0 1045110 1 05/11/2007 0 1633011 1 08/01/2007 0 1633011 2 02/21/2008 0 0607212 1 02/06/2008 1 1932914 1 01/31/2007 0 1932914 2 02/11/2009 0 1932914 3 05/19/2009 0 1932914 4 09/22/2009 0 1932914 5 01/09/2010 0 1932914 6 02/23/2010 0 1932914 7 12/01/2010 0 1932914 8 05/10/2011 0 1932914 9 08/03/2013 0 ; run; proc sql; create table temporary2 as select a.*, count(*) as Periods_no, max(StartDate) as MaxStartDate format=yymmdd10. from temporary a group by studyid order by studyid, StartDate; quit; proc print data=temporary2; run; I have added the highest StartDate within each StudyID, anticipating your next question

MichaelLarsen · ‎01-30-2017

I found this post: Call-Oracle-stored-procedure-using-odbc/td-p/89822 with a similar problem and that was solved by using the Oracle statement CALL instead of EXECUTE. So your example would then be: proc sql; connect to odbc (dsn = dnsname user=xxxxx pwd=xxxxx); create table schema.table_name (compress = yes) as select * from connection to odbc ( call schema_name.view_name ); I am not familiar with the difference between EXECUTE and CALL within Oracle.

MichaelLarsen · ‎01-30-2017

Judging from the name after the word execute, I think you might want to extract from a view. If that is the case change your code to this: proc sql; connect to odbc (dsn = dnsname user=xxxxx pwd=xxxxx); create table schema.table_name (compress = yes) as select * from connection to odbc ( select * from schema_name.view_name );

Online Status	Offline
Date Last Visited	‎12-09-2024 09:14 AM

Re: How to write all variable name followed by value in quotes while w...

Re: MPRINT(ETLS_LOADER): Informat Z was not found or could not be load...

Re: Download file from URL of FTP site to SAS

Re: Download file from URL of FTP site to SAS

Re: Keep leading zeros in stored process

Re: Keep leading zeros in stored process

Re: Keep leading zeros in stored process

Re: Keep leading zeros in stored process

Re: Updating SAS metadata server programatically with new stored proce...

Re: Using conditional start and end when file is populated

SAS Information Catalog: All your information assets under one roof

Re: How to sum values in a column and recode the values?

Re: [macro] Used Lenght in loop

Re: Removing abbreviations in firms names

Re: is there anyway if i can only split datasets into different folder...

Re: Using conditional start and end when file is populated

Re: How to write all variable name followed by value in quotes while w...

Re: Download file from URL of FTP site to SAS

Re: Updating SAS metadata server programatically with new stored proce...

Re: Populating missing months

Re: To find if the group of elements are substring of another string ?

Re: Deleted Object Still Appears Checked-out

Re: Deleted Object Still Appears Checked-out

Re: SAS 9.4 The server is temporarily unable to service your request d...

Re: Proc Report -Want to see a field two times-with format and without

Re: Prompt Manager - multiple texts to single macro variable

Re: Proc report : How can i display column name in 90 degree angle by ...

Re: How to get SQL proc output to a micro variable vector?

Re: Number of days between treatments by clientid and case number

Re: Array for transposing data from wide to long form

Re: Number of days between treatments by clientid and case number

Re: WARNING: The argument to macro function %SYSGET is not defined as ...

Re: How to create a new variable based on the max value of a repeated ...

Re: Calling oracle SP through ODBC

Re: Calling oracle SP through ODBC

SAS Community Nordic