cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
saspert
‎09-20-2023
  • 297 Posts
  • 6 Likes Given
  • 1 Solutions
  • 23 Likes Received

proc stdize errors

by Pyrite | Level 9 in Statistical Procedures
‎08-29-2011 10:27 AM
‎08-29-2011 10:27 AM
Hello, I am using Proc STDIZE for a very mundane task of identifying all numeric variables and converting their missing values to 0. However it is giving an error when there is lack of data. The original code is here - %MACRO _CONVERT_MV_TO_ZERO(DATASET); PROC STDIZE DATA=&DATASET OUT=&DATASET REPONLY MISSING=0; VAR _NUMERIC_; RUN; %MEND _CONVERT_MV_TO_ZERO; And the log file is here - SYMBOLGEN:  Macro variable DATASET resolves to SEG_TOT_COMP_PGM_TR SYMBOLGEN:  Macro variable DATASET resolves to SEG_TOT_COMP_PGM_TR MPRINT(_CONVERT_MV_TO_ZERO):   PROC STDIZE DATA=SEG_TOT_COMP_PGM_TR OUT=SEG_TOT_COMP_PGM_TR REPONLY MISSING=0; MPRINT(_CONVERT_MV_TO_ZERO):   VAR _NUMERIC_; WARNING: No numeric variables found in data set WORK.SEG_TOT_COMP_PGM_TR. MPRINT(_CONVERT_MV_TO_ZERO):   RUN; ERROR: No variables to analyze. NOTE: The SAS System stopped processing this step because of errors. NOTE: SAS set option OBS=0 and will continue to check statements. This may cause NOTE: No observations in data set. WARNING: The data set WORK.SEG_TOT_COMP_PGM_TR may be incomplete.  When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.SEG_TOT_COMP_PGM_TR was not replaced because this step was stopped. NOTE: PROCEDURE STDIZE used (Total process time):       real time           0.00 seconds       user cpu time       0.00 seconds       system cpu time     0.00 seconds       Memory                            25k       Page Faults                       4       Page Reclaims                     22       Page Swaps                        0       Voluntary Context Switches        0       Involuntary Context Switches      1       Block Input Operations            0       Block Output Operations           0       Is there an option to ignore or bypass the 'No variables to analyze' error? Thanks, saspert ... View more

Re: Number Ranges in Excel

by Pyrite | Level 9 in ODS and Base Reporting
‎08-22-2011 12:32 PM
‎08-22-2011 12:32 PM
Hi Cynthia, Thank you for the response. Just wondering if the style(column)={tagattr='Format:@'} works with excel output without using the ExcelXP Tagsets. The particular report which needs this requirement does not use tagsets. Thanks, saspert. ... View more

Re: Number Ranges in Excel

by Pyrite | Level 9 in ODS and Base Reporting
‎08-16-2011 05:46 PM
‎08-16-2011 05:46 PM
Hi Nick, I did try the single quote (see my original post). But that is not acceptable by the business because the single quote is also showing up in the report output. I am looking for a better alternative. Thank you for suggesting though. -saspert ... View more

Number Ranges in Excel

by Pyrite | Level 9 in ODS and Base Reporting
‎08-16-2011 11:24 AM
‎08-16-2011 11:24 AM
Hello, I have a requirement to display number ranges in Excel but Excel is treating them as numbers and converting them to a date format. 1-5 converted to 5-Jan 6-10 converted to 10-Jun 11-14 converted to 14-Nov The temporary workaround I put in place was to display them with a single quote between the opening double quote and 1. But the single quote also shows up on the Excel and PDF output. Is there a better way? PROC SQL; CREATE TABLE ACTION_ITEMS_BRKDN AS SELECT  PRCHSR_CD   ,PGM_NM   ,CASE    WHEN 1 <= AI_COMPLETED <= 5 THEN "'1 - 5"    WHEN 6 <= AI_COMPLETED <= 10 THEN "'6 - 10"    WHEN 11 <= AI_COMPLETED <= 14 THEN "'11 - 14"    WHEN 15 <= AI_COMPLETED THEN "15+"   END AS AI_COMP_BKT    ,COUNT(DISTINCT MEMBER_KEY_CHAR) AS MBRS_BY_AI_COMP FROM AI_COMPLETED GROUP BY   PRCHSR_CD ,PGM_NM ,AI_COMP_BKT ; QUIT; Thanks, saspert ... View more

Proc Sql Question

by Pyrite | Level 9 in SAS Programming
‎08-16-2011 10:59 AM
‎08-16-2011 10:59 AM
Thank you Reeza and Art for the feedback. ... View more

Writing Output to a Unix location

by Pyrite | Level 9 in Developers
‎08-04-2011 09:27 PM
‎08-04-2011 09:27 PM
Hello, I am researching frantically for a sample code that would write the output from a stored process to a unix location. My original stored process code is long and complex - so I started with a simple one like this: *ProcessBody; %stpbegin; ods pdf "/sasstg/.../saspert/sashelp_class.pdf"; proc print data=sashelp.class; where age=&inputage ; run; ods _all_ close; %stpend; I created this stored process in EG and also created the inputage as a required input variable in the Parameters Step. When I run it using the SP web application, I do get the output in a new IE tab. But, there is no output being generated on the unix location. Any suggestions why that would be the case? Please note that I have no access to SAS Management Console at my client's location. I reviewed some of the older threads but they are like my scenarios but not exactly identical. http://communities.sas.com/message/12277#12277 http://communities.sas.com/message/6638#6638 The reason why I am trying to redirect the output to unix rather than _webout is another long story. I have a SAS Track for that if anyone is interested to review that ( [SAS 7610623830] Report on Stored Process Server having intermittent outage issues). Please note that my current priority is to generate the output somehow in some location that can be retrieved. Thanks in Advance, saspert ... View more

Proc Sql Question

by Pyrite | Level 9 in SAS Programming
‎07-26-2011 04:48 PM
‎07-26-2011 04:48 PM
Hi, I have a sql query written by a previous programmer - PROC SQL; CREATE TABLE WORK.BASE_PGM AS SELECT  DISTINCT (COUNT (DISTINCT MEMBER_KEY_CHAR )) AS DEMO_PARTICIPATING_USERS ,PRCHSR_CD AS DEMO_PRCHSR_CODE ,CASE WHEN GDR IS NOT MISSING THEN GDR ELSE 'UNKNOWN' END AS DEMO_GDR_GROUPING ,CASE WHEN ETHNICITY IS NOT MISSING THEN ETHNICITY ELSE 'UNKNOWN' END AS DEMO_ETHN_GROUPING ,((TODAY()-DATEPART(DOB_DT))/365.25) AS DEMO_AGE ,CASE WHEN CALCULATED DEMO_AGE BETWEEN 18 AND 34.99 THEN '18 - 34' WHEN CALCULATED DEMO_AGE BETWEEN 35 AND 44.99 THEN '35 - 44' WHEN CALCULATED DEMO_AGE BETWEEN 45 AND 54.99 THEN '45 - 55' WHEN CALCULATED DEMO_AGE >= 55 AND 44.99 THEN 'OVER 55' ELSE 'UNKNOWN' END AS DEMO_AGE_GROUPING  ,PGM_NM AS PGM_NM ,OPPORTUNITY_COMPLETED AS DETAIL_OPPORTUNITY_COMPLETED ,ACTION_ITEM_RESPONSE_COMPLETED AS DETAIL_ACTION_ITEM_COMPLETED FROM F_MEMBER_PROGRAM_BASE_PGM AS F_MEMBER_PROGRAM_BASE WHERE F_MEMBER_PROGRAM_BASE.PROGRAM_ENROLLED > 0 GROUP BY PRCHSR_CD,DOB_DT,GDR; QUIT; Does anyone know if there could be performance issues with calculating the age and using it again in a case statement? The report is taking excess time and my hunch is this query is taking more time than necessary. Any thoughts/feedback will be helpful. Thanks, saspert. ... View more

How are questions changed to "Assume Answered"?

by Pyrite | Level 9 in SAS Programming
‎07-24-2011 10:54 AM
‎07-24-2011 10:54 AM
:smileygrin: I am thinking if a "correct answer" is marked then the question will be "answered" but if there are only "helpful" answers, the question is "assumed answered". Is that the correct understanding? A tool tip / note while the cursor is hovering will be helpful in explaining the difference. ... View more

Re: Writing to Oracle database using ODBC connection

by Pyrite | Level 9 in SAS Programming
‎07-22-2011 02:30 PM
‎07-22-2011 02:30 PM
From my past experience I have seen it is quite cumbersome to load Oracle using Libname statment because there is usually less control over a dataset having 1 million rows. And on the other hand using Proc SQL Pass thu will allow only 1 record to be updated at a time. Any other users who have faced similiar issues? ... View more

Re: Intelligent Sorting

by Pyrite | Level 9 in SAS Programming
‎07-22-2011 02:14 PM
‎07-22-2011 02:14 PM
Hi All, So, I am trying to use the monotonic function to build the sort order based on the specification. My code is here - DATA DEMOGRAPHICS_BASE_&VALUE._OP_SORTED; MERGE DEMOGRAPHICS_BASE_&VALUE._OP(IN=A) &VALUE._ORDER_DEMO(IN=B); BY DEMO_&VALUE._GROUPING; IF A THEN DO; /* &VALUE._SORT_ORDER=MONOTONIC();*/ OUTPUT; END; Taking a specific context of macro variable Value to be Age The values in  GDR_ORDER_DEMO are here - GDR_SORT_ORDER DEMO_GDR_GROUPING 4 All 3 Female 2 Male 1 Unkown The values in DEMOGRAPHICS_BASE_GDR_OP are here- DEMO_PRTCPTNG_USERS DEMO_GDR_GROUPING 169 All 74 Female 95 Male When I merge them, I get the right dataset but the wrong sort order (using monotonic). Without monotonic, I get 2,3,4. Hope it makes sense. Appreciate any help or any tips. saspert. ... View more

Writing to Oracle database using ODBC connection

by Pyrite | Level 9 in SAS Programming
‎07-21-2011 03:40 PM
‎07-21-2011 03:40 PM
Hi Payal, I would think this to be the syntax you can use while updating the tables in Oracle - PROC SQL; *replace lowercase font with your tables/connection info CONNECT TO myconn (USER =oracleuserid PASSWORD=oraclepw  PATH=oraclepath); CREATE TABLE TEST AS AS SELECT * FROM myconn      ( UPDATE schema_name.table_name alias SET alias.column1=value, alias.column2=value2,... WHERE alias.some_column=some_value ); DISCONNECT FROM myconn; QUIT; However, it has been some time since I have tried an UPDATE (since you are asking about writing to the database). So, please always check with your local admin. Also, I am not sure if the syntax is different for 9.1.3 vs 9.1. Thanks, saspert. ... View more

Intelligent Sorting

by Pyrite | Level 9 in SAS Programming
‎07-21-2011 11:52 AM
‎07-21-2011 11:52 AM
Ah! Good question. I think I told only half the story. So I need to merge it with 2 other datasets. So it could be something like this - Ethnicity   Count Order  Age       Count Order  Gender    Count  Order Caucasian  10     1        18-34      11         1     Male       29      1 All            15       2         45-54      36         2   All           35      2                                         All      66        3      The final proc report needs to show it like the table above but my original sort order are below -  1 Unknown 2 18 - 34 3 35 - 44 4 45 - 54 5 Over 55 6 All Does that help? Appreciate your help very much. saspert        1 Unkown 2 Male 3 Female 4 All ... View more

Intelligent Sorting

by Pyrite | Level 9 in SAS Programming
‎07-21-2011 11:31 AM
‎07-21-2011 11:31 AM
Hi, I am merging 2 datasets A and B. A is a lookup dataset with a specific sort order assigned to each category. B is a summary dataset with values assigned to some categories but not the entire list of categoies. A                                   Ethnicity                          Order Asian                                   1 Caucasian                             2 African American                   3 Unkown                                 4 All                                        5 B Ethnicity      Count All                  15 Caucasian     10 I need the output dataset to be sorted intelligently. Because there are no other values, the sort order should be just 1 and 2. C Ethnicity  Count  Order Caucasian  10      1 All             15       2 If this is familiar, can someone point out older discussion threads. Thanks, saspert. ... View more

Re: Macro errors

by Pyrite | Level 9 in SAS Programming
‎07-19-2011 11:23 AM
‎07-19-2011 11:23 AM
Hi Art, When I try %scan instead of %qscan, all the errors were resolved. I guess the original code was trying to parse through AGE,GDR,ETHN and had a qscan for that reason. But, when I adapted that code in my EG project, I took out the commas but did not change the %qscan to %scan. Does that sound like the root cause? Appreciate your tip very much. But to answer your question, your original suggestion of putting the quotes did not help. Hi Doc, I looked at the code again. What you pointed was a definitely a bug. But when I am reviewing the code now , it looks as if that is taken care of.  Thank you very much. Tom,Art, Doc - appreciate all the help guys. Regards, saspert ... View more

Re: Macro errors

by Pyrite | Level 9 in SAS Programming
‎07-19-2011 10:35 AM
‎07-19-2011 10:35 AM
Hi Tom, If I understand you correctly, you want to check the SQL query and see if it runs properly (outside of the macro). Is that correct? 14 PROC SQL; 15 CREATE TABLE DEMOGRAPHICS_BASE_AGE AS 16 (SELECT (COUNT ( DEMOGRAPHICS_BASE.DEMO_PARTICIPATING_USERS)) AS DEMO_PRTCPTNG_USERS 17 ,DEMOGRAPHICS_BASE.DEMO_AGE_GROUPING 18 FROM WORK.DEMOGRAPHICS_BASE AS DEMOGRAPHICS_BASE 19 INNER JOIN WORK.DEMOGRAPHICS_BASE_100 AS DEMOGRAPHICS_BASE_100 ON (DEMOGRAPHICS_BASE.DEMO_PRCHSR_CODE = 19 ! DEMOGRAPHICS_BASE_100.DEMO_PRCHSR_CODE) 20 GROUP BY DEMOGRAPHICS_BASE.DEMO_AGE_GROUPING 21 ); NOTE: Table WORK.DEMOGRAPHICS_BASE_AGE created, with 4 rows and 2 columns. 22 QUIT; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds Memory 1560k Page Faults 0 Page Reclaims 330 Page Swaps 0 Voluntary Context Switches 4 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 0 Thanks, saspert ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-20-2023 12:34 PM
Likes given to
Quick links