Hello I want to create serial number within each group by following rule: Wanted calculate column is called seq. How can I calculate it please from have data set? The rule is - for each group we calculate seq numbers but IF values of X,Z are same between rows then rows get same seq number   data have; input group x z seq; cards; 111 10 20 1 111 10 20 1 111 30 40 2 222 10 20 1 222 10 20 1 333 40 50 1 444 15 20 1 444 15 20 1 444 15 20 1 444 30 50 2 444 60 80 3 444 60 80 3 ; Run; ... View more

Hello Lets say I have a sas data set with 2 million rows and 200 columns. Lets say that I consider perform transpose so there will be Long structure with 3 fields: Custt_ID,var_name, value (so will have 400 million rows with 3 columns) My question- Will the resulted data set have same size (in giga) as the orignal data set? Note- The data set include information of credit risk score model. Each customer has geneeral information and also information of explenatory varaibles. There are diffferent sets of explenatory varaibles depents on the model that the customer passed. I want to create a panel that help users to analyse specific customer.       ... View more

Hello I have a macro variable called allv_y that contain many Var(field) names. I want to add single quote for each the fields names (each component) in macro var allv_y. The required macro variable is called b_allv_y The problem- When I create the new macro var I dont see all components!! Some of them disappeared   %let allv_Y=LAKOACH AB_PA_IND_bad_ANYBAD AB_PA_MKR_TASHLUM AB_PA_AGE_VETEK_MASHK AB_PA_Y_TAS_SUMLLL_TYPE AB_PA_BITCHONOT AB_NEWC_Y_NIZHOS AB_NEWC_Y_NIZMISGOSH_HARIGA AB_NEWC_AKM_HZR AB_NEWC_MASHKANTA AB_NEWC_INC_COMPONENT AB_NEWC_INC_TREND AB_NEWC_CDO_CCSCR AB_NEWC_Y_NIZMISGCRD AB_NEWC_OSHER_HOS AB_NEWC_IND_bad_ANYBAD AB_NEWC_Y_HOVA_ZHUT AB_NEWC_LLL_LEUMI_HUZB AB_NEWC_MESHIHOT_MEZMEZ AB_NEWC_AGE_BALUT AB_OFI1MB_Y_NIZMISGOSH_HARIGA AB_OFI1MB_SMLHOV_PIG_AKM AB_OFI1MB_CDO_CCSCR AB_OFI1MB_Y_ECHZERLOANINC AB_OFI1MB_MESHIHOT_MEZMEZ AB_OFI1MB_IND_bad_ANYBAD AB_OFI1MB_Y_NIZHOS_INC AB_OFI1MB_Y_HOVA_ZHUT AB_OFI1MB_VETEK_AGE_BALUT AB_OFI1MB_MESHIHOT_CHCK AB_OFI1MB_HUZB AB_OFI1MB_LOAN_BIT AB_YNG_Y_NIZMISGOSH_HARIGA AB_YNG_AKM_HZR AB_YNG_INC_COMPONENT AB_YNG_CDO_CCSCR AB_YNG_Y_NIZMISGCRD AB_YNG_Y_HOVA_ZHUT AB_YNG_IND_bad_ANYBAD AB_YNG_MESHIHOT_MEZMEZ AB_YNG_HUZB AB_YNG_SMLHOV AB_YNG_VETEK_AGE_BALUT AB_YNG_Y_NIZHOSBIT AB_ACTV_AGE_BALUT AB_ACTV_VETEK AB_ACTV_Y_NIZMISGCRD AB_ACTV_CDO_CCSCR AB_ACTV_MASHKANTA AB_ACTV_MESHIHOT_MEZMEZCHCK AB_ACTV_HUZB AB_ACTV_SMLHOV AB_ACTV_AKM_HZR AB_ACTV_IND_bad_ANYBAD AB_ACTV_OSHER AB_ACTV_Y_NIZMISGOSH_HARIGA AB_ACTV_Y_NIZHOSBIT AB_ACTV_Y_ECHZERLOANINC_RINC AB_ACTV_Y_HOVA_ZHUT_INCCOMP VALID_FROM_DTTM POP_LOMEFORAT_WPPR POP_LOMEFORAT_NOPPR VCT_AB_SIBAT_OR TEUR_BAD_TYPE_AB TEUR_REJ_TYPE_AB WWW_6_AMT AVG_WAGE_3_MONTH_AMT AGE_VALUE AKM_ABSH_1_CNT AKM_ABSH_2_CNT AKM_ABSH_3_CNT AKM_ABSH_4_CNT AKM_ABSH_5_CNT ANOEXTAS_HOD_LLL_AMT BITCHONOT_KVUIM_6_AMT BITCHONOT_NEZILIM_6_AMT D5MACHZOR_MTI_AMT HARIGA_MISGERET_1_AMT HARIGA_MISGERET_2_AMT HARIGA_MISGERET_3_AMT HARIGA_MISGERET_4_AMT HARIGA_MISGERET_5_AMT HZR_HIUV_1_CNT HZR_HIUV_2_CNT HZR_HIUV_3_CNT HZR_HIUV_4_CNT HZR_HIUV_5_CNT HZR_HIUV_6_CNT balance_MESHU_LLL_PIG_MTH_1_AMT balance_MESHU_LLL_PIG_MTH_2_AMT balance_MESHU_LLL_PIG_MTH_3_AMT balance_MESHU_LLL_PIG_MTH_4_AMT balance_MESHU_LLL_PIG_MTH_5_AMT balance_MESHU_LLL_PIG_MTI_1_AMT balance_MESHU_LLL_PIG_MTI_2_AMT balance_MESHU_LLL_PIG_MTI_3_AMT balance_MESHU_LLL_PIG_MTI_4_AMT balance_MESHU_LLL_PIG_MTI_5_AMT balance_MESHU_LLL_PIG_MTI_6_AMT balance_MESHU_LLL_PIG_MTH_6_AMT MACHZOR_NOEXT_AMT MAX_HARIGA_1_5_AMT MAX_PIGUR_1_5_AMT MAX_TAUN_check_NO_20_21_CD MISGERET_CARTIS_ASHRAI_6_AMT MISGERET_OSH_6_AMT MISPAR_D_HARIGA_1_CNT MISPAR_D_HARIGA_2_CNT MISPAR_D_HARIGA_3_CNT MISPAR_D_HARIGA_4_CNT MISPAR_D_HARIGA_5_CNT MISPAR_D_HARIGA_6_CNT NITZUL_6_AMT NITZUL_CARTIS_ASHRAI_6_AMT NIZUL_BAOSH_6_AMT OSHER_AMT WWW_1_AMT WWW_2_AMT WWW_3_AMT WWW_4_AMT WWW_5_AMT SEMEL_CHOV_1_CD SEMEL_CHOV_2_CD SEMEL_CHOV_3_CD SEMEL_CHOV_4_CD SEMEL_CHOV_5_CD SEMEL_CHOV_6_CD SUG_CARTIS_ASHRAI_6_CD TAUN_check_1_CD TAUN_check_2_CD TAUN_check_3_CD TAUN_check_4_CD TAUN_check_5_CD TAUN_check_6_CD TAUN_check_NO_20_21_6_CD VETEK_6_VALUE ANY_BAD AKM_ABSH_6_CNT D5WWW_AMT HASIMOT_6_CNT HSMVISA_KASPOMAT_1_6_CNT balance_MESHU_LLL_PIG_1_5_IND balance_MESHU_LLL_PIG_6_AMT balance_MESHU_LLL_PIG_6_IND MAX_TAUN_check_MODEL_1_6_CD MESHIHOT_SHKIM_1_AMT MESHIHOT_SHKIM_2_AMT MESHIHOT_SHKIM_3_AMT MESHIHOT_SHKIM_4_AMT MESHIHOT_SHKIM_5_AMT MESHIHOT_SHKIM_6_AMT MESHIHOT_SHKIM_6_CNT NIT_HOSEN_BIT_AMT SEMEL_BALUT_CD TAS_HOD_LLL_REGILA_6_AMT TAUN_check_MODEL_6_CD; data _null_; length b_allv_Y $2500; b_allv_Y = "'" || tranwrd("&allv_Y", " ", "' '") || "'"; call symputx('b_allv_Y', b_allv_Y); run;     ... View more

Hello In the following code there is a field in keep that doesnt exost in the data set. (Field called color in my code) Using options dkricond=warning   prevent error and the code is running well. My question- Is there a way to  prevent warning message?   The issue is that I wrote code that other people should run. It might happend that in the source data set some of fields will not exist and then I want that the code still run (no error). I also prefer that no warning occur due to this issue. If other issues arrise then of course I want that they appear i warning message options dkricond=warning; data cars; set sashelp.cars(KEEP=model make invoice color); Run; i  ... View more