About SGB

Cynthia_sas · ‎04-02-2021

Hi: In PROC REPORT, you can only merge header cells horizontally. If you move into the Report Writing Interface (RWI), then you can merge cells horizontally, but it is a DATA step solution using the method/object syntax. There is an example and some code in this Forum posting: https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-Merge-cells-horizontally-in-ODS-Excel-output/m-p/730820#M24956 The posted code is written for ODS HTML, ODS PDF and ODS EXCEL. Hope this helps, Cynthia

shivaraj · ‎09-12-2018

var=compress(var_name,' ',' p');

beatledodger · ‎04-15-2016

Thanks so much for this: data want; set want; char_account_number = put(account_number, $15.) ; drop account_number ; rename char_account_number=account_number ; run; I'm sure that there are other ways to accomplish this, but this certainly worked for me. I am posting SAS data to a SQL server and SAS likes to push dates as numeric. I've tried various versions of the PUT statement, FORMAT, etc. But this did it. Thanks again.

LetourneauKent · ‎02-05-2016

I have been using the PROC COPY method to create sas v5 XPT transport files for years to transfer data to the FDA. It has recently been pointed out the the https://support.sas.com/techsup/technote/ts140.pdf tech notes for this format state that the INTRODUCTION All transport data set records are 80 bytes in length. If there is not sufficient data to reach 80 bytes, then a record is padded with ASCII blanks to 80 bytes. All character data are stored in ASCII, regardless of the operating system. I am working in a SAS environment with wlatin1 encoding and often my data contains characters that are not part of the ascii character set. When I create my XPT files with the PROC COPY method described in this thread I get SAS v5 XPT files but these files still contain my wlatin1 encoding. Is it possible that the SAS logic to create a SAS v5 XPT files creates files that are not fully compliant with their own technotes or am I misunderstanding something? thanks in advance for hte responses. KL

SGB · ‎12-12-2013

Tom has answered this question in the other link.. Thanks a lot to Tom! https://communities.sas.com/message/190760#190760

SGB · ‎12-12-2013

Thanks Tom for your time.. I think the second/above method you have proposed will solve my purpose.. Appreviate your time and help. Thanks SGB

SGB · ‎02-26-2013

Thank you very much Cynthia.. This definitely helps. I have one quick Q related to the example mentioned in the link.. Result looks like it’s continuing to run on the web page. will it cause any issues in the web environment ? Thanks Bhuvana

BrunoMueller · ‎02-25-2013

Hi Bart Stored Process Input parameters are written to the corresponding macro varibales. You could use code similar to the one below to capture the contents of the macro variables: proc sql; create table myParms as select * from dictionary.macros where name like "/_%" escape "/" order by name ; quit; The code above will only select macro variables starting with "_", but you can change the WHERE clause to get what you need Bruno

DonH · ‎09-27-2012

If you are creating stored process server sessions, the other option is to take advantage of the SAVE_ convention for saving macro variables from one request to the next one. This only works if you are using sessions. Basically what the server does is at the end of the request, it saves all the macro variables whose name begin with SAVE_ (not case-sensitive) and then when a new request reconnects to the session, it loads the macro variables back so they are available. This is a nice way to save state without having to embed values in the URL as name/value pairs.

JuanL_Sanchez · ‎09-07-2012

Hello: You can get this security warning when there are mixed HTTP and HTTPS content on the web page you are creating. You could disable this warning for yourself by: In IE web browser, going to Tools->Internet Options->Security Select the Security tab Click on the Internet zone icon at the top of the tab page Click the Custom Level button In the Miscellaneous section change Display mixed content to Enable Repeat steps 1 – 5 for the Local intranet and Trusted sites zones But, as I can imagine, the users that are going to use this web page don't want to change their IE configuration. So it's better to check the content type (urls like http:// and https://) from your content. J

ShaheenRanalvi · ‎09-06-2012

Thanks SGB. I'll definitely get in touch with you once i get a licensed SAS Enterprise guide.Kindly guide me then,i really need the how to's. Regards, Shaheen

NN · ‎09-04-2012

Hi, I cannot test this right now... but can you check if something like this works &_URL?_program=/yourfolder/your+stored+process without mentioning a userid or password in your link...

zeelan · ‎10-05-2012

Hi , You can try this data _null_; format infile $char256.; input; infile = resolve(_infile_); file _webout; put infile; cards4; <HTML > code; ;;;; run;

Mirisage · ‎08-12-2012

Hi Patrick, You are right. I have been just mechanically striving to create whatever variable combination that would make a unique record which alone wouldn't work. I should contact the relevant bank and ask. I learned a lot through this discussion. Thanks again! Mirisage

Filipvdr · ‎09-14-2012

send your code and detailed questions to filipvdr@gmail.com - i will try to answer them then

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Question about dynamically getting the number of each weekdays(MTW...

Re: How to create a macro to see number of sun,mon,tues to sat in each...

Question about dynamically getting the number of each weekdays(MTWTFSS...

Re: How to create a macro to see number of sun,mon,tues to sat in each...

Re: How to create a macro to see number of sun,mon,tues to sat in each...

Re: How to create a macro to see number of sun,mon,tues to sat in each...

Re: How to create a macro to see number of sun,mon,tues to sat in each...

Re: How to create a macro to see number of sun,mon,tues to sat in each...

Re: How to create a macro to see number of sun,mon,tues to sat in each...

Re: How to create a macro to see number of sun,mon,tues to sat in each...

Re: How to create a macro to see number of sun,mon,tues to sat in each...

Re: How to create a macro to see number of sun,mon,tues to sat in each...

Re: How to create a macro to see number of sun,mon,tues to sat in each...

Re: How to avoid the security warnings -

Re: Merging Cells horizontally in PROC REPORT

Re: Can we convert numeric variable into a character var in the sql ex...

Re: Can we convert numeric variable into a character var in the sql ex...

Re: How To create .XPT files? How to Convert .xpt files to Sas Dataset

Re: How to identify variable (or combination of variables) that would ...

Re: capture stored process input parameters

Re: Merging Cells horizontally in PROC REPORT

Re: How to identify all the special character in a variable value and ...

Re: Can we convert numeric variable into a character var in the sql ex...

Re: How To create .XPT files? How to Convert .xpt files to Sas Dataset

Re: Question about dynamically getting the number of each weekdays(MTW...

Re: How to create a macro to see number of sun,mon,tues to sat in each...

Re: Streaming output from a SAS® Stored Process to Microsoft Excel

Re: capture stored process input parameters

Re: Passing macro variable values with special characters within sessi...

Re: How to avoid the security warnings -

Re: Generating Forms in SAS

Re: Problems with bypassing logon screen with each stored process

Re: custom HTML - Stored process!

Re: How to identify variable (or combination of variables) that would ...

Re: Stored Procs w/JQuery