About NR13

ChrisNZ · ‎02-26-2020

Are these SAS data sets? Are the tables sorted? Or indexed? Can they easily be kept sorted and/or indexed, or are they refreshed too often? How many records in each? You use select *. Do you actually need all columns from all tables? Please add the _method option after proc sql so we can see how SAS executes the joins.

Cynthia_sas · ‎08-19-2019

Hi: That sounds like something you'd do in Visual Basic or Visual C++ -- it's not something you can really do in SAS. The page numbers are NOT "callable". Imagine what happens if someone opens the RTF file and readjusts the margins at the top and bottom to be 2 inches -- the page breaks and page numbers will be different. Cynthia

NR13 · ‎08-16-2019

Cynthia, you are the best!! Thank you so much!

ballardw · ‎08-08-2019

Have you tried creating two separate RTF documents each with a table of contents and then combining them using your word processing program? I suspect there will be a limitation based on the word processing program and you may be stuck with using word processor tools to build the appropriated TOC's such as https://answers.microsoft.com/en-us/msoffice/forum/all/table-of-contents-2-table-of-contents-in-one/abf5fa60-d282-4b48-9c92-25e9190cf0b9 Search Google for "Multiple tables of content in Word" to get multiple pages.

NR13 · ‎05-03-2019

This is even better than I was hoping for!! Thank you so much!

LOVE_SAA · ‎09-11-2018

I have below data in an input file. I want to scan using a key word in each line and then want the ouput as below Input File: Code 201 Created Date: Mon, 10 Sep 2018 08:30:56 GMT Location: Asia, Singapore Length: 150 Output: Col1 Col2 Col3 Col4 201 Mon, 10 Sep 2018 08:30:56 GMT Asia, Singapore 150 Col1: After Code, get the 3 digits Col2: After "Date: " and till end Col3: After "Location: " and till end Col4: After "Length: " and till end

ballardw · ‎05-19-2017

@NR13 wrote: You're right - definitely an "OR". When I try it, it changes the variables I need, but then repeats the changed variables with errors. So in my case, I'm using MEC1-MEC4 and adding the prefix of "R1_". This is what I'm getting in my log: NOTE: Renaming variable MEC1 to R1_MEC1. NOTE: Renaming variable MEC2 to R1_MEC2. NOTE: Renaming variable MEC3 to R1_MEC3. NOTE: Renaming variable MEC4 to R1_MEC4. ERROR: Variable MEC1 is not on file WORK.R1. ERROR: Variable MEC2 is not on file WORK.R1. ERROR: Variable MEC3 is not on file WORK.R1. ERROR: Variable MEC4 is not on file WORK.R1. ERROR: Variable MEC1 is not on file WORK.R1. ERROR: Variable MEC2 is not on file WORK.R1. ERROR: Variable MEC3 is not on file WORK.R1. ERROR: Variable MEC4 is not on file WORK.R1. Looks like either the selection code or the Proc datasets is pointing to the wrong dataset. POST the entire code that generates that error. Please use a code box such as opened using the forum {i} menu icon.

ballardw · ‎11-21-2016

And to the OP if you ever need to extend this then the function SMALLEST would come into play. first = smallest(1,var1,var2,var3,var4); second = smallest(2,var1,var2,var3,var4); third = smallest(3,var1,var2,var3,var4); fourth = smallest(4,var1,var2,var3,var4); though it would likely best to declare a couple of arrays for this.

Online Status	Offline
Date Last Visited	‎02-26-2020 03:57 PM

Reading in a large dataset using Proc SQL

Re: Odd page Header and different Even page Header in an RTF document

Re: ODS RTF Cover Page with Images

ODS RTF Cover Page with Images

Odd page Header and different Even page Header in an RTF document

Is it possible to have a 2 part table of contents, in one document?

Re: Proc Freq By Type Output

Re: Proc Freq By Type Output

Re: Proc Freq By Type Output

Re: Proc Freq By Type Output

Re: Reading raw data from a text file

Re: Is there a way to get a frequency between 2 variables, where order...

Re: Is there a way to get a frequency between 2 variables, where order...

Re: Reading in a large dataset using Proc SQL

Re: Odd page Header and different Even page Header in an RTF document

Re: ODS RTF Cover Page with Images

Re: Is it possible to have a 2 part table of contents, in one document...

Re: Proc Freq By Type Output

Re: Reading raw data from a text file

Re: How to rename multiple batches of variables in PROC SQL?

Re: Is there a way to get a frequency between 2 variables, where order...