About PaigeMiller

PaigeMiller · ‎06-20-2012

No macros needed, if I understand you properly. You just need to use the %include command %include "\\server\share\extract.sas"; %include "\\server\share\load.sas"; Of course, you would use the exact path of these .sas files instead of \\server\share

PaigeMiller · ‎06-20-2012

Can you give me an example of two or three program calls? Are these SAS programs being called, or non-SAS programs? When you say calling "several different programs at once", do you really mean "calling several different programs in sequence via one SAS program"?

PaigeMiller · ‎06-20-2012

how do I create a macro that has all the program calls in it? This is very vague ... not clear at all why you want a Macro that has all program calls in it, when a program that doesn't have macros could also have all the program calls in them. Why do you need macros for this? What program calls are you referring to? Also before running the program each day I want the macro to check if the previous days data ran successfully and if the log dependancy for today is met before kicking of the jobs. Each day, if the program runs successfully, write the date and status (could be simply a 1 for success and 0 for fail) to a SAS data set. Next day, check to make sure the data set has a 1 on the previous day.

PaigeMiller · ‎06-15-2012

Thanks! Often, finding the right option isn't easy through documentation, its much easier to ask.

PaigeMiller · ‎06-15-2012

Are you saying (implying) that if I use the Pipe access method, no DOS windows pops up? Because in this particular instance, I don't really need the features you mention.

PaigeMiller · ‎06-15-2012

Can I issue a DOS command in SAS by using the X command, in such a way that the resulting DOS window is either minimized, or doesn't pop up at all? Windows 7 Professional, 64 bit, SAS 9.3 Thanks.

PaigeMiller · ‎06-14-2012

I imported into SAS an Excel spreadsheet successfully. The answer to your question depends on how you did this import. If you used PROC IMPORT, then you might want to turn on GETNAMES=YES; (although I thought it was the default). This should take the first row of the Excel spreadsheet and make it the SAS variable name. If you used other methods for importing the spreadsheet, let us know, there is most likely a way to address this issue for other methods of importing.

PaigeMiller · ‎06-06-2012

Yes I have SAS/ACCESS Interface to PC Files

PaigeMiller · ‎06-06-2012

Yes, I looked at the help for the Excel Libname option, but I didn't see anything that clearly let me do what I wanted. (That doesn't mean the features don't exist, they might be there, I just didn't see anything that looked like what I wanted in the help files)

PaigeMiller · ‎06-06-2012

Thanks, data _null_; as always you have a great answer. I'm sure your solution works, however I think I will stick to a language that I am familiar with, and write a macro in SAS that converts certain variables from char to num, and other variables from num to char. A macro based on your code, which uses Excel macro code (I assume) means that I have a language that I cannot debug or enhance if needed, nor could I explain it to others, so this is a less desirable solution.

PaigeMiller · ‎06-06-2012

There is little choice to change the variable's type for proc import . But if you can, you can change it after importing it into SAS . Thanks for not trying to redefine my problem. I am disappointed that there is no better solution, but this seems to be the way to go.

PaigeMiller · ‎06-06-2012

If there was only one such Excel file, I could open it and change it to CSV. This is not the case. There are many Excel files, and I want a program to run unattended, overnight, on a regular schedule. I am not aware of a programmatic way to change Excel files to CSV.

PaigeMiller · ‎06-05-2012

PartNumber should always be read as character. Units should always be read as numeric, but sometimes it contains alpha. Etc. The system has been in place for years, and isn't going to change because the statistician has trouble reading it with his software. Other people have developed Excel macros and VB programs and other programs to work with the data as it exists. They're not going to change for me. It is what it is. I think I should push back on people who think I should push back on the creation of the data files. I think pushing back would be a waste of time.

PaigeMiller · ‎06-05-2012

Thanks. I am not generating these Excel files, so I do not have the option of creating them or saving them as CSV.

PaigeMiller · ‎06-05-2012

Is it possible, using PROC IMPORT, to read Excel files and force certain columns to be numeric in the resulting SAS data set; and/or force other columns to be character in the resulting SAS data set? If so, how? If not, are there other mechanisms in SAS that will allow me to achieve this? Same questions regarding PROC EXPORT, can I force the resulting Excel file to contain text in specified columns, and/or contain character strings in other specified columns? Thanks, Paige

Online Status	Offline
Date Last Visited	yesterday

Re: Calculate time by comparing conditions and dates vertically

Re: Unable to open xls file

Re: selecting marker types and colors in proc sgplot

Re: A SAS Macro to Use ODS to Direct Graphics Output to a Specified Fo...

Re: proc pls : saving the model

Re: Combine the variable values vertically

Re: Combine the variable values vertically

Re: A SAS Macro to Use ODS to Direct Graphics Output to a Specified Fo...

Re: proc pls : saving the model

Re: proc pls : saving the model

Re: Difference between dates in SAS doesn't match results

Restore Interactive Perspective in SAS Studio

Re: LSD test in PROC GLIMMIX

SAS Studio, SAS Server search/navigation bar

Re: PROC REPORT: How to apply same color to group headers and column h...

Re: selecting marker types and colors in proc sgplot

Re: proc pls method pcr plots

Re: Create a new Calclation based on multiple conditions

Re: Why I Still Trust This Community More Than Any AI Assistant

SAS Viya/SAS Studio — how to convert code to lower case?

Re: Need help with automating macros

Re: Need help with automating macros

Re: Need help with automating macros

Re: X command where DOS window is minimized?

Re: X command where DOS window is minimized?

X command where DOS window is minimized?

Re: How to use "labels" (Excel column headers) instead of SAS "names" ...

Re: PROC IMPORT/EXPORT -- forcing column to be character or numeric

Re: PROC IMPORT/EXPORT -- forcing column to be character or numeric

Re: PROC IMPORT/EXPORT -- forcing column to be character or numeric

Re: PROC IMPORT/EXPORT -- forcing column to be character or numeric

Re: PROC IMPORT/EXPORT -- forcing column to be character or numeric

Re: PROC IMPORT/EXPORT -- forcing column to be character or numeric

Re: PROC IMPORT/EXPORT -- forcing column to be character or numeric

PROC IMPORT/EXPORT -- forcing column to be character or numeric

SAS Quant Community

SAS Global Forum