About cho16

cho16 · ‎10-04-2016

Hi, I have the field name called CIN and CLIENT_ID. If the program type as “E” then the ID formatted XX12345X, should be sent in the CIN field instead of CLIENT_ID If the program type as “E” then the ID formatted 70017001, should be sent in the CLIENT_ID field instead of CIN. CIN : 8 alpha numeric (ex.XX02345X) CLIENT_ID: 8 numeric (ex.70005234) Program type CLIENT_ID CIN Membno E NF01984Y 42500000 E AB09099Y 43567899 E 70017984 56798000 Need to show as below values: Program type CLIENT_ID CIN Membno E NF01984Y 42500000 E AB09099Y 43567899 E 70017984 56798000 Thanks in Advance

cho16 · ‎09-26-2016

Thanks Reeza ! But how to export more than 2 million of records by using proc export. The query succeds in the window but when i try to open the file it shows the "file was not load completely". Could you please let me know how to resolve this ?

cho16 · ‎09-26-2016

Sorry i am trying to export the file to CSV file proc export data=NEW_ENROLLMENT dbms=xlsx outfile="\\HFNT63\devl\web\NSLIJ_testing\NEW_ENROLLMENT.csv" dbms=csv replace; run;

cho16 · ‎09-26-2016

Hi I need to export the SAS dataset that has more than 1 million records (1,120,897) and 35 columns to the .CSV file. But while exporting the dataset , all the rows are not exported. Could you please let me know how can i export all the rows to the .CSV file ? proc export data=NEW dbms=xlsx outfile="\\HFNT63\devl\web\NSLIJ_testing\NEW_ENROLLMENT.xlsx" replace; run; Thanks

cho16 · ‎08-25-2016

Hi , We have a table1 which contains marketname ,year fields that has the data from the year 2014 to 2016. Currently we are pulling data from table1 for the year 2016. While we join with this table 1 to get marketname for 2016 and its not matching. But if there is no matching, please match by previous year names table, if still not, use previous previous year For example, if 2016 name not match, then use 2015, if still not, use 2014. Please let me know how to go back for previous years and get the names. Code: proc sql; create table QHPNOTEPtable_1 as select Q.*,M.market_name from QHPNOTEPtable Q left join table1 M ON Q.grPnum= M.group_ID; quit;

cho16 · ‎07-13-2016

Thank You ! the logic works perfectly

cho16 · ‎07-13-2016

Hi Team, I have a first dataset that has the member number, groupnum , benpkg and other fields. In the second table also i have the group_id, benpkg and other fields ( seperated as two tables based on the group_id as EP_IN and second table as EP_NOTIN) We need to use the below condition: 1. If group_ID includes “EP”, ie like “EP$”, which means that it’s a EP plan, then we need to join on both grpnum= names.group_ID and benpkg=names.Benefit_Package_ID, both grpnum and benpkg are in the members tables 2. If it’s not a EP plan, then we only need to join on grpnum= names.group_Id. 3. Please use left join, so that we will still keep the records if there is no matching at names table My logic: proc sql ; create table new_members_detail_fl_3 as select M.*,E.Benefit_Package_Name,E.Group_ID from new_members_detail_fl_2 M left join EP_IN E on M.grpnum=E.group_ID and M.benpkg=E.Benefit_Package_ID; quit; proc sql ; create table new_members_detail_fl_4 as select M.*, E.Benefit_Package_Name,E.Group_ID from new_members_detail_fl_2 M left join EP_NOTIN E on M.grPnum=E.group_ID; Can you please let me know how to implement this join condition in the single data step instead of twice. quit;

cho16 · ‎05-05-2016

Hi Quentin, %put &end3month &start3mnth ; /* 31AUG2015 01AUG2015 */

cho16 · ‎05-05-2016

Hi Team, I am trying to run the below macro code and it gives an error. I couldnt figure out the error. Could you please help me %macro roster; proc sql; create table NON_RESPONDERS_BULLET_7_P as select t1.* from DSS_HRA_Healthfirst_Roster t1 where (t1.EFFECTIVE_DATE < intnx('year',today(),-1,'S') OR t1.EFFECTIVE_DATE > intnx('year',today(),-1,'E')) and (t1.PRODUCT_PBP CONTAINS 'LIP1' OR t1.PRODUCT_PBP CONTAINS 'MAX1') and ((t1.LAST_SURVEY_DATE1 BETWEEN intnx('year',&start3mnth,-15) and intnx('year',&end3month,-15)) %do i = -14 %to -2; or (t1.LAST_SURVEY_DATE1 BETWEEN intnx('year',&start3mnth,&i) and intnx('year',&end3month,&i)) %end; or (t1.LAST_SURVEY_DATE1 BETWEEN intnx('year',&start3mnth,&i) and intnx('year',&end3month,&i))); quit; %mend roster; %roster ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.

cho16 · ‎05-05-2016

Hi Team, I am trying to run the below macro code and it gives an error. I couldnt figure out the error. Could you please help me %macro roster; proc sql; create table NON_RESPONDERS_BULLET_7_P as select t1.* from DSS_HRA_Healthfirst_Roster t1 where (t1.EFFECTIVE_DATE < intnx('year',today(),-1,'S') OR t1.EFFECTIVE_DATE > intnx('year',today(),-1,'E')) and (t1.PRODUCT_PBP CONTAINS 'LIP1' OR t1.PRODUCT_PBP CONTAINS 'MAX1') and ((t1.LAST_SURVEY_DATE1 BETWEEN intnx('year',&start3mnth,-15) and intnx('year',&end3month,-15)) %do i = -14 %to -2; or (t1.LAST_SURVEY_DATE1 BETWEEN intnx('year',&start3mnth,&i) and intnx('year',&end3month,&i)) %end; or (t1.LAST_SURVEY_DATE1 BETWEEN intnx('year',&start3mnth,&i) and intnx('year',&end3month,&i))); quit; %mend roster; %roster ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. Thanks

cho16 · ‎04-28-2016

Thanks ! But it should be automated for every month .If it runs for next month then it should be August.

cho16 · ‎04-28-2016

Hi, I want to create a macro variable for last year and the month should be July(current month + 3) . For example : it should be display as 01JUL2015 I have tried the below. data _null_; call symput('previous_year',put(intnx('month',today(),),intnx('year',today(), -1, 'S'),0,'B'),date9.)); run; %put &previous_year ; 01APR2015 Please let me know. Thanks

cho16 · ‎04-13-2016

Tried the below code and it worked well data want (drop=LAST_SURVEY_DATE1); set have; format LAST_SURVEY_DATE mmddyy10.; LAST_SURVEY_DATE = input(LAST_SURVEY_DATE1, ?? yymmdd10.); run; Thanks for all your responses.

cho16 · ‎04-13-2016

Thanks PG. How can we incorporate the Last_survey_date macro in the code ?Thanks sday = 01 dmth should be current month +3 ( July) ayr should be current year -2 ( from 2000 to 2014) (LAST_SURVEY_DATE >= "&sday&&dmth&&ayr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&ayr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&byr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&byr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&cyr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&cyr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&dyr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&dyr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&eyr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&eyr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&fyr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&fyr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&gyr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&gyr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&hyr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&hyr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&iyr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&iyr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&jyr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&jyr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&kyr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&kyr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&lyr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&lyr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&myr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&myr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&nyr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&nyr"D) OR (LAST_SURVEY_DATE >= "&sday&&dmth&&oyr"D AND LAST_SURVEY_DATE <= "&lday&&dmth&&oyr"D)

cho16 · ‎04-13-2016

Hi Reeza, Yes the field has missing values Attached the screen shot for your reference.

Online Status	Offline
Date Last Visited	‎10-09-2024 03:21 PM

Splitting one column values into seven columns

Proc report formatting issue

proc report formatting issue

Date logic error

Proc export —keeping files for limited days option

Select a first observations from the data

Re: Select first records from the dataset

Re: Select first records from the dataset

Select first records from the dataset

Re: need to read text file has zero

Re: Select first records from the dataset

Re: Delete a multiple values in a variable

Re: Help with Date macro

Re: Nees to create Indicator to show the Hours

Re: convert text to numeric date function

Re: Help with Date macro

Change the Field value

Re: Proc export to CSV

Re: Proc export to CSV

Proc export SAS dataset to CSV file

Code help

Re: Proc sql conditional join

Proc sql conditional join

Re: SAS macro

SAS macro

SAS macro

Re: Macro

Calculate historic date & store in macro variable

Re: convert text to numeric date function

Re: SAS macro

Re: convert text to numeric date function