About PhilC

Reeza · ‎02-12-2021

SAS/OR BOM also offers a solution.

MM88 · ‎02-11-2021

Hi @PhilC , Thanks very much for your suggestions. Regards,

PhilC · ‎02-10-2021

Thanks for the inspiration! This helps me too. But I'm pretty sure, so math works in every case, that we should sort by your marker variable. Incase we have Start and End dates that coincide and are given in HAVE in the wrong order, we do want the accumulator to be added to before being subtracted. proc sort data = have2; by ID Date /**/ descending marker /**/; run;

PhilC · ‎02-08-2021

Now I see. If you care to understand more about this subject in SAS in the future, a good term to remember is SAS "Program data vector" or PDV. Which is what I would have spoken to if I saw what you were dealing with in time. There was a similar question asked about ordering of variables in the last two weeks.

tedway · ‎02-08-2021

That works great. Thank!

Gayle · ‎02-08-2021

Thanks so much for explaining further and I took out the debug

SASKiwi · ‎02-05-2021

Why do you not want to use a task scheduler? If you are running SAS locally on your PC then the Windows Task Scheduler is a good choice. If you are using SAS on a remote server then SAS Management Console provides a point-and-click interface to schedule SAS jobs.

Tom · ‎02-05-2021

So if any cell in a column contains text like `%` then SAS will define the variable as character. So you really just need to process the character variables in your dataset. Regex is overkill for such a simple test. So if your existing dataset is name HAVE this data step will create a copy into a new dataset named WANT that has the character values modified in the way you want. data want; set have; array _ch _character_; do index=1 to dim(_ch); if not index(_ch[index],'%') then _ch[index]=' '; end; drop index; run; If you want to only do it when the % is at the end then change the test to: if not char(_ch[index],length(_ch[index])) = '%' then _ch[index]=' ';

PhilC · ‎02-05-2021

This isn't a join, as far as I understand SQL notation and syntax. This can be achieved in SQL using a UNION but it requires another pass to get the order correct. But SAS can interleave the records; I was taught the term collate, I digress. The datasets A and B I presume are properly sorted. data want; set a b; by id date; run;

utrocketeng · ‎02-05-2021

give this a whirl... proc sql; create table test as select rga.cd_rga,sousc.no_police from (SELECT * FROM PSAEU11.db_dossier where cd_dossier = 'SOUSC' and lp_etat_doss not in ('ANNUL','A30','IMPAY') and no_police = 'I99300001') sousc left join PSAEU11.db_garantie gar on sousc.is_protocole=gar.is_protocole and gar.cd_garantie='DEDIE' left join PSAEU11.db_ctrat_support ctrats on ctrats.is_garantie = gar.is_garantie and ctrats.is_dossier = sousc.is_dossier left join PSAEU11.db_param_mandat_op mandaop on ctrats.is_param_mandat_op = mandaop.is_param_mandat_op left join PSAEU11.db_rga rga on mandaop.is_rga=rga.is_rga ; quit;

PhilC · ‎02-03-2021

good catch.

PhilC · ‎01-29-2021

Proc format; value OneExercise 0 = "More than one exercise" 1 = "One exercise" ; data test; input Name $ run squat jump pushup; array exercise[4] run--pushup; OneExercise=sum(of run--pushup)=1; format OneExercise OneExercise.; cards; Bob 1 0 0 1 Mat 0 1 0 1 Cat 1 0 1 1 Dog 1 0 0 0 Fred 0 1 1 1 Sam 0 0 1 0 Pat 0 0 0 1 Jack 1 1 1 1 Bat 0 0 0 0 ; PROC SORT ; BY OneExercise; RUN; PROC TRANSPOSE DATA=test OUT=Transpose1 PREFIX=Count NAME=Exercise ; BY OneExercise; VAR run squat jump pushup; PROC SORT data=Transpose1 ; BY OneExercise Exercise; PROC TRANSPOSE DATA=Transpose1 OUT=Transpose2 (drop=_NAME_) PREFIX=Count ; BY OneExercise Exercise; VAR Count:; PROC TABULATE DATA=Transpose2 ; VAR Count1; CLASS OneExercise / ORDER=UNFORMATTED MISSING; CLASS Exercise / ORDER=UNFORMATTED MISSING; TABLE /* Row Dimension */ Exercise =" ", /* Column Dimension */ OneExercise=" "* Count1=" "* Sum=" "*f=3.0 ; RUN; More than one exercise One exercise jump 3 1 pushup 5 1 run 3 1 squat 3 0

SASKiwi · ‎01-28-2021

I suggest you check out PROC SCAPROC

PhilC · ‎01-28-2021

Work is a temporary LIBNAME reference. So here is another example of a LIBNAME reference: LIBNAME Desktop "c:\user\amconne1\Desktop"; Data Desktop.CARS; set SAShelp.CARS; run; This code creates a SAS dataset "CARS" on your Windows desktop, assuming your desktop is there, of course. See: Example 1: Assigning and Using a Libref

PhilC · ‎01-28-2021

Navigate to the Project Log, Main menu-bar <> "View" > "Project" > ⋮ > "Project Log". Turn the Project Log on. This is a button the tool bar of the Project Log, Run some code. "Share" it. Go back to the Project Log. "Share" is a button the tool bar of the Project Log,

Online Status	Offline
Date Last Visited	‎04-12-2022 11:06 PM

Re: Creating a categorical variable conditioned on a series of if-then...

Re: Creating a categorical variable conditioned on a series of if-then...

Re: Creating a categorical variable conditioned on a series of if-then...

Re: Add Excel File Name as Variable When Importing Multiple Excel File...

Re: How do I format a field using two different formats in proc report

Re: Allow PROC SORT to output multiple datasets

Re: Allow PROC SORT to output multiple datasets

Re: Looking for Like Values in Array

Re: Find Outliers and Matches in dataset

Re: Need help with code, calculating proportion of days covered by med...

Re: How do I format a field using two different formats in proc report

SAS EG 8 scroll bars

Support WITH clauses in SQL

Re: Support WITH clauses in SQL

EG 8 - Bring back the RUN command on the context menu

Re: After upgrading to 8.2, EG could not "find" local host

Re: Option to save the LOG Summary to a dataset

Re: ODS EXCEL: option for the inserting of line feeds when wrapping li...

Re: XML Mapper exporting multiple tables

Re: Looking for Like Values in Array

Re: Clustering with an Incidence Matrix

Re: Automatically get table names executed in a flow in SAS Enterprise...

Re: Combine overlapping dates while keeping non-continuous intervals s...

Re: Adding columns based on condition

Re: dataset with variable that is a list of strings

Re: Data step question

Re: Schedule a script with program

Re: Any 'cell' in database NOT CONTAINING a %... change to missing

Re: join table by id

Re: proc sql: the where clause

Re: Invalid DO loop control information

Re: How to find the count of specific variable within a dataset

Re: SAS parser to step through a SAS log

Re: Project has references to temporary data.

Re: project log summary