About PrinceAde

PrinceAde · ‎10-06-2024

Hello everyone. please I need help with replicating a listing template. I want to display few columns using proc report based on a given template. The columns are not staying on the same line. About three columns continue to the next line which is not looking good. This occurs because the cellwidth for each column is around 25. If I should reduce the cellwidth, the columns will stay on this same line, which is perfect. However, the template I'm trying to copy is well spaced around 25 width. How can I retain the width(around 25) I want and still maintian the columns on the same line? I have tried to use the papersize option to increase the size of the page, it is not working. What can I do, please? Thanks all for your replies.

PrinceAde · ‎10-06-2024

Hi everyone, I have challenge formating time. I'm trying to create time format from time(). For example, I want it in 5:25(I don't want pm or am attached to time). What I'm getting is either 5:25pm and 17:25. data _null_; call symputx('time', put(time, tod5.)); run; %put &=time; I have tried using time5. timeampm. as well. None is working. What can I do please?

PrinceAde · ‎10-05-2024

Hi everyone, please I have confusion on how an indirect references works sas macro. I don't understand how this resolves to type2; %let value1 = dogs; %let value2 = cats; %let value3 = birds; %let type1 = value1; %let type2 = value2; %let type3 = value3; %let animal = type2; %let final = animal; %put &&&&&&final;

PrinceAde · ‎08-25-2024

@JuanS_OCS Thank you very much. These are interesting options. I'm interested in these options, especially in relation to cost. Are they cost effective?

PrinceAde · ‎08-24-2024

Hi everyone, Please I need help to address integrating SAS into PHP. I'm trying to integrate SAS code into PHP that can deal with data manipulation using data step, proc sql, it will also use macro, etc. We have the code completed in SAS already, the code also make a macro call to another macro, it calculates Overall Concordance Correlation coeficient based on Barnhart equation, using %include. How can I integrate this existing programs into PHP(We are building an application using PHP). Thank You.

PrinceAde · ‎08-24-2024

Hello @Vimal_U Good day. Please I would like to know if you are able to achieve your aim back then, i.e. the integrating SAS with PHP. I'am trying to do achieve the same thing. I will appreciate your insight, thank you.

PrinceAde · ‎06-11-2024

@PaigeMiller Thank you, sir. I understand this; I just want to know if there is any rationale for the Proc SQL join behaving this way.

PrinceAde · ‎06-11-2024

Hi @ballardw @PaigeMiller I'm sorry for the confusion. If you check the result of the match merging, you will notice that the first observation is x a b 1 a1 while for the proc sql full join it is x a b 1 a2 I'm not sure why the sql join jumped the first observation 1 a1 in table three and decide to start from 1 a2 Data three; input x a$; datalines; 1 a1 1 a2 2 b1 2 b2 4 d ; run; Data four; input x b$; datalines; 2 x1 2 x2 3 y 5 v ; run; proc sql; title 'Table Merged'; select coalesce(three.x, four.x) as x, a, b from three full join four on three.x = four.x; quit; data merged; merge three four; by x; run;

PrinceAde · ‎06-10-2024

Hello there, Data three; input x a$; datalines; 1 a1 1 a2 2 b1 2 b2 4 d ; run; Data four; input x b$; datalines; 2 x1 2 x2 3 y 5 v ; run; proc sql; title 'Table Merged'; select coalesce(three.x, four.x) as x, a, b from three full join four on three.x = four.x; quit; table1 x a b 1 a2 data merged; merge three four; by x; run; table2; x a b 1 a1 I don't understand While the proc sq join starts with table1 instead of table2. Please clariification? Thanks

PrinceAde · ‎05-23-2024

Thank you sir. If you can read the line that describe the data-type.

PrinceAde · ‎05-22-2024

Sorry, sir. I saw in the Text; SAS® Certified Professional Prep Guide: Advanced Programming Using SAS® 9.4

PrinceAde · ‎05-22-2024

Thanks for the reply. Yes it generated error. The documentation states that the "data-type is enclosed in parentheses". The data-type for destination for example is char. Is it that the documentation has been updated?

PrinceAde · ‎05-22-2024

Please I need clarifcation on the code below. Thanks. "data-type bis enclosed in parentheses and specifies one of the following: CHARACTER (or CHAR) | VARCHAR | INTEGER (or INT)." proc sql; create table work.discount (Destination char(3), BeginDate num Format=date9., EndDate num format=date9., Discount num); quit; I expect the data-type should be in parenthesis based on the syntax description above, e.g, Destination (char)(3). Please what am I missing?

PrinceAde · ‎11-20-2023

@Mark2010 Yes, I have seen it thank you.

PrinceAde · ‎11-20-2023

@Mark2010 Okay sir. I have read previous comment here, the problem with the glitches appears to do with read only files, or something like that. Thank you.

Online Status	Offline
Date Last Visited	‎10-09-2024 08:19 PM

Columns splitting to second line in proc report

Time format

Indirect references of macrovariables

Re: Integration of SAS in PHP

Integration of SAS in PHP

Re: Can anyone know how to integrate SAS with PHP?

Re: Proc Sql Joins

Re: Proc Sql Joins

Proc Sql Joins

Re: Proc sql datatypes in create table statement

Re: sum statement

Re: Proc sort

Integration of SAS in PHP

Columns splitting to second line in proc report

Time format

Indirect references of macrovariables

Re: Integration of SAS in PHP

Integration of SAS in PHP

Re: Can anyone know how to integrate SAS with PHP?

Re: Proc Sql Joins

Re: Proc Sql Joins

Proc Sql Joins

Re: Proc sql datatypes in create table statement

Re: Proc sql datatypes in create table statement

Re: Proc sql datatypes in create table statement

Proc sql datatypes in create table statement

Re: sas base certification

Re: sas base certification