About sas_user

sas_user · ‎07-16-2025

Thank you. I understood the mistakes i made and corrected them.

sas_user · ‎07-16-2025

Thank you. I understood mistakes i made and corrected them.

sas_user · ‎07-13-2025

Hi, I am new to SAS ODA. I am trying to create a RTF report using ODS and PROC REPORT Procedure. Report is being created however some options are not working from below code. Code: /* Reporting */ ODS listing close; ODS RTF body = "xxx.rtf"; proc report data = tab_all1 headline headskip nowd center split = "^"; column mainord seq label trt1 trt2 trt3 trt99; define mainord / order order = data noprint; define seq / order order = data noprint; define label / width = 5 "Characteristics" ; define trt1 / width = 2 center "Xanomeline Low Dose^(N=XX)^n (%)" ; define trt2 / width = 2 center "Xanomeline High Dose^(N=XX)^n (%)" ; define trt3 / width = 2 center "Placebo^(N=XX)^n (%)" ; define trt99 / width = 2 center "Total Population^(N=XX)^n (%)" ; break after mainord/skip; run; ODS RTF close; ODS listing; Issue 1. Break after statement does not produce break, neither is SAS result window output nor in RTF file. Issue 2. Input dataset has some Label variable values with 2 leading spaces as highlighted in blue, but those spaces are striped in output window and RTF both. Issue 3. I am giving CENTER option for center justification in PROC REPORT statement. But all variables are left aligned. When i explicitly define CENTER justification in each define statement , then it works. I am aware SAS ODA has some limitations, are these issues because of that, or am i making some mistake in syntax? Many thanks in advance.

sas_user · ‎06-10-2025

I followed and it did the job. Thank you for your timely reply Sir.

sas_user · ‎06-04-2025

Hi, I am new to online SAS studio application, To get started with i need to upload some SAS data from my local system to SAS on demand for academics SAS studio web application, But i see it only shows server location - "odaws02-apse1-2" and do not identify with local desktop paths/locations. Kindly help.

sas_user · ‎06-23-2020

Thanks, I tried and it worked. But it seems rowaxis and colaxis statements are not supported by SGSCATTER, how can i assign labels and attributes to axis in this. Thank you in advance.

sas_user · ‎06-23-2020

Hi, I want to create a two-panel graph using proc sgpanel in SAS 9.4. The y-axis should be the same for the two panels, but I want both x-axis to have different values . Can that be done using SGPANEL? Best regards, Shaifali

sas_user · ‎05-26-2020

data dummy; infile datalines delimiter = ',' missover; input subject treatment $ trtnum aval atpt $ atptn mean; datalines; 101,Trt1,1,55.75,0.5 hours,0.5,500.06694121 101,Trt1,1,2655.7,0.5 hours,0.5,500.06694121 101,Trt1,1,4.7635874439,0.5 hours,0.5,500.06694121 101,Trt1,1,67.51,1 hours,1,1393.5436913 101,Trt1,1,3364.56,1 hours,1,1393.5436913 101,Trt1,1,4.9837949933,1 hours,1,1393.5436913 101,Trt1,1,71.7,2 hours,2,1306.3579924 101,Trt1,1,3006.92,2 hours,2,1306.3579924 101,Trt1,1,4.1937517434,2 hours,2,1306.3579924 101,Trt1,1,96.42,4 hours,4,1157.3195013 101,Trt1,1,3088.92,4 hours,4,1157.3195013 101,Trt1,1,3.2036092097,4 hours,4,1157.3195013 101,Trt1,1,59.24,6 hours,6,1102.2535578 101,Trt1,1,2339.75,6 hours,6,1102.2535578 101,Trt1,1,3.9496117488,6 hours,6,1102.2535578 102,Trt1,1,45.75,0.5 hours,0.5,456.06694121 102,Trt1,1,4567.7,0.5 hours,0.5,456.06694121 102,Trt1,1,8.7635874439,0.5 hours,0.5,456.06694121 102,Trt1,1,23.51,1 hours,1,1567.5436913 102,Trt1,1,1234.56,1 hours,1,1567.5436913 102,Trt1,1,4.9837949933,1 hours,1,1567.5436913 102,Trt1,1,45.7,2 hours,2,1000.3579924 102,Trt1,1,3456.92,2 hours,2,1000.3579924 102,Trt1,1,8.1937517434,2 hours,2,1000.3579924 102,Trt1,1,34.42,4 hours,4,1157.3195013 102,Trt1,1,8907.92,4 hours,4,1157.3195013 102,Trt1,1,56.2036092097,4 hours,4,1157.3195013 102,Trt1,1,12.24,6 hours,6,1201.2535578 102,Trt1,1,123.75,6 hours,6,1201.2535578 102,Trt1,1,1.9496117488,6 hours,6,1201.2535578 ; run; Hope it helps.

sas_user · ‎05-26-2020

I am using Proc SGPLOT to develop a Graph that represents Overlay of Individual and Mean Plasma Concentrations. X axis has ATPT variable for time point. On Y axis i have AVAL variable to present Individual Concentrations and a MEAN variable containing mean of all concentrations. Requirement is to plot both Individual and Mean Plasma Concentrations on single graph. There are 3 treatments, so i am expecting 3 pages for 3 treatments with each page presenting Overlay of Individual and Mean Plasma Concentrations. I am using 2 series statement each for AVAL and Mean. The problem lies with sorting i think, for Individual Concentrations (AVAL) sorting needs to be done first by subjid and then ATPT to get spaghetti plot, but this sorting doesn't work with Mean plot as it needs to be sorted via time point first . Please see attached file to see Mock and actual Graph. i am using below code : proc sort data = pc2; by trtan trta subjid atptn atpt; run; proc sgplot data = pc2 dattrmap = anno pad = (bottom = 20%) NOAUTOLEGEND ; by trtan trta; series x = atptn y = aval/ group = trta lineattrs = (color = black thickness = 1 pattern = solid ); series x = atptn y = mean/ group = trta attrid = trtcolor lineattrs = (thickness = 2 pattern = solid ); xaxis label= "Actual Time (h)" labelattrs = (size = 10) values = (0 12 24 36 48 72 96 120 168) valueattrs = (size = 10) grid; yaxis label= "Plasma Concentration (ng/mL)" labelattrs = (size = 10) valueattrs = (size = 10) grid; run;

sas_user · ‎04-17-2018

I tried using like this: %if &i eq 1 %then ddjoin(&i.) = %scan(&col.,&i.,'('); %if &i ne 1 %then ddjoin(&i.) = %scan(%scan(&col.,&i.,'('), 1, ')'); This is the log: NOTE: Line generated by the invoked macro "VLIST". 7 ddjoin(&i.) = %scan(%scan(&col.,&i.,'('), 1, ')') ------ 22 SYMBOLGEN: Macro variable COL resolves to aphase(aperstdy) SYMBOLGEN: Macro variable I resolves to 2 ERROR: Macro function %SCAN has too few arguments. NOTE: Line generated by the invoked macro "VLIST". 7 ddjoin(&i.) = %scan(%scan(&col.,&i.,'('), 1, ')') - 390 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, [, ^=, {, |, ||, ~=. ERROR 390-185: Expecting an relational or arithmetic operator. MLOGIC(VLIST): %DO loop index variable I is now 3; loop will not iterate again. NOTE: Line generated by the invoked macro "VLIST". 7 ddjoin(&i.) = %scan(%scan(&col.,&i.,'('), 1, ')') - 200 ERROR 200-322: The symbol is not recognized and will be ignored. MPRINT(VLIST): ddjoin(1) = aphase ddjoin(2 ) = , 1, ')') ; MPRINT(VLIST): run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 1:3 7:2 7:47 NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 5:2 NOTE: The SAS System stopped processing this step because of errors.

sas_user · ‎04-17-2018

I am trying to create a macro here, that will create a listing dataset. in my data i have a column to present date and day in date(day) format. I want my user to just give variable names in the format he wants in the output. so that he do not have to pass so many parameters to tell macro what kind of join it wants, but the macro finds it out itself. so if my user is passing col = adt(ady), i want my macro to separate both variables and join them in adt(ady) format. ddjoin(1) = adt ddjoin(2) = ady this is exactly what i want. but it is throwing errors for ddjoin(2). so once both are seperated, it can be joined as: if cmiss(var1,var2) = 0 then col0001 = strip(var1) || '(' || strip(var2) || ')'; I hope it helps.

sas_user · ‎04-17-2018

I am trying to create a macro here, that will create a listing dataset. in my data i have a column to present date and day in date(day) format. I want my user to just give variable names in the format he wants in the output. so that he do not have to pass so many parameters to tell macro what kind of join it wants, but the macro finds it out itself. so if my user is passing col = adt(ady), i want my macro to separate both variables and join them in adt(ady) format. I hope it helps.

sas_user · ‎04-17-2018

i have also tried replacing brackets in input with some other symbol. but issue remains same.

sas_user · ‎04-17-2018

This line is fine. it has 2 open brackets and 2 close brackets. %if &i ne 1 %then ddjoin(&i.) = %sysfunc(scan( %sysfunc(scan(&col.,&i.,'(')), %eval(&i.-1),')')); This is the line,that is throwing the error. it has same number of open and close brackets, i have also tried replacing brackets in input with some other symbol. but issue remains same.

sas_user · ‎04-17-2018

I am using below code to seperate ady variable , but it gives me error ' Expected close parenthesis after macro function invocation not found.' i have tried using compress and tranwrd function. but it says the same thing. options mlogic mprint symbolgen; %MACRO VLIST(in= , col = ,typ= ); data vlist; length col0001 $1000; set &in.; %if &typ. = DD %then %let n1 = %sysfunc(countw("&col.",'(')); %put &n1.; array ddjoin(*) $ var1 - var&n1.; %do i = 1 %to &n1.; %if &i eq 1 %then ddjoin(&i.) = %sysfunc(scan(&col.,&i.,'(')); %if &i ne 1 %then ddjoin(&i.) = %sysfunc(scan( %sysfunc(scan(&col.,&i.,'(')), %eval(&i.-1),')')); %end; if cmiss(var1,var2) = 0 then col0001 = strip(var1) || '(' || strip(var2) || ')'; run; %MEND VLIST; %vlist(in=b, col = adt(ady), typ = DD );

Online Status	Offline
Date Last Visited	‎07-16-2025 05:27 AM

Re: ODS and Reporting options in SAS ODA

Re: ODS and Reporting options in SAS ODA

ODS and Reporting options in SAS ODA

Re: How to import SAS dataset from local desktop to online SAS studio ...

How to import SAS dataset from local desktop to online SAS studio web ...

Re: Diferent values on x axis in SG Panel (SAS 9.4)

Diferent values on x axis in SG Panel (SAS 9.4)

Re: proc SGPLOT: Overlay of Individual and Mean Plasma Concentrations

proc SGPLOT: Overlay of Individual and Mean Plasma Concentrations

Re: ERROR: Expected close parenthesis after macro function invocation ...

Re: ODS and Reporting options in SAS ODA

Re: Diferent values on x axis in SG Panel (SAS 9.4)

Re: ODS and Reporting options in SAS ODA

Re: ODS and Reporting options in SAS ODA

ODS and Reporting options in SAS ODA

Re: How to import SAS dataset from local desktop to online SAS studio ...

How to import SAS dataset from local desktop to online SAS studio web ...

Re: Diferent values on x axis in SG Panel (SAS 9.4)

Diferent values on x axis in SG Panel (SAS 9.4)

Re: proc SGPLOT: Overlay of Individual and Mean Plasma Concentrations

proc SGPLOT: Overlay of Individual and Mean Plasma Concentrations

Re: ERROR: Expected close parenthesis after macro function invocation ...

Re: ERROR: Expected close parenthesis after macro function invocation ...

Re: ERROR: Expected close parenthesis after macro function invocation ...

Re: ERROR: Expected close parenthesis after macro function invocation ...

Re: ERROR: Expected close parenthesis after macro function invocation ...

ERROR: Expected close parenthesis after macro function invocation not ...