About Jolly

Jolly · ‎12-16-2015

Hello, Can someone help guide me on how to obtain a Tolerance Interval in SAS 9.2 for a distrbution free or non-parametric data set? Thank you, Jeff S. O.

Jolly · ‎11-18-2015

After adding an additional proc sort statment, it appears to run correctly. I have no clue why this issue was not appearing when the individual programs were submitted and providing everything from the code, but it was a small simple fix. Thank you very much.

Jolly · ‎11-18-2015

Hey Chris, Here is the log for the program that is submitted after the first few in the BAT file. Product1 is the very first program to run and product2 is submitted after the first 3 programs. Thank you

Jolly · ‎11-18-2015

Hello, I do get several errors that I do not get when I run the programs individually. I get syntax errors and errors for macro calls of variables in which SAS says does not exist. Attached is the error document provided from the last SAS program ran in the BAT file. Also, at the start of each document I use the following code to prevent anything from carrying over: proc datasets library=work kill; run; quit; ODS _ALL_ CLOSE;

Jolly · ‎11-18-2015

Hello, I did try this, but it appeared to have made things even worse.

Jolly · ‎11-18-2015

Hello Chris, Thank you for looking into this for me. Each program is independent of the others. I had figured the kill and close statments at the beginning of each program would take care of issues from anything from the prior program being carried over.

Jolly · ‎11-18-2015

I get several errors when running the BAT file, errors that do not occur when running each program individually. I get syntax errors and errors for macros calling variable they do not exist. The following is one of 27 pages from my error search document: ERROR 76-322: Syntax error, statement will be ignored. ERROR 22-322: Syntax error, expecting one of the following: a name, ;. NOTE: The SAS System stopped processing this step because of errors. NOTE: The SAS System stopped processing this step because of errors. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, NOTE: The SAS System stopped processing this step because of errors. ERROR 22-322: Syntax error, expecting one of the following: a numeric constant, a datetime constant, a missing value, (. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 76-322: Syntax error, statement will be ignored. ERROR 22-322: Syntax error, expecting one of the following: a name, ;. NOTE: The SAS System stopped processing this step because of errors. NOTE: The SAS System stopped processing this step because of errors. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, NOTE: The SAS System stopped processing this step because of errors. ERROR 22-322: Syntax error, expecting one of the following: a numeric constant, a datetime constant, a missing value, (. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 76-322: Syntax error, statement will be ignored. ERROR 22-322: Syntax error, expecting one of the following: a name, ;. NOTE: The SAS System stopped processing this step because of errors. NOTE: The SAS System stopped processing this step because of errors. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, NOTE: The SAS System stopped processing this step because of errors. ERROR 22-322: Syntax error, expecting one of the following: a numeric constant, a datetime constant, a missing value, (. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 76-322: Syntax error, statement will be ignored. ERROR 22-322: Syntax error, expecting one of the following: a name, ;. NOTE: The SAS System stopped processing this step because of errors. NOTE: The SAS System stopped processing this step because of errors. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, NOTE: The SAS System stopped processing this step because of errors. ERROR 22-322: Syntax error, expecting one of the following: a numeric constant, a datetime constant, a missing value, (. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 76-322: Syntax error, statement will be ignored. ERROR 22-322: Syntax error, expecting one of the following: a name, ;. NOTE: The SAS System stopped processing this step because of errors. NOTE: The SAS System stopped processing this step because of errors. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, Also, I have the following code at the beginning of each program to close out any open files and to delete any data sets: proc datasets library=work kill; run; quit; ODS _ALL_ CLOSE;

Jolly · ‎11-18-2015

Hello, I have a SAS batch file in which I am trying to run multiple SAS programs (9.2) through a task scheduler. The BAT file does run, however the SAS programs are not running correctly. Some of the programs only provide output for 5 of 50 charts, but if I run the program individually it runs perfect. I am using ODS output to multiple file locations. The following is the current SAS BAT file: start/w C:\"Program Files"\SAS\SASFoundation\9.2\sas.exe -log "G:\QA\QA Metrics\Data Trending\Logs\Product1.log" -sysin "G:\QA\QA Metrics\Data Trending\Product1.sas" start/w C:\"Program Files"\SAS\SASFoundation\9.2\sas.exe -log "G:\QA\QA Metrics\Data Trending\Logs\Product2.log" -sysin "G:\QA\QA Metrics\Data Trending\Product2.sas" start/w C:\"Program Files"\SAS\SASFoundation\9.2\sas.exe -log "G:\QA\QA Metrics\Data Trending\Logs\Product3.log" -sysin "G:\QA\QA Metrics\Data Trending\Product3.sas" start/w C:\"Program Files"\SAS\SASFoundation\9.2\sas.exe -log "G:\QA\QA Metrics\Data Trending\Logs\Product4.log" -sysin "G:\QA\QA Metrics\Data Trending\Product4.sas" start/w C:\"Program Files"\SAS\SASFoundation\9.2\sas.exe -log "G:\QA\QA Metrics\Data Trending\Logs\Product5.log" -sysin "G:\QA\QA Metrics\Data Trending\Product5.sas" start/w C:\"Program Files"\SAS\SASFoundation\9.2\sas.exe -log "G:\QA\QA Metrics\Data Trending\Logs\Product6.log" -sysin "G:\QA\QA Metrics\Data Trending\Product6.sas" start/w C:\"Program Files"\SAS\SASFoundation\9.2\sas.exe -log "G:\QA\QA Metrics\Data Trending\Logs\Product7.log" -sysin "G:\QA\QA Metrics\Data Trending\Product7.sas" start/w C:\"Program Files"\SAS\SASFoundation\9.2\sas.exe -log "G:\QA\QA Metrics\Data Trending\Logs\ErrorSearch.log" -sysin "G:\QA\QA Metrics\Data Trending\ErrorSearch.sas" Eventually this will grow to around 100 SAS programs, that is if it will run correctly. Also, I took the time to make a giant SAS program with all of the above programs in one program. When I ran that program, it too ran properly. However, doing this makes it a little challenging to make changes to individual codes as the program will be approximately 150,000 lines long or more. The BAT file does run individual files fine. The first program in the BAT file with all SAS programs appears to run correctly too, but after that it goes downhill. Any advice/help would be greatly appreciated, Thank you, Jeff S. O.

Jolly · ‎10-15-2015

Hello and thank you for taking the time to look at this for me. I have two dataset that I am working with in SAS 9.2. I need to match by a common id (parent_id) then I need to pull the data from one data set and copy it to the other data set that has the matching parent_id. This data set also has multiple of the same parent_id for some cases, but the child_ids are unique for each and every parent. Data Have 1 parent_id child_id child_info 1 a unique_1 2 b unique_2 2 c unique_3 2 d unique_4 3 e unique_5 4 f unique_6 4 g unique_7 Data 2 Have parent_id parent_info Parent_info2 1 aa aaa 2 bb bbb 3 cc ccc 4 dd ddd Data Want Parent_id Child_id child_info parent_info parent_info2 1 a unique_1 aa aaa 2 b unique_2 bb bbb 2 c unique_3 bb bbb 2 d unique_4 bb bbb 3 e unique_5 cc ccc 4 f unique_6 dd ddd 4 g unique_7 dd ddd Guidance on this topic is greatly appreciated. Thank you, Jeff S. O,

Jolly · ‎09-23-2015

Hello, I am trying to mimic a plot from JMP in SAS. I have SAS 9.2. I am trying to get a Normal Quantile plot with the 95% confidence bands. Can someone please help me with this? Thank you, Jeff S. O.

Jolly · ‎08-25-2015

Hello, I am wanting to do a step in my program where it will fill in data from one row into another. I can better explain this by showing what I have and what I would like to get to. Have: Parent_ID PR_ID Value1 Value2 Value3 Parent_Closure 123 123 12 29 01JAN2015 123 153 45 Want: Parent_ID PR_ID Value1 Value2 Value3 Parent_Closure 123 123 12 29 01JAN2015 123 153 45 01JAN2015 Thank you, Jeff S. O.

Jolly · ‎08-25-2015

Thank you Mark, that worked great!

Jolly · ‎08-25-2015

Hello, I am seeking help into an issue that has been a major problem for one of my SAS 9.2 programs. I am importing an excel.xlsx file that has 70 columns and 10,000+ rows. For one of the columns the values are dates in excel, but when SAS imports them, they become character $16 variables (Ex. 8/27/2012 11:09). I need these dates to be read into SAS as date9. or some other date format. NOTE: SAS successfully imports some other date columns correctly with the same date format. Current import statement: PROC IMPORT OUT= WORK.data DATAFILE= "filepath" DBMS=excel REPLACE; SHEET="sheetname"; GETNAMES=YES; MIXED=YES; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; Any suggestions or direction would be great. Thank you, Jeff S. O.

Jolly · ‎04-08-2015

There was no data generated because this lot was rejected before it reached this process/test. For the first N processes I have data, but it was rejected and did not continue through the remaining processes (including this one). Thanks, Jeff S. O.

Jolly · ‎04-08-2015

Hello, I am wondering if there is a way to get the Tests=2 to 4 to signal when a data point is missing. For example, 10 data points (out of many) may consist of: Lot 7 - 9.2 Lot 8 - 9.6 Lot 9 - 10 Lot 10 - 8.8 Lot 11 - 8.6 Lot 12 - . (Missing Data Point) Lot 13 - 9.3 Lot 14 - 9.2 Lot 15 - 8.9 Lot 16 - 9.0 Lets say the mean is 8.5, which would indicate that all data present is above the mean (Test 2 = 9 consecutive data points above the mean). The reason for the missing data in this one particular test is due to the lot being rejected. So any test/process after the lot is rejected, no data will be generated. However, I am not getting the signal for Test 2 being positive. I assume this is because of the missing data point. How can this be changed to ignore the missing data point so that Test 2 is positive for the data? Thank you, Jeff S. O.

Online Status	Offline
Date Last Visited	‎08-05-2016 10:57 AM

SAS 9.4 Proc Logistic - No Deviance Table??

Re: R-Squared(Predicted)? How can you get these values in SAS 9.4

Re: R-Squared(Predicted)? How can you get these values in SAS 9.4

Re: R-Squared(Predicted)? How can you get these values in SAS 9.4

R-Squared(Predicted)? How can you get these values in SAS 9.4

Re: SAS Procedure that only outputs a Probability Plot and Test for No...

SAS Procedure that only outputs a Probability Plot and Test for Normal...

Proc Shewhart: Reading Limits data into the INSET statement for CPK, ...

Proc Reg / Proc Mixed - How do you get SAS to break down "Model" in th...

How to highlight an individual data point in a sgplot scatter plot?

Re: Proc Shewhart Tests=2 to 4 Not Working with Missing Data Point (SA...

Non-parametric Tolerance Interval in SAS 9.2

Re: SAS Batch does not run correctly, but individual programs do.

Re: SAS Batch does not run correctly, but individual programs do.

Re: SAS Batch does not run correctly, but individual programs do.

Re: SAS Batch does not run correctly, but individual programs do.

Re: SAS Batch does not run correctly, but individual programs do.

Re: SAS Batch does not run correctly, but individual programs do.

SAS Batch does not run correctly, but individual programs do.

SQL Match Few to Many (SAS 9.2)

Normal Quantile Plot with Confidence Bands

SAS 9.2 SQL: How to copy values from one row to another by matching I...

Re: SAS 9.2 Importing xlsx date as character $16

SAS 9.2 Importing xlsx date as character $16

Re: Proc Shewhart Tests=2 to 4 Not Working with Missing Data Point (SA...

Proc Shewhart Tests=2 to 4 Not Working with Missing Data Point (SAS 9....