Trying to convert PD 6.2 to integer from mainframe to SAS EG environment. PUT @0321 INC_AM PD6.2 @@; IF MO_PMT_AM = .  PUT @0327 '?' @@; ELSE PUT @0327 MO_PMT_AM PD6.2 @@; IF PMT_AM = .  PUT @0333 '?' @@; ELSE PUT @0333 PMT_AM PD4.8 @@; ... View more

Extract First , Last and Middle name from a email id. animeshkumarmardi@gmail.com jackreacher@gmail.com michaelfassbender@gmail.com riteshsinghsainik@gmail.com   if no middle name the output will be blank E.G- First Name- Animesh , Jack  Middle Name- Kumar , Last Name- Mardi , Reacher can we use scan function too on this ?     ... View more

  %macro export_dataset_names(libname, outpath);    proc contents data=&libname.._all_ noprint out=_datasets(keep=memname);    run;      proc export data=_datasets       outfile="&outpath.\DatasetNames.xlsx"       dbms=xlsx       replace;    run;      proc datasets library=work nolist;       delete _datasets;    quit; %mend;   %export_dataset_names(MDM, C:\Users\alokj\OneDrive\Desktop\MDM);   ... View more

While trying to run this code I am geeting the below error data oralib.benefeciary ; set SSP.SSPSASSchemeBeneficiary(obs=10); run; ERROR: Error attempting to CREATE a DBMS table. ERROR: ORACLE execute error: ORA-00902: invalid datatype.. ERROR: ROLLBACK issued due to errors for data set ORALIB.SCHEMEBENEFICIA.DATA.   But running the below code is working  data oralib.benefeciary ;(KEEP=AppId Disability DistrictName DOB Gender GramPanchayatName MaritalStatus SocialSchemeName);   set SSP.SSPSASSchemeBeneficiary(obs=10) ; run;   But the length of the variable is jumping to anywhere around 800 for every variable I had also tried to reduce  length   but the sameis not getting reduced data oralib.Schemebeneview; LENGTH Disability $15 DistrictName $15 GramPanchayatName $15 MaritalStatus $15 SocialSchemeName $15; set oralib.SCHEMEBENEDETAIL; RUN;   Could anyone please give an idea How to fix this?   ... View more

TableA TableB 1 1 1 1 2 1 2 2 2 2 ... View more