About SASHunter

eswoope · ‎03-26-2020

And here we are on March 26, 2020, and the problem is still there in Edge. For some reason Chrome crashes on my computer even after I uninstalled and reinstalled and I haven't gutted up to try to fix it after my initial attempts worked only briefly (thanks, Windows 10). I've tried several printer drivers (three different PDF drivers and my laser printer) and the result is the same. I get a blank first page and then one page of code.

ballardw · ‎11-15-2018

@SASHunter wrote: Hi Brian, Thanks - I tested a few more times to see what you were saying. And yes it does have the Log and Results for each submission. Thank you very much. But maybe for the next version they could also make the Results tab be appended to, along with the Log tab. So yes this helped. Nancy The behavior you describe is the default currently for the Display manager, Base or Foundation version of SAS. (different names for the same thing). And people ask how to stop that and replace or clear and then display. Options you could set with code are nice but the Results window has not been the recipient of many options and not easy to find.

ef_ · ‎07-11-2018

I've run into a similar problem. I've defined a macro variable in a program in process flow A, but when the process flow step with conditional execution on the macro's value runs in process flow B, it doesn't recognize the macro. However, other programs in process flow B can output the correct value of the macro using %put.

kmw · ‎09-29-2017

This is an approach to put all observations of the same Deptid value into separate data sets named from the Datadescription variable. 　 data have; infile datalines truncover; input @1 deptid 1. deptdescription $ & 3-20; datalines; 1 Maths 2 Astronomy 1 Maths 3 Physics 4 Public Health 3 Physics ; run; /* Sort by Deptid so first./last. logic can be used in the next step */ proc sort data=have; by deptid; run; /* CALL SYMPUTX creates macro variables &Subj1, &Subj2, etc from the values of Deptdescription.*/ /* The total unique values of Deptdescription are stored in &Total */ data _null_; set have; by deptid; if first.deptid then do; i+1; call symputx('subj'|| left(put(i,2.)),deptdescription); end; if last.deptid then call symputx('total',i); run; /* Within a macro %DO loop the data sets are created and those observations with the same */ /* Deptdescription values are read with a WHERE clause */ %macro test; %do i=1 %to &total; data &&subj&i; set have; where deptdescription="&&subj&i"; run; %end; %mend test; /* invoke the macro */ %test

ballardw · ‎09-28-2017

As I said, I'm rusty on file print but i think you need to have it as part of Put statemen for the page number, and if your report is going to be multiple pages then you have to provide logic to assign it. Does the output really have to go to a text file? If you use ODS RTF then the page number could be handled with options and by default each table starts on a page.

SASHunter · ‎05-16-2017

Vince, Thank you very much. That works perfectly for what we need. We have saved this macro to our drive and can now alphabetize any dataset in SAS Studio. But for a future release of SAS Studio, if there is that option in the Column layout to just click a button to alphabetize the columns so the search is easier - that would be great. SAS is the best! Cheers, Nancy

Cynthia_sas · ‎03-16-2016

There's nothing in the ODS statement about the variable labels. It is the procedure you are running that controls this. For example, PROC REPORT and PROC TABULATE use labels if they are in place. But PROC PRINT does not. So look at your procedure output. cynthia

data_null__ · ‎10-14-2015

I think this is what you want. options center=0 ls=max; filename FT74F001 temp; proc printto new print=FT74F001; run; proc compare base=sashelp.shoes(obs=5) compare=sashelp.shoes(firstobs=2 obs=6) brief novalues listvar; run; proc printto; run; data unequalvars; infile FT74F001; input @'NOTE: Values of the following' n @'variables compare unequal:' @; do i = 1 to n; input name:$32. @; output; end; stop; run; proc print; run;

SASKiwi · ‎09-03-2014

You need to check out the directory location of the file your program is reading in. SAS is saying there is something wrong with: /cpspb/supp/progs/aug14/0814mis.lis so you need to confirm that this folder path is still correct. At a Linux command prompt type in the command ls -l /cpspb/supp/progs/aug14 and check the output.

jakarman · ‎04-22-2014

SAShunter, You found that it will open the file. I have seen the columns when importing it in column mode. Shifting the positions creating the variables. (type *.txt) Not found any example that quickly at the SAS site. There must be a menu-option to start that process. When the suffix would be a "*-.sas* it would open as SAS-program and adding a link in you current flow. I did not feel some need using to columns anymore with this kind of approaches. going for a download that should be easy There and back again: copying files in SAS Enterprise Guide - The SAS Dummy

djbateman · ‎03-14-2013

I don't know why they wouldn't appear on older posts. It may be something they came up with recently. I joined the SAS community in June 2011, so I don't have anything older to compare it to. Those June 2011 posts still have the "Correct" and "Helpful" options for me. I would conclude that they added it since then. I wouldn't know how to change older posts to answered. Sorry!

krithi · ‎12-06-2012

Though this thread is answered, I once was in trouble until I found this paper http://www.nesug.org/Proceedings/nesug09/cc/cc05.pdf and used it as below- options minoperator; %if %eval(&D in 07,14,21,28,35,42,49,56,63,70,77,84,91) %then %do;

FriedEgg · ‎10-26-2011

Yes, the bestw.d informat is a direct alias of the w.d informat, an important distinction... Outputs from the formats w.d, bestw.d, and bestdw.p for integer values should be virtually identical until the integer values reach extremes and the formats start converting to scientific notation at different points and sometimes with different percision that eachother. The output of the bestw.d and bestdw.p (when the same w is used and default p value) should be identical for all integers.

SASHunter · ‎10-21-2011

Tom, After you said that, I thought I'd try one more thing. I copied the beginning of that problem - (which is three pages of comments) and the first couple lines of code that included the OPTIONS statement; into a small program. I then opened up a SAS windowing session on the LINUX machine and opened up this new program. Sure enough the OPTIONS statement was being seen as part of the comments above it. Now not that I didn't think of that before, I looked at the comments and saw that it ended with a slash. But the problem was that the slash at the very top of the program was missing. This made the next line (OPTIONS statement) become part of the comments because the OPTIONS statement ended with the first semicolon. Wow - what a headache. :smileyplain: Thanks, Nancy

SASHunter · ‎03-07-2013

Good morning all, I was reading this post and was wondering where on the page the user (post originator) can change the post from 'Not Answered' to 'Answered'. I can't seem to find this out. Am I just missing where this is located on the page? Thanks, Nancy:smileyconfused:

Online Status	Offline
Date Last Visited	‎01-02-2019 03:00 PM

Re: Printing out the Code with line numbers

Re: Printing out the Code with line numbers

Printing out the Code with line numbers

Re: SAS Studio (Results Tab)

Re: SAS Studio (Results Tab)

SAS Studio (Results Tab)

Re: Printing to a new Page using _PAGE_

Printing to a new Page using _PAGE_

Re: Displaying the Columns of a dataset in alphabetical order

Re: Displaying the Columns of a dataset in alphabetical order

Re: Printing to a new Page using _PAGE_

Re: Displaying the Columns of a dataset in alphabetical order

Re: Displaying the Columns of a dataset in alphabetical order

Re: Using ODS to write to Excel is using Labels instead of SAS Names

Re: How do I use a macro variable inside a IN statement

Displaying the Columns of a dataset in alphabetical order

Re: Displaying the Columns of a dataset in alphabetical order

Re: Having SAS actually SEND the email

Re: Printing out the Code with line numbers

Re: SAS Studio (Results Tab)

Re: Getting a macro variable to resolve when using a Conditonal for a ...

Re: Splitting a dataset into multiple dataset

Re: Printing to a new Page using _PAGE_

Re: Displaying the Columns of a dataset in alphabetical order

Re: Using ODS to write to Excel is using Labels instead of SAS Names

Re: How to create a List from PROC COMPARE to use in program

Re: Question (problem) with creating a 'xls' file from Linux in SAS

Re: Using FSLIST while connected to the LINUX machine

Re: How are questions changed from 'Not Answered' to 'Answered'

Re: How do I use a macro variable inside a IN statement

Reading the number of records in a INPUT file

Re: Problem with MPRINT not producing the resolved macro stuff

Re: How are questions changed to "Assume Answered"?