About skallamp

skallamp · ‎04-03-2012

Thanks Haikuo. What if the date is in 2011-01-31 format?

skallamp · ‎04-03-2012

Hi Hai.kuo, I have received another input file where date of fill is on 01Jan2011 format. What are the changes I have to make in this code if I get different date format? I am using EG to import the file and making the date field as number. Is this correct? Thanks, +Sathyan

skallamp · ‎04-03-2012

Hi, I am not able to import the attached file using SAS EG. This is a comma seperated file and I gave this option while importing. However, it is not delimiting properly. Can some one please help me to get the code for importing this file. Sample file attached with this. Thanks, +Sathyan

skallamp · ‎03-30-2012

Hi Art, I have attached the input file in excel. Please refer "dateoffill" field which is in yyyymmdd format. I am still not able to split this as I am getting the error as type mismatch... Could you please help me to figure this out?

skallamp · ‎03-29-2012

My error is b'cse of this statement. Temp output has blank value for month...my rx_date format is yyyymmdd format month=catx( ),year(rx_date));

skallamp · ‎03-29-2012

Hi This is what I am using...still i m getting error data temp; set claim_detail; month=catx('_',put(rx_date,monname3.),year(rx_date)); run; proc sort data=temp; by month; run; proc sql noprint; select quote(name) into :vars separated by ',' from dictionary.columns where libname="WORK" and memname="NEED" and name ne "month" ; quit; data _null_ ; dcl hash hh () ; hh.definekey ('k') ; hh.definedata (&vars.) ; hh.definedone () ; do k = 1 by 1 until ( last.month ) ; set temp ; by month; hh.add () ; end ; hh.output (dataset: month) ; run ;

skallamp · ‎03-29-2012

Hi Art, Its giving me the below error. 36 dcl hash hh () ; 37 hh.definekey ('k') ; 38 hh.definedata (&vars.) ; _ 386 200 76 WARNING: Apparent symbolic reference VARS not resolved. ERROR 386-185: Expecting an arithmetic expression. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 76-322: Syntax error, statement will be ignored. 39 hh.definedone () ; ERROR: DATA STEP Component Object failure. Aborted during the COMPILATION phase. NOTE: The SAS System stopped processing this step because of errors.

skallamp · ‎03-29-2012

My Variables are keep changing from one work to another. Is there a way I can add all variables using a simple statement? somethin like *..

skallamp · ‎03-29-2012

If I have more variables, how do I put everything with out typing it one by one. Here hh.definedata('rx_date') is giving me only one variable. I need all of them which is present in my data set.

skallamp · ‎03-29-2012

Thanks for the thoughts. I am getting the below error while applying it to my data. 15 data _null_ ; 16 dcl hash hh () ; 17 hh.definekey ('k') ; 18 hh.definedata ('RX_DATE','no') ; 19 hh.definedone () ; 20 do k = 1 by 1 until ( last.RX_DATE ) ; 21 set date ; 22 by rx_date groupformat ; 23 format rx_date monyy.; 24 hh.add () ; 25 end ; 26 hh.output(dataset: put(rx_date,monyy5.)) ; 27 run ; ERROR: Undeclared data symbol no for hash object at line 19 column 3. ERROR: DATA STEP Component Object failure. Aborted during the EXECUTION phase.

skallamp · ‎03-28-2012

Hi, Could you please help me to split the data in to multiple data sets based on the Year and month. For e.g My input data contains two year data, I want to split it in to 24 small data sets based on the month and year. I used the below query to get month and year. data set claim_file informat x_date date8. format x_date date8. M = month(x_date) Y = year(x_date) run Out put should have a data set name like Jan_2011, Feb_2011 etc.. Please help. Thanks.

skallamp · ‎10-14-2011

Hi, I am getting an error while calling the macro funcion in my proc SQL. This query is working fine when i remove the &MAC_Markup_Value. part. Can someone please help me to understand the error message and help me to resolve this. %Let MAC_Markup_Value = 1.18; PROC SQL; CREATE TABLE Claims_Join AS SELECT t1.*, t2.type, t2.gpi, t2.macunitcost_num, t2.Specialty_Ind, macunitcost_num * qty * &MAC_Markup_Value. as MAC FROM WORK.MAHEC_Claims AS t1 LEFT JOIN WORK.SPECIALTY AS t2 ON (t1.ndc = t2.NDC) ; QUIT; Error Message ~~~~~~~~~~~~~~ WARNING: Apparent symbolic reference MAC_MARKUP_VALUE not resolved. 23 macunitcost_num * qty * &MAC_Markup_Value. as MAC ___ 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER. ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, AS, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.

skallamp · ‎10-05-2011

Thanks a lot Art297.

skallamp · ‎10-04-2011

ERROR 388-185: Expecting an arithmetic operator. Is there any syntax error here? data Claims_final; set Claims_Join; MAC = macunitcost_num * qty_disp; format Ingrediant_Cost 15.5 Final_ING_Cost 15.5; if retail90_30 = 'Retail 30'and Type = 'Brand' then Ingrediant_Cost = Pre_AWP*(1-(&Retail_30_B.)); else if retail90_30 = 'Retail 30' and Type = 'Generic' and MAC = . then Ingrediant_Cost = Pre_AWP*(1-(&Retail_30_G.)); else if type = 'Generic' and MAC <> . then Ingrediant_Cost = MAC; else if retail90_30 = 'Retail 90'and Type = 'Brand' then Ingrediant_Cost = Pre_AWP*(1-(&Retail_90_B.)); else if retail90_30 = 'Retail 90' and Type = 'Generic' and MAC = . then Ingrediant_Cost = Pre_AWP*(1-(&Retail_90_G.)); else specialty_ind = 'Y' then Ingrediant_Cost = Pre_AWP*(1-(&Specialty_Disc.)); Final_ING_Cost = min(U_and_C, Ingrediant_Costpe); run;

skallamp · ‎10-04-2011

Can someone please help me to fix this macro issue? I cant find anything from the log file... %LEt Retail_30_B = .165; %Let Retail_30_G = .165; %Let Retail_30_B_DF = 1; %Let Retail_30_G_DF = 1; %LEt Retail_90_B = .165; %Let Retail_90_G = .165; %Let Retail_90_B_DF = 1; %Let Retail_90_G_DF = 1; %Let Mail_B = .25; %Let Mail_G = .73; %Let MAil_B_DF = 0; %Let Mail_G_DF = 0; %Let Specialty_Disc = .17; %Let Specialty_DF = 0; data final; set Claims_Join; MAC = macunitcost_num * qty_disp; format Ingrediant_Cost 15.5 Final_ING_Cost 15.5; if retail90_30 = 'Retail 30'and Type = 'Brand' then Ingrediant_Cost = Pre_AWP*(1-(&Retail_30_B.)); else if retail90_30 = 'Retail 30' and type = 'Generic' and MAC = . then Ingrediant_Cost = Pre_AWP*(1-(&Retail_30_G.)); else if type = 'Generic' and MAC <> . then Ingrediant_Cost = MAC; else if retail90_30 = 'Retail 90'and Type = 'Brand' then Ingrediant_Cost = Pre_AWP*(1-(&Retail_90_B.)); else if retail90_30 = 'Retail 90' and type = 'Generic' and MAC = . then Ingrediant_Cost = Pre_AWP*(1-(&Retail_90_G.)); else specialty_ind = 'Y' then Ingrediant_Cost = Pre_AWP*(1-(&Specialty_Disc.)); Final_ING_Cost = min(U_and_C, Ingrediant_Costpe); run;

Online Status	Offline
Date Last Visited	‎10-03-2016 12:17 PM

Re: Replacing missing values

Replacing missing values

SAS Date Function

Re: Finding New Customers on a monthly basis

Finding New Customers on a monthly basis

How do I do a Summary and Count together?

SAS Rolling total or average

PROC Discriminant Error

SAS Add in for Microsoft Excel - How to link with SAS code

ERROR: ORACLE execute error: ORA-01830: date format picture ends befor...

Re: SAS Date Function

Re: SAS Date Function

Data step : Split data sets according to month

Data step : Split data sets according to month

SAS EG : Error while Importing the file

Data step : Split data sets according to month

Data step : Split data sets according to month

Data step : Split data sets according to month

Data step : Split data sets according to month

Data step : Split data sets according to month

Data step : Split data sets according to month

Data step : Split data sets according to month

Data step : Split data sets according to month

Macro error while calling the macro function

Macro Question

Macro Question

Macro Question