About ijmoorejr

ijmoorejr · ‎05-29-2023

I'm using SAS Enterprise Miner 15.2. I set up a new project and created my data source by going to Help ->Generate Sample Data Sources ->Home Equity ->OK. Now that I have a Data Source, how can I save just the data source by itself to a local directory on my machine? Please advise. Thanks!

ijmoorejr · ‎03-19-2023

Yes, I have read that post. I created the following test.ksh, but get the message sas-viya: 'submit-pgm' is not a sas-viya command. See 'sas-viya' --help'. upon execution of the korn shell script. Also, I see no evidence of the /home/abc123/test.sas being executed. I do not see a test.log or test.lst. #!/bin/ksh cd /loc/of/cli ./sas-viya --profile ${SAS_CLI_PROFILE} batch jobs submit-pgm --pgm-path /home/abc123/test.sas --context default --watch-output --wait-output --wait-log-list --results-dir /home/abc The contents of /home/abc123/test.sas are as follows: proc options; run;

ijmoorejr · ‎03-17-2023

My company has an installation of Viya 4 on Linux. I have a .sas program in /home/abc123/test.sas . What statement can I place inside a korn shell script to execute test.sas when the korn shell script is executed? I'm trying to figure how to run .sas programs in batch with the .log written to the same directory has the .sas. Please provide an example.

ijmoorejr · ‎02-15-2022

I am interested in learning how to programmatically manipulate data objects that have been imported into SAS VI. For example, how would one change the length of a field or maybe change a field from character to numeric by writing code as opposed to pointing and clicking in the gui or dropping the data object and rebuilding with the needed changes. I'm looking for basic skeleton code examples or good papers or articles on this topic. Thanks.

ijmoorejr · ‎02-20-2019

I am attempting to output a date9. formatted date field in SAS to an Excel spreadsheet via ODS tagsets.excelxp and Proc Report. Once in Excel, I would like the data to be treated as a "date" type as opposed to "general" or "text", because I need to apply a date filter. The format of the dates in Excel needs to be m/d/yyyy. The code is malfunctioning and shows the dates in Excel as 1/1/1960. Does anyone know how this code needs to be edited in order to meet the above requirements? Please help. Thanks. data test; input test_date date9.; format test_date date9.; datalines; 17FEB2019 18FEB2019 15JAN2019 16JAN2019 ; run; proc print data=test; run; ods tagsets.excelxp file="C:\Users\ABC123\Desktop\test.xls" style=sasdocPrinter options(autofilter='all'); proc report data=test; column test_date; define test_date / 'test_date' center format=e8601dt. style(column) = [tagattr="type:DateTime format:m/d/yyyy"]; run; ods tagsets.excelxp close;

ijmoorejr · ‎02-18-2019

I am using the following DEFINE statement with PROC REPORT in order to convert some SAS date values to Excel datetime values and then display the data in a m/d/yyyy format in Excel. The issue I'm having is that all of the date values are displaying as 1/1/1960. Please help with example DEFINE statements. Thanks. define VAR1/ 'VAR1' format=IS8601dt. style(column)=[tagattr="type:Date format:m/d/yyyy"] center;

ijmoorejr · ‎02-14-2019

I am trying to write a Proc Report define statement that will allow me to 1) center the column data 2)format the data as "Date" m/d/yyyy when it outputs to Excel 3) create a filter on the column containing the data which would allow column filtering by year, month, day, etc. once in Excel. Please send examples. So far, I am only sure about how to center the data in the column. Thanks. define VAR1 / 'VAR1' center;

ijmoorejr · ‎12-04-2018

libname fsystem '/user/data/lives/here'; filename report email "person1@yahoo.com"; data fsystem.dset3; merge fsystem.dset1 fsystem.dset2; if var1=var2 then do; put 'Variables are equal'; put 'var1=' var1 'var2=' var2; call system ('sas /progs/live/here/prog1.sas'); end; else do; file report to=('person1@yahoo.com' 'person2@yahoo.com') subject="NOTIFICATION EMAIL" type='text/html' attach=("/user/data/lives/here/prog1.log"); put 'Variables are unequal" put 'var1=' var1 'var2=' var2; end; run; I would like to conditionally send an email when var1 DOES NOT EQAUL var2. However, the email currently gets sent regardless of whether or not the two variables are equal. How can I fix this issue? Please advise. Thanks.

ijmoorejr · ‎11-30-2018

Thank you, andreas_lds. Using call system worked.

ijmoorejr · ‎11-30-2018

The logic in the attached code block is working with the exception of the X command. Ideally, the X command to execute another SAS program should only run if varfroma=varfromb, but it keeps running even when varfroma ne varfromb. The put statements work properly, but the X command keeps running regardless of whether or not varfroma and varfromb are equal and seems to ignore the if/then/do logic. Can anyone suggest a way to fix this issue? Thanks. libname datalib '/users/data/lives/here'; data datalib.c; merge datalib.a datalib.b; if varfroma=varfromb then do; put 'BOTH VARIABLES ARE EQUAL'; x 'sas /users/prog/lives/here/runme.sas'; end; else do; put 'VARIABLES ARE UNEQUAL'; end; run;

ijmoorejr · ‎11-28-2018

The command 'ls -1 | wc -l' returns the number of files in a given directory. It will simply return a number without timestamps or anything like that. The object is to compare the number/count of files of one directory to another.

ijmoorejr · ‎11-28-2018

I need some code examples. I am trying to pass the values of a couple of X commands to variables and then use the two values in a if-then/do. I've provided some pseudo code to help explain what I'm trying to accomplish. Thanks. x 'cd /home/unix/dir/one'; x 'ls -1 | wc -l'; x 'cd /home/unix/dir/two'; x 'ls -1 | wc -l'; if results of first piped command = results of second piped command then do; x 'sas runsasprog.sas'; end; else send email;

ijmoorejr · ‎11-14-2018

Additionally, I walked through the code that leads up to the final dataset that gets used with the ods tagsets excelxp to make the .xls. There are several joins along the way and this particular loan number field has a length of $16. from one source and a length of $20. Could the varying lengths be causing the problem with the dropping of the leading zeroes?

ijmoorejr · ‎11-14-2018

I am using ods tagsets excelxp to create a .xls from a sas dataset. One of the fields from the input data source has length 16, format $16., and informat $16. This field has loan number values that contain a leading zero (i.e. 0123456). Ods tagsets excelxp is stripping off the leading zero resulting in (123456). I have tried several different variations of the define statement for that particular field, but nothing seems to work. Does anyone have any ideas? My goal is to keep the leading zero. define LOAN_NUM / 'LOAN_NUM' style={tagattr="format:@"} center;

ijmoorejr · ‎10-30-2018

The majority of the .ksh scripts we use in our shop that execute .sas programs, have the following line at the top: . ~/.profile So, if I want to run a .sas program straight from cron without the use of a script, I should create two different cron entries...one containing the line above and the other entry to execute the .sas code via the SAS command, correct? For example, 00 5 * * 1-5 . ~/.profile 01 5 * * 1-5 sas /complete/path/to/program/sascode.sas

Online Status	Offline
Date Last Visited	‎05-29-2023 08:53 PM

How can I save an EMiner data source locally?

Re: How can I run a .sas program from within a .ksh on SAS Viya 4 inst...

How can I run a .sas program from within a .ksh on SAS Viya 4 installe...

Programatically manipulate data objects in SAS VI

How to get correct date formats and types when outputting to Excel

Convert SAS Dates to Excel Dates Via DEFINE Statement in Proc Report

Proc Report Define Statement Help Needed

Condionally send email from SAS

Re: Executing a .sas program conditionally as part of a IF/THEN/DO/ELS...

Executing a .sas program conditionally as part of a IF/THEN/DO/ELSE/DO...

Re: Executing a .sas program via Unix crontab