Hi , I got the below code a from a co-worker of mine and I am trying to count the male and female age categories in the below order. The problem with the below code is that if the male of female's age is greater than 18 and less than 64 or greater than 65 and above it is not counted twice. I want to capture the count of the age of the female in the correct age category f18-44 ,f44-54, f 55-64 and f18-64 and also in f18-64. eg: if the age of female is 55, the I want the varibales f55-64 and f18-64 to be populated as 1. The same needs to happen for  males and the age category f65 and above & m65 and above. Please help. Sample code: data step5_a(drop=i);         merge one(in=a) mbr__span(in=b);    by member;    if a and b;      attrib f18_44 length=3 label='Females, Age 18 to 44'             f45_54 length=3 label='Females, Age 45 to 54'             f55_64 length=3 label='Females, Age 55 to 64'             f65_74 length=3 label='Females, Age 65 to 74'             f75_84 length=3 label='Females, Age 75 to 84'             f85_UP length=3 label='Females, Age 85 and UP'   f18_64 length=3 label='Females, Age 18 and 64'   f65_UP length=3 label='Females, Age 65 and UP'             m18_44 length=3 label='Males, Age 18 to 44'             m45_54 length=3 label='Males, Age 45 to 54'             m55_64 length=3 label='Males, Age 55 to 64'             m65_74 length=3 label='Males, Age 65 to 74'             m75_84 length=3 label='Males, Age 75 to 84'             m85_UP length=3 label='Males, Age 85 and UP'   m18_64 length=3 label='Males, Age 18 and 64'   m65_UP length=3 label='Males, Age 65 and UP' ;     array ag(*) f18_44--m65_UP;    age=int(intck('month',&dob,&dis_dt)/12);      if &sex not in ('F' 'M') or age lt -1 then agegp=0;         else if age ge 18 and age le 44 then agegp=1+8*(&sex='M');         else if age ge 45 and age le 54 then agegp=2+8*(&sex='M');         else if age ge 55 and age le 64 then agegp=3+8*(&sex='M');         else if age ge 65 and age le 74 then agegp=4+8*(&sex='M');         else if age ge 75 and age le 84 then agegp=5+8*(&sex='M');         else if age ge 85               then agegp=6+8*(&sex='M');   else if age ge 18 and age le 64 then agegp=7+8*(&sex='M');   else if age ge 65               then agegp=8+8*(&sex='M');      do i=1 to dim(ag);         if agegp=i then ag(i)=1;         else ag(i)=0;      end;     run; ... View more

Hi, I got a code from a co-worker of mine where he creates a sas dataset with some statistics and then create a PDF file with it. The problem is the PDF is only displaying 5 decimal places(some times rounds the fifth decimal). Just wondering , if it is possible to display the decimal part as is without rounding. Please help. Here is the sample code: data tt;   input id id2;   datalines; 0.4567682345678 234 ;run; data tt1; set tt; kd=id  * (1-id) ; run; %let test_pdf = C:\Test1.pdf; ods listing close; ods pdf file="&test_pdf"; proc print data=tt1 noobs; title "&Test PDF"; run; ods pdf close; ods listing; In the PDF the value of KD is displayed as 0.24813  instead of 0.2481310145. Please share your thoughts. Thanks. ... View more

Hi, I am trying to create a .csv sas dataset on mainframe with column headings. DATA _NULL_;   SET DATAOT1.NRI;   IF MCA = "&MCA1" THEN DO;   CALL SYMPUT('TEXT_FLG', 'Y');    FILE &FNME1  DSD DLM=',' LRECL=8000 TITLES;    IF _N_ EQ 1 THEN    PUT @1 'MCA,MN1,ADMDT,DISDT,ADMTYPE_NM,ADMSRC_NM,DISP_NM,AGE,        ED_IND,PAT_ENC_CSN_ID,MDC,SCHED,EXPIRED,BASECLASS,SEX,        LOS,V_ALL_BARI,CANCER,BMI35,HSP_ACCOUNT_ID,        ADT_PATIENT_STAT_C,PAT_CLASS,INP_ADM_DT';    PUT MCA MRN1 ADMDT DISDT ADMTYPE_NM ADMSRC_NM DISP_NM AGE        ED_IND PAT_ENC_CSN_ID MDC SCHED EXPIRED BASECLASS SEX        LOS V_ALL_BARI CANCER BMI35 HSP_ACCOUNT_ID        ADT_PATIENT_STAT_C PAT_CLASS  INP_ADM_DT        ; end; run; but this code is not writing the column headings.Also in the sas log I see the note that the quouted string(put @1) exceeded 256 characters. Please share your thoughts. Thanks ... View more

Hi, I am trying to FTP a mainframe dataset in .csv format to a ftp location.I used the extension as .csv in the mainframe sas code.The problem is when I open the file in the ftp server(file opens in excel) one record is spread over multiple rows. eg:I need the data to be like this: John California Los Angeles instead the data is opening in excel like this john california los angeles I tried to correct this by using the text-to-column option in excel,but it does not help.I think this something to do with the way I ftp data from mainframe to the ftp location. Below is the code I ran to FTP the file: %MACRO MCASPLT(MCA1,FNME1,F1); DATA _NULL_;   %LET TEXT_FLG=N;   %PUT "TEXT FLG B4 LOOP:" &TEXT_FLG;   SET DATAOT1.NBARI;   IF MCA = "&MCA1" THEN DO;   CALL SYMPUT('TEXT_FLG', 'Y');   %PUT "TEXT FLG IN LOOP:" &TEXT_FLG;    FILE &FNME1  DSD DLM=",";    PUT VCA  ADMDT DISDT ADMTYPE_NM ADMSRC_NM DISP_NM AGE        ED_IND PAT_ENC_CSN_ID MDC SCHED EXPIRED BASECLASS SEX        LOS  BMI35 HSP_ACCOUNT_ID        ADT_PATIENT_STAT_C PAT_CLASS  INP_ADM_DT        ;   END; RUN; %IF &TEXT_FLG  =  Y  %THEN %DO;      %LET OUT_LRECL=3000;      %LET CD=fff\ggg\fdfdf\TEST;      %LET HLQO=AAAA.Y3012.XAAA.&F1..TXTOUT;      %LET OUT_NAME=XAAA.&F1..CSV;      FILENAME NCHS01 "&HLQO" DISP=SHR;         FILENAME NCHS FTP                  "&OUT_NAME"                  &HOST_PORT_USER_PASS                  CD = "&CD"                  LRECL = &OUT_LRECL                  ;          RUN;          DATA _NULL_;            INFILE NCHS01 SHAREBUFFERS;            FILE NCHS;            INPUT;            PUT _INFILE_;         RUN;    %END; %MEND; Please share your thoughts. Thanks. ... View more

Hi, I have a requirement based on store branches I have to create .csv files on to a drive. I used Filename FTP to create .csv files on the drive,but the problem is certain branches does have empty files,in that case i do not want to create output files on the drive for that branch. How can I achieve this?Please share your thoughts. ... View more

Hello All, I have a requirement where I have a dataset which has the  days a technician visits a customer.We are only considering weekdays(Mon-Fri).If a technician did not visit the a particular customer on a weekday then I need to identify that and populate a  flag as "NO Visit".Is there any way to achive this based on the below example? eg:  Customer_name   TechVist_day            John                02JAN2012            John                03JAN2012            John                05JAN2012                   John                06JAN2012            John                09JAN2012             Mary               02JAN2012            Mary                03JAN2012            Sam                03JAN2012            Sam                04JAN2012                      Requirement 1: From the above example I need to populate the flag as "NO Visit" for 04JAN2012 for the customer John and same with customer Sam for 02JAN2012. Requirement 1 was met through the valuable inputs from LINLIN and ANDREAS_IDS. Now I need to run the code on a monthly basis and based on the above example,the John's the last record's TechVist_day is 09JAN2012..I need to set the flag for all weekdays after 09JAN2012 till the end of the month(same for Mary 03JAN2012 and SAM 04JAN2012).Please share your thoughts. ... View more

Hello, I have two variables,start date and end date ,I want to create a data set with allthe dates between those two variables.please let me know how to create it. Thanks in advance. ... View more