SAS Support Communities

yashpande · ‎12-09-2017

Perfect. All columns are numeric ...And thats why this problem. Thanks a lot

yashpande · ‎12-07-2017

Below is log when using Proc report 24 25 GOPTIONS ACCESSIBLE; 26 27 OPTIONS ORIENTATION=landscape NODATE papersize=A1 linesize=max pagesize=max leftmargin=0.5in NODATE NOCENTER MISSING=" " 28 formchar="|----|+|---+=|-/\<>*"; 29 ods pdf file="&path..pdf"; NOTE: Writing ODS PDF output to DISK destination "/data/Comparison.pdf.pdf", printer "PDF". 30 proc report data=work.output; 31 run; NOTE: There were 24 observations read from the data set WORK.OUTPUT. NOTE: PROCEDURE REPORT used (Total process time): real time 0.02 seconds cpu time 0.03 seconds 32 ods pdf close; NOTE: ODS PDF printed 1 page to /data/Comparison.pdf.pdf. And below is using Proc print 25 GOPTIONS ACCESSIBLE; 26 OPTIONS ORIENTATION=landscape NODATE papersize=A1 linesize=max pagesize=max leftmargin=0.5in NODATE NOCENTER MISSING=" " 27 formchar="|----|+|---+=|-/\<>*"; 28 ods pdf file="&path..pdf"; NOTE: Writing ODS PDF output to DISK destination "/data/Comparison.pdf.pdf", printer "PDF". 29 proc print data=work.output; 30 run; NOTE: There were 24 observations read from the data set WORK.OUTPUT. NOTE: PROCEDURE PRINT used (Total process time): real time 0.05 seconds cpu time 0.05 seconds 31 ods pdf close; NOTE: ODS PDF printed 1 page to /data/Comparison.pdf.pdf.

yashpande · ‎12-07-2017

Hi there, Simple question. I have dataset which contains 10 observations. I am using ODS PDF to create PDF file. OPTIONS ORIENTATION=landscape NODATE papersize=A1 linesize=max pagesize=max leftmargin=0.5in NODATE NOCENTER MISSING=" " formchar="|----|+|---+=|-/\<>*"; ods pdf file="&path..pdf"; proc report data=work.output; run; ods pdf close; this produces only 1 observation. However when I use proc print it correctly produces 10 records. what could be the issue? Any help is really appreciated

yashpande · ‎11-24-2017

Yes this works. Perfect

yashpande · ‎11-24-2017

Hi All, I have different procedures in my ODS PDF. Its PDF with 5 pages and several procedures like proc report, proc print, proc tabulate and proc univariate. When we see output, it looks really scattered. Below is code. data cars; set sashelp.cars (obs=10); run; options papersize=(21in 15in) leftmargin=1.05in rightmargin=1.05in; ods escapechar = '~' noresults noproctitle ; options symbolgen; ODS LISTING CLOSE; ods _all_ close; ods pdf file="/sasdata/Shared/test.pdf" gtitle gfootnote; ods pdf startpage=now; proc report data=cars; run; ods pdf startpage=no; proc print data=cars; run; ods pdf close; Problem is the width of these 2 results in pdf differs. While I do understand that these are 2 different procedures and would differ in appearance when executed . still Is there a way we can make it aligned at least in terms of width? see the screen below Any help is really appreciated Look at different width

yashpande · ‎11-19-2017

Hi All, I have table which provides values as input to other queries to create table. E.g. Input table abc Query : Proc sql; create table output as select column1 from lib.abc quit; If Input table has 2 or more rows like this Input table abc def Query : Proc sql; create table output as (select column1 from lib.abc) union (select column1 from lib.def ); quit; somehow I am not able to solve this using macro. I tried creating macro as below Proc sql; select column1 into :mac separated by ' union' from Input_table ; quit; above works for multiple tables but fails when there is only 1 value. Please help in solving this

yashpande · ‎09-15-2017

Hi All, I need to add new field on ECM case that is created. It will be called Action_taken. This is new field and needs to be added. I have already added this column in Case_live table. User to whom the case is assigned will login and type the action he has taken on case on ECM GUI. After he has finished writing the action, the text added in case should be directly updated in case_live table. I am unable to update the xml, its giving me error Case Action_taken is not defined. Need your help in updating the XML.

yashpande · ‎09-04-2017

Yes ultimately we are going to use LSF. But thats not the question. We need only 1 instance of execution and not rerun. In short only 1 infinite while loop and the moment flag value is 1 I need to break from the loop. Somehow I am not getting it.

yashpande · ‎09-04-2017

Hi All, I need an idea on how to proceed this. I want to run a node (mostly it would be a user written node) till I get value updated from another table. E.g. Code 1 /SQL Join transformation : Proc sql; select user_name,user_id,email_address,lot_name,completed_flag,process_date from user_table where completed_flag=1 and process_date="&sysdate."d; quit; Code 2 : Send an email to user_name and email_address from Code1 ; Now my requirement is to keep on checking for Code1 for entire day and the moment I get completed_flag's value as 1 , I need to send email to the users. In short, I need infinite while loop for Code1 till the day is completed. Any help/idea is appreciated

yashpande · ‎08-23-2016

I have below dataset and need to arrange the first observation by group which I want to use in proc report in next step .. But somehow with First. I am unable to get Desiree output. Can somebody help me here Dataset Have : Key1 desc key2 1 Akshay Nagpur 1 Rahul Nagpur 1 Rajesh Nagpur Desired Want Dataset as Key1 Desc Key2 1 Akshay Nagpur . Rahul . Rajesh Any help is really appreciated

yashpande · ‎06-18-2016

Superb. Thanks a ton

yashpande · ‎06-13-2016

This is perfect. However can you also help me in the report having source columns as well ? doesnt matter size of dataset

yashpande · ‎06-07-2016

Can we also add the column names in this report for each transformation ? E.g. Extract has 10 columns and also has new derived variable in output and I want to display that details as well. Need some guidance on this

yashpande · ‎06-05-2016

Hi There, We have got SAS DI Jobs and I am trying to findout all list of SAS Jobs present in repository and its inputs and Outputs tables. I have heard a lot about PROC Metadata and have gone through the SAS Docs , however I couldnot find the information on looping through the entire repository.Some direction to the approach would be really appreiated.

yashpande · ‎05-22-2016

Yes that's right.

Online Status	Offline
Date Last Visited	‎07-21-2024 02:49 PM

SAS Support Communities

Re: Simplify proc sql multiple joins

Simplify proc sql multiple joins

multiple prxchange together

Values iteration for two datasets

Re: Generate Random values for encoding

Generate Random values for encoding

Need help in creating regular expression for prxchange feed

Modify taking lot of time

Re: Left Join or Merge of sas tables optimization

Left Join or Merge of sas tables optimization

Re: Proc Metadata to get Dependent Objects

Re: Proc Metadata to get Dependent Objects

Re: macro nested loop group by

Increment datetime by 6hours

Re: Why Proc report produces only 1 record in output and Proc print pr...

Re: Why Proc report produces only 1 record in output and Proc print pr...

Why Proc report produces only 1 record in output and Proc print produc...

Re: Proc SQL Union based on table

How to make table size same for different procedures in ODS PDF

Proc SQL Union based on table

Customize SAS ECM field

Re: Continuous Processing of Node

Continuous Processing of Node

Rearranging data and then do proc report

Re: Proc Metadata to get Dependent Objects

Re: Proc Metadata to get Dependent Objects

Re: Proc Metadata to get Dependent Objects

Proc Metadata to get Dependent Objects

Re: Extract string from word

Follow Us

What is...