About sayanapex06

sayanapex06 · ‎08-22-2018

Yes this is one of the ways we can do.. But I wanna do it with either CNTLIN /CNTLOUT

sayanapex06 · ‎08-22-2018

I need it to generalize and shorten a huge process. You are correct even with CNTLOUT, I didnt get the desired format. So could you suggest, how I can try build a format from a SAS dataset in the desired proc format. Thanks, Sayan

sayanapex06 · ‎08-22-2018

I have the following code : DATA XXX ; LENGTH CC $2. FLG $1. ; INFILE DATALINES DLM = '~' ; INPUT @1 CC FLG ; DATALINES ; AB~Y BC~N CD~Y DF~N TY~N ; DATA CREATE_FORMAT ; RETAIN FMTNAME 'TESTFR' TYPE 'C' ; SET XXX END=EOF ; START = CC ; LABEL = FLG ; OUTPUT ; IF EOF ; /* ON LAST RECORD */ HLO = 'O' ; LABEL = 'X' ; OUTPUT ; RUN ; LIBNAME LIBRARY '/sas/data/DEV_TEST/SAYAN_TEST/' ; PROC FORMAT LIBRARY = LIBRARY CNTLIN = CREATE_FORMAT ; RUN ; I am not getting the desired output which should look like : PROC FORMAT ; VALUE $TESTFR 'AB' = 'Y' ...........(etc) I am getting it in binary form. Pleas help me with getting the desired output. Thanks, Sayan

sayanapex06 · ‎05-29-2018

Thanks a lot Cynthia for the support. I chose to use Proc report instead, as Proc Tabulate was not able to meet my needs. PROC REPORT DATA = REPORT_ALL NOFS HEADLINE HEADSKIP STYLE (REPORT) = [FRAME = BOX] ; TITLE1 "##############################################################" ; TITLE2 "## DIVESTIT : REPORT OF ALL SSO IDS TODAY ##" ; TITLE3 "##############################################################" ; COLUMN DESCRIPTION SSO BUC ADN COUNT ; DEFINE DESCRIPTION / GROUP WIDTH=100 ; DEFINE SSO / ORDER WIDTH=10 ; DEFINE BUC / DISPLAY WIDTH=6 ; DEFINE ADN / DISPLAY WIDTH=75 ; DEFINE COUNT / ANALYSIS SUM WIDTH=20 'COUNT FOR BUC/ADN' ; BREAK AFTER DESCRIPTION / OL UL SKIP SUMMARIZE SUPPRESS ; RBREAK AFTER / DOL DUL SKIP SUMMARIZE ; COMPUTE AFTER ; TYPE = 'TOTAL' ; ENDCOMP ; RUN ; The code I used is above : The output I got is : attached I want : where the 17 is calculated, something to add a comment as 'total of all' . COuld you help me with this.

sayanapex06 · ‎05-24-2018

No value is getting excluded.. I want the table COLUMNS to be like : Description Sso BUC ADN COUNT(SSO) TOTAL COUNT

sayanapex06 · ‎05-24-2018

Hi All, I need an help creating the following table : SSO BUC ADN Count for BUC/ADN Grand Total SSOs Not Actioned because they are Duplicated in the Input File 2 100001155 SM0032 3465210101243WCVE56 100001155 SM0300 3465210101243WCVE56 with variables as description = SSOs Not Actioned because they are Duplicated in the Input File sso buc ADN and count Please help me in doing it. So far the code I used : PROC TABULATE DATA = REPORT_ALL MISSING F=3. S=[CELLWIDTH=3000 JUST=C]; KEYLEVEL SUM = ' ' ; CLASS DESCRIPTION SSO BUC ADN ; VAR COUNT ; TABLES DESCRIPTION=' ' ALL ='TOTAL', (SSO=' ')*(BUC ADN COUNT) /BOX = "REPORT ON THE NUMBER OF SSO_IDs FOR EACH CATEGORY AS FOLLOWS :" ; Its not coming in the format required. And I cannot use more than three dimensions for a table. Please help with the correct way. Would be thankful, Sayan

sayanapex06 · ‎03-19-2018

Hi , I have a SAS Dataset names Cloudability. I am performing this query on the dataset : PROC SQL ; CREATE TABLE CLOUD_FINAL_PREM_SUP_NONPDX AS SELECT BUSINESS_UNIT,PAYERACCOUNTID,LINKEDACCOUNTID,ACCOUNTNAME, ( (SUM(VENDOR_COST_OF_SERVICE)/TOTAL_COST_NONPREDIX) * (AWS_PREMIUM_SUPPORT - PREMIUM_SUPPORT_PREDIX) ) AS PREMIUM_SUPPORT FROM CLOUDABILITY WHERE TOTAL_COST_NONPREDIX IN ( SELECT SUM(VENDOR_COST_OF_SERVICE) AS TOTAL_COST_NONPREDIX FROM CLOUDABILITY WHERE BUSINESS_UNIT NOT IN ('PREDIX') AND PRODUCTNAME NOT IN ('AWS PREMIUM SUPPORT') ) AND AWS_PREMIUM_SUPPORT IN ( SELECT SUM(VENDOR_COST_OF_SERVICE) AS AWS_PREMIUM_SUPPORT FROM CLOUDABILITY WHERE PRODUCTNAME IN ('AWS PREMIUM SUPPORT') ) AND PREMIUM_SUPPORT_PREDIX IN ( SELECT SUM(VENDOR_COST_OF_SERVICE) AS PREMIUM_SUPPORT_PREDIX FROM CLOUDABILITY WHERE BUSINESS_UNIT NOT IN ('PREDIX') ) AND BUSINESS_UNIT NOT IN ('PREDIX') AND PRODUCTNAME NOT IN ('AWS PREMIUM SUPPORT') GROUP BY BUSINESS_UNIT,PAYERACCOUNTID,LINKEDACCOUNTID,ACCOUNTNAME ; QUIT ; And I am getting an error : ERROR: The following columns were not found in the contributing tables:AWS_PREMIUM_SUPPORT, PREMIUM_SUPPORT_PREDIX, TOTAL_COST_NONPREDIX Please help me with this

sayanapex06 · ‎02-13-2018

Here is my code : %LET T_DATA = 'NBKUP' ; %LET INDTE = '02/11/2017' ; %LET INCLS = 'YES' ; %PUT 'SAYANX :' &T_DATA &INDTE &INCLS ; libname dwmdb oracle user = 'idsdba01' password = 'imag1ne' path = 'GQDWD_DEV'; /* DEV */ proc sql; CREATE TABLE BACKUP1 as (select * from dwmdb.t_compute_tx_tbl where TYPE_OF_DATA = "&T_DATA" and INPUT_DATE = "&INDTE" and INCLUDE_STATUS = "&INCLS" ) ; quit; proc sql; CREATE TABLE BACKUP2 as ( select * from dwmdb.t_compute_tx_tbl where TYPE_OF_DATA = 'NBKUP' and INPUT_DATE = '02/11/2017' and INCLUDE_STATUS = 'YES' ) ; quit; SASLOG : NOTE: SAS initialization used: real time 0.02 seconds cpu time 0.01 seconds 1 2 %LET T_DATA = 'NBKUP' ; 3 %LET INDTE = '02/11/2017' ; 4 %LET INCLS = 'YES' ; 5 6 %PUT 'SAYANX :' &T_DATA &INDTE &INCLS ; 'SAYANX :' 'NBKUP' '02/11/2017' 'YES' 7 8 9 10 11 libname dwmdb oracle user = 'idsdba01' password = XXXXXXXXX path = 'GQDWD_DEV'; NOTE: Libref DWMDB was successfully assigned as follows: Engine: ORACLE Physical Name: GQDWD_DEV 11 ! /* DEV */ 12 13 14 15 proc sql; 16 CREATE TABLE BACKUP1 as 17 18 (select * from dwmdb.t_compute_tx_tbl 19 where TYPE_OF_DATA = "&T_DATA" 2 The SAS System 09:45 Tuesday, February 13, 2018 20 and INPUT_DATE = "&INDTE" 21 and INCLUDE_STATUS = "&INCLS" ) ; NOTE: Table WORK.BACKUP1 created, with 0 rows and 35 columns. 22 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.98 seconds cpu time 0.05 seconds 23 24 25 26 proc sql; 27 CREATE TABLE BACKUP2 as 28 29 ( select * from dwmdb.t_compute_tx_tbl 30 where TYPE_OF_DATA = 'NBKUP' 31 and INPUT_DATE = '02/11/2017' 32 and INCLUDE_STATUS = 'YES' ) ; NOTE: Table WORK.BACKUP2 created, with 42077 rows and 35 columns. 33 quit; NOTE: PROCEDURE SQL used (Total process time): real time 6.92 seconds cpu time 0.81 seconds 34 NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 8.30 seconds cpu time 0.92 seconds I want to know why the first query is not fetching any records, and the second query being same(hard-coded) fetches records ?

sayanapex06 · ‎02-12-2018

Hi I have a requirement to check : first date of the current month & last month's first date +1 So today's date is : 2/12/2018 I want the first range as : 02/01/2018 ( 2nd jan 2018) second range : 01/02/2018 (1st of feb 2018) I have tried : %LET PRE_MO = %SYSFUNC(INTNX(MONTH, %SYSFUNC(&CURR), -1),DATE9.) ; I am getting PRE_MO AS : 01JAN2018 , but I want it be increased by 1 I am trying : R = INTNX(('MONTH',AEENDTC1,0,"BEGINNING")),DATE9. ; ( to get the first day of this month) But error shows : R = INTNX(('MONTH',AEENDTC1,0,"BEGINNING")),DATE9. ; _ _ _ _ _ _ 79 22 79 22 79 22 _ _ _ 200 200 200 : Expecting a ).

sayanapex06 · ‎02-06-2018

Billing_year_month is a field in a oracle database and we are establishing the conncection to it it should have values in 'yyyy-mm' I am getting the yyyy-mm from code how to get it in Billing_year_month ?

sayanapex06 · ‎02-06-2018

************************************************************************************** ; %LET CURR = TODAY() ; %LET PREMO = %SYSFUNC(INTNX(MONTH, %SYSFUNC(&CURR), -1), YYMMD.); %LET PRPREMO = %SYSFUNC(INTNX(MONTH, %SYSFUNC(&CURR), -2), YYMMD.); %LET CURRMO = %SYSFUNC(TODAY(),YYMMD.) ; ************************************************************************************** ; CREATE TABLE TOTDTL_CURRMO AS (SELECT BILLING_YEAR_MONTH, SERVICE_TYPE, DESCRIPTION10_TO_IBS, BILLING_SERVICE, COMP_CODE, REFUND_MONTH, COST_OF_SERVICE, UNITS, TAX FROM mydblib.t_other_detail_internal WHERE BILLING_YEAR_MONTH = "&CURRMO"); QUIT ; NOTE: Table WORK.TOTDTL_CURRMO created, with 0 rows and 9 columns. &CURRMO is supposed to have 2018-02 but the value isn't getting in BILLING_YEAR_MONTH . Could you please help me with this

sayanapex06 · ‎02-06-2018

I coded the following : DATA TEST ; C_MONTH = MONTH(TODAY()) ; C_YEAR = YEAR(TODAY()) ; P_MONTH =%SYSFUNC(MONTH(%SYSFUNC(INTNX(MONTH, %SYSFUNC(TODAY()), -1)))); P_YEAR =%SYSFUNC(YEAR(%SYSFUNC(INTNX(MONTH, %SYSFUNC(TODAY()), -1)))); PROC PRINT DATA = TEST ; got the output as : C_MONTH C_YEAR P_MONTH P_YEAR 2 2018 1 2018 Now what to do if I want a P_P_MONTH (previous of the previous month) and P_P_YEAR P_P_MONTH has to be 12 P_P_YEAR has to be 2017 Please help me with the above

sayanapex06 · ‎02-05-2018

So the current date is 05FEB2018 what will happen if I use this Curr02 = intx('month', currd, -2) What will be the value of curr02?

sayanapex06 · ‎02-05-2018

Hi Reeza, No I didnt. Could you please help me with the intx function over this issue?

sayanapex06 · ‎02-05-2018

Hi everyone, I need to find the syntax for sas (year-month) Suppose I code : Curr = put(today, mmyyd.) ; I will be getting Curr = 02-2018 Now my question is, I need from the sas date function Curr01 = 12-2017 Curr02 = 11-2017 Curr01 being the previous month and year Curr02 beung the previous of the previous month Could you please help me with this function, so that even if I am in the middle of the year, I can get a month - 1 and month - 2 with a single code? Thanks, Sayan

Online Status	Offline
Date Last Visited	‎08-27-2018 06:09 AM

Re: Build a format from a SAS data set and write it to a text file

Re: BUILD FORMAT FROM SAS DATASET AND WRITE IT TO A TEXT FILE

Build a format from a SAS data set and write it to a text file

Re: PROC TABULATE

Re: PROC TABULATE

PROC TABULATE

Proc SQL SAS : working with multiple queries

Global Variable not referenced

first date of the current month & last month's first date +1

Re: Macro value not getting referred

Re: read a dataset within a dataset

Re: read a dataset within a dataset

Re: Build a format from a SAS data set and write it to a text file

Re: BUILD FORMAT FROM SAS DATASET AND WRITE IT TO A TEXT FILE

Build a format from a SAS data set and write it to a text file

Re: PROC TABULATE

Re: PROC TABULATE

PROC TABULATE

Proc SQL SAS : working with multiple queries

Global Variable not referenced

first date of the current month & last month's first date +1

Re: Macro value not getting referred

Macro value not getting referred

Re: Sas current year-month, previous year-month

Re: Sas current year-month, previous year-month

Re: Sas current year-month, previous year-month

Sas current year-month, previous year-month