About JOL

JOL · ‎10-31-2024

Users should attend this course: Course: Transitioning SAS® Enterprise Guide® Projects to SAS® Studio Flows

JOL · ‎10-18-2024

data pizza_likes; input ID $ A $ B $; datalines; 21 Yes No 22 No No 23 Yes Yes 24 No Yes 25 Yes Yes 26 Yes No 27 No Yes ; run; proc freq data=pizza_likes; tables A*B / nocol nopercent norow; run; proc sql; select sum(A='Yes') as Likes_A, sum(B='Yes') as Likes_B, sum(A='Yes' and B='No') as Likes_Only_A, sum(A='No' and B='Yes') as Likes_Only_B, sum(A='Yes' and B='Yes') as Likes_Both, sum(A='No' and B='No') as Likes_Neither, sum(A='Yes' or B='Yes') as Likes_Either from pizza_likes; quit;

JOL · ‎10-18-2024

It sounds like there might be an issue with the degrees of freedom method or the structure of your model. Here are a few things you can check and try: Degrees of Freedom Method: Sometimes, the default method for calculating degrees of freedom can cause issues. You can try specifying a different method, such as ddfm=KR (Kenward-Roger) or ddfm=BW (Between-Within), in your MODEL statement: MODEL TNFalpha = sequence treatment time period / SOLUTION ddfm=KR;

JOL · ‎10-18-2024

Try removing the "=" sign after class CLASS treatment (ref="A") sequence (ref= "AB") period (ref= "P1") time (ref="V1");

JOL · ‎10-11-2024

data test; input group $ id; datalines; A 1 A 1 A 0 A 1 A 1 B 2 B 0 B 2 B 2 C 3 C 0 C 3 C 3 ; run; data new; set test; by group; retain id2; if first.group=1 then id2 = .; if first.group=0 and id=0 then do; id2=0; id=id2; end; if id2=. then id3 = id; else id3=id2; keep group id3; run;

JOL · ‎10-11-2024

Add the following ODS statements: ods trace on; /* Writes the names of the output tables and graphs to the Log */ ods select SurvivalPlot NegLogSurvivalPlot; /* Chooses the specific output you want */

JOL · ‎10-10-2024

data test; input group $ order L1 L2; datalines; A1 1 45 36 A1 2 25 55 A2 1 88 99 A2 2 74 78 A3 1 4 . 25 A3 2 88 99 B4 1 78 65 B4 2 . . ; run; proc transpose data=test out=test_L1 prefix=L1_; by group; var L1; id order; run; proc transpose data=test out=test_L2 prefix=L2_; by group; var L2; id order; run; data test_m; merge test_L1 test_L2; by group; keep group L:; run; proc print data=test_m; run;

JOL · ‎10-07-2024

data WORK.IMPORT2; infile datalines; input ID:best. Claimstartdate:DATE9. Admitdate:DATE9. Dischargedate:DATE9. MSFlag:BEST. Setting:$4.; format ID BEST. Claimstartdate DATE9. Admitdate DATE9. Dischargedate DATE9. MSFlag BEST.; label ID="ID" Claimstartdate="Claimstartdate" Admitdate="Admitdate" Dischargedate="Dischargedate" MSFlag="MSFlag" Setting="Setting"; datalines; 1 26APR2020 26APR2020 28APR2020 1 IP 1 16JUN2020 16JUN2020 28APR2020 1 SNF 2 02JAN2020 02JAN2020 02JAN2020 1 IP 2 04FEB2020 04FEB2020 10FEB2020 1 IP 2 15FEB2020 18JUN2020 15AUG2020 1 IP 3 02JAN2020 02JAN2020 22FEB2020 1 Home 3 15NOV2020 15NOV2020 20DEC2020 1 ER 4 04MAR2020 04MAR2020 14MAY2020 1 ER 5 26AUG2020 26AUG2020 13SEP2020 1 Home 5 15SEP2020 15SEP2020 20NOV2020 1 ER 6 01JAN2020 05JAN2020 08JAN2020 1 IP 6 11JAN2020 12JAN2020 18JAN2020 1 ER 6 05JUN2020 05JUN2020 15JUN2020 1 IP 6 19JUN2020 19JUN2020 05JUL2020 1 SNF 6 15SEP2020 15SEP2020 25SEP2020 1 IP 6 01NOV2020 01NOV2020 05NOV2020 1 Home 7 06MAR2020 06MAR2020 09MAR2020 1 IP 8 02JAN2020 02JAN2020 08JAN2020 1 IP 9 16JUL2020 19JUL2020 20JUL2020 1 SNF 10 01AUG2020 10AUG2020 22AUG2020 1 IP 11 26OCT2020 26OCT2020 30OCT2020 1 IP 12 21FEB2020 21FEB2020 24FEB2020 1 IP 12 27FEB2020 27FEB2020 25JUN2020 1 SNF 13 11JAN2020 11JAN2020 18JAN2020 1 IP 13 20MAR2020 20MAR2020 26MAR2020 1 IP 13 28MAR2020 28MAR2020 10JUN2020 1 IP 13 15JUN2020 15JUN2020 27DEC2020 1 SNF 14 14MAR2020 14MAR2020 18MAR2020 1 IP 15 11SEP2020 12SEP2020 22SEP2020 1 IP 16 10FEB2020 10FEB2020 11FEB2020 1 IP 16 15FEB2020 15FEB2020 04MAY2020 1 HSPC ; run; data test; set import2; by id; /* Creates two hidden variables first.id and last.id that can be used for group processing */ ad2 = lag(admitdate);/* LAG functions calculates the previous value */ dis2= lag(dischargedate); if dischargedate = admitdate then explanation = "Discharged same day"; if first.id = 0 then do; readmit_d = admitdate - ad2; gap = admitdate - dis2; if 0<= readmit_d < 30 then do; readmit_f='Yes'; Readmit_Setting = Setting; end; else readmit_f='No'; end; format ad2 dis2 date9.; run; /* Use PROC FREQ to create report with counts of re-admissions within 30 days */ proc freq data=test; tables id*readmit_f / list nocum nopercent; run;

JOL · ‎10-07-2024

You have an additional column in this file , here's the revised code: data test; infile "c:\temp\Eems_Dollard.csv" dlm=';' dsd missover firstobs=2; input Zoekopdracht : $ 200. Datnum : $15. Url : $100. Sentiment : $10. Type : $10. Discussie_Lengte : 8. Views : 8. Auteur : $25. Volgers : 8. Bron : $15. Title : $200. Bericht : $300. Labels : $10.; run; proc print data=test; run;

JOL · ‎10-03-2024

yes

JOL · ‎10-03-2024

The best way to read this file into SAS is to use the Data Step. data test; infile "c:\temp\test_Eems.csv" dlm=';' dsd missover firstobs=2; input Datnum : $15. Url : $100. Sentiment : $10. Type : $10. Discussie_Lengte : 8. Views : 8. Auteur : $25. Volgers : 8. Bron : $15. Title : $200. Bericht : $300. Labels : $10.; run; proc print data=test; run; The above method uses the Modified List Input method SAS Help Center: INPUT Statement: List

JOL · ‎10-03-2024

You can schedule your SAS code to run daily using the Windows Task Scheduler. Here’s a step-by-step guide to help you set it up: Create a Batch File: Open a text editor (like Notepad) and create a .bat file with the following content: "C:\Program Files\SASHome\SASFoundation\9.4\sas.exe" -sysin "C:\path\to\your\script.sas" -log "C:\path\to\your\log.log" -print "C:\path\to\your\output.lst" Replace the paths with the actual paths to your SAS executable, script, log file, and output file. Schedule the Batch File: Open Task Scheduler from the Start menu. Click on Create Basic Task. Name your task and provide a description. Set the trigger to Daily and specify the time (6 PM in your case). For the action, choose Start a program and browse to your .bat file. Finish the setup and your task will be scheduled to run daily at 6 PM. Learn more: blogs.sas.com2 communities.sas.com

JOL · ‎10-03-2024

data test; input group $ COL1 COL3 COL88 value $; datalines; g1 30 45 36 Y g2 37 25 55 N g2 76 88 99 N g3 22 74 . Y g3 84 . 25 Y g4 15 88 99 N g4 21 78 65 Y g4 94 . . N g4 73 8 78 Y ; run; data test; set test; array new[*] COL:; /* This Array references the original columns */ array CL[3]; /* This Array will create the new columns needed Use a different name from the original You must put a number of array elements*/ do x = 1 to dim(new); CL[x] = new[x]; end; keep group CL: value; run;

JOL · ‎10-03-2024

Here's a Data Step Approach using Group Processing. data table; input ID AMOUNT year; datalines; 8888 50 110 8889 1.10 110 8889 2.99 111 8890 3.48 110 8891 34.08 110 8891 144.87 110 8891 2.24 111 8892 0 110 ; run; /* A prerequisite sort is needed in order to use Group Processing in the Data Step */ proc sort data=table out=table_s; by id year; run; data table_sum; set table_s; by id year; /* This statement creates hidden variables in the PDV that are used to control groups in this case first.id, last.id, first.year, last.year */ if first.id then total=0; Total + amount; if last.id and last.year; drop amount; run;

JOL · ‎06-18-2024

Did you read the notes and change the file path in the cre8data.sas program? You must change the file path associated with the %let statement to the file path where you downloaded the course data to. For example, if you download to c:\temp then you must modify as follows: %let path = c:\temp;

Online Status	Offline
Date Last Visited	‎02-11-2025 06:14 PM

Re: Viya 4 List of nodes on SAS Studio Flows

Re: Best Way to Do a Frequency Table for Patient Responses

Re: PROC MIXED not computing any p-values

Re: Issue with CLASS statement in PROC MIXED

Re: Replace zeros after first zero for each group

Re: PROC LIFETEST only want to have the graph printed but not the lif...

Re: How to transpose data for muti cols and rows

Re: How do I calculate 30 day readmission based on specific conditions

Re: import a crazy csv file

Re: Scheduling a sas code in local machine windows

It's almost time for my live Ask the Expert webinar, "Accessing Databa...

Re: How do I calculate 30 day readmission based on specific conditions

Re: PROC MIXED not computing any p-values

Re: How to transpose data for muti cols and rows

Re: import a crazy csv file

Re: Combining continuous date ranges by ID

Creating PowerPoints With SAS Q&A, Slides, and On-Demand Recording

SAS Studio 3.8 Visual Programming

Re: Viya 4 List of nodes on SAS Studio Flows

Re: Best Way to Do a Frequency Table for Patient Responses

Re: PROC MIXED not computing any p-values

Re: Issue with CLASS statement in PROC MIXED

Re: Replace zeros after first zero for each group

Re: PROC LIFETEST only want to have the graph printed but not the lif...

Re: How to transpose data for muti cols and rows

Re: How do I calculate 30 day readmission based on specific conditions

Re: import a crazy csv file

Re: Scheduling a sas code in local machine windows

Re: import a crazy csv file

Re: Scheduling a sas code in local machine windows

Re: How to rename a group of variables utilize array and looping metho...

Re: sum over multiple records and retain other variables

Re: Zip file (Programming 1) doesnt download properly

SAS Innovate 2025