Home

kyle234 · ‎05-08-2024

I am running a macro that creates two data sets, I want to output 2 datasets to the same excel worksheet. Then I want to call the macro again and add another worksheet with two datasets to the same workbook. Whenever I run this code, the second run does not add another worksheet. I am wondering what is going on. Thank you ods excel file='\path' options( sheet_interval='NONE' sheet_name="&SCHEMA"); proc report data=TABLE_DIFF_FINAL; run; proc report data=VAR_DIFF_FINAL; run; ods excel close;

BeerSultan

Brand new to SAS. I'm doing something that I expect is relatively easy, but I'm struggling to get it right. The requirement is basic - I'm reading in a long file with many rows, if a record matches a criteria I want it to be shipped to a different "bypass" file that I'll work on in a later process, but it should be removed from the original read-in file. Environment is zOS - input file is defined and passed in via JCL (all working). I get the following errors if I remove my actual logic - if I leave the FILENAME statement in without referencing it there's no errors. ERROR: Invalid logical name. ERROR: Error in the FILENAME statement. ERROR: Invalid file, BYPASS_FILE. FILENAME BYPASS_FILE BYPASS1; /***********************************************************/ /* READ FILE */ /***********************************************************/ DATA DATAIN; INFILE DATAIN; INPUT @ 00001 RECORD_NUMBER $CHAR8. @ 01769 COMPONENT_STATUS $CHAR1. ; /*******************************************************************/ /* CREATE BYPASS FILE - USED TO STORE RECORDS WHICH HAVE AN */ /* INACTIVE COMPONENT: COMPONENT_STATUS = I */ /*******************************************************************/ IF COMPONENT_STATUS = 'I' THEN DO; FILE BYPASS_FILE; PUT; DELETE; END;

kumarsandip975

Hi Everyone, I am getting below error message when trying to run below code with ENCODING=WLATIN1 from SAS Studio. Can you please suggest on it. Note : The same code is running fine with ENCODING=UTF-8 DATA T1; var1="aábcčdď"; run;

user34567

Hi all, I have created this calculation to show the number of hours in 2024 and added it to my list table: IF ( 'Document_date_year'n = '2024'd ) RETURN ( IF ( 'Hours'n Missing ) RETURN 0 ELSE 'Hours'n ) ELSE 0 It works, but it shows the number of hours for each time a person entered their hours instead of just a count for each person. Thats why I created a crosstab instead so that it sums the total number of hours per person. But now the above calculation is not working and it just shows 0. List table output Person A 8 Person A 8 Person A 8 Person B 8 Person B 8 Person C 8 Person C 4 Desired output Person A 24 Person B 16 Person C 12 Does someone understand why this happens? Thanks in advance!

michel295

There are several methods on the internet to add multiple files into one PDF. I refer to a capable Softaken merge PDF Program to merge all PDF data into one portable document format. With the help of this utility, you can easily merge locked or unlocked PDF files. The tool merges the data of a PDF file regardless of its size. The tool permits the user to choose their own choice of PDF File for merge. Without any restrictions or limitations, you can merge your PDF file easily. This application is an attractive user-friendly interface that supports all kinds of small or big PDFs for merging. Also, using this application, you can save your merged PDF file at your desired location. This user-friendly software runs smoothly with all Microsoft Windows editions so you can easily run this utility in any Operating System. For more information, you can also download the free trial version of this software.