What is the meaning of <> in the below? Is it not equals or max?    Whether this symbol <> has different meaning in where clause and if clause?   data work.REQ3; length PrimaryBOM $50; set work.REQS; if BOMQTY <> . then do; PrimaryBOM=cat('. .', Component); PRIMBOMCL=Component; end; ... View more

Can someone help me understand the meaning of this SAS code?   today() between Start_dt and End_dt ... View more

Appreciate if any one of you help me understand the purpose of nway and missing option in proc means. My understanding is, it will delete the records if the values of class variable is missing.   proc means data=stack nway noprint missing; class SNAP_DATE loc loc_name bu ip_code matrl_typ storage_loc material ; output out=MB_SUMMARY(drop=_:) sum(UNRSTR_QTY_DOL UNRSTR_QTY_UL)=; run; ... View more

Appreciate if someone of you help me understand this match merge. I want to know  in the final result MFGCOMBINE3, why the variables MATRL_NBR and PLANNED_ZNL values are missing in second record and why the value of REASDES got updated in first record.    data MFGCOMBINE1; MATRL_NBR=.; FISC_YR=2019; FISC_PD='012/2019'; FISC_WK='049/2019'; PLANT=337; MATERIAL2=3010030074; PLANNED_ZNL=.; REASDES='DO NOT USE Line Performance(LP)'; run; data MFGCOMBINE2; MATRL_NBR=.; FISC_YR=2019; FISC_PD='012/2019'; FISC_WK='049/2019'; PLANT=337; MATERIAL2=3010030074; PLANNED_ZNL=.; REASDES='DO NOT USE Line Performance(LP)'; run; data MFGCOMBINE; set MFGCOMBINE1 MFGCOMBINE2; run; data PRIORACTUALS2019A; MATRL_NBR=3010030074; FISC_YR=2019; FISC_PD='012/2019'; FISC_WK='049/2019'; PLANT=337; MATERIAL2=3010030074; PLANNED_ZNL=68478; REASDES='Line Performance'; run; DATA MFGCOMBINE3; MERGE WORK.MFGCOMBINE WORK.PRIORACTUALS2019A; BY FISC_YR FISC_PD FISC_WK PLANT MATERIAL2; RUN; ... View more

In one of our program, they have called the user defined format as shown below. Program is working fine and they have not created the format in that program. But I could not locate where this format is created. Any help?   type = put(material, $mattype.); Category = put(type,$type.); ... View more

Merge with OR equals full join or cartesian product in the step below?   data FORECASTS; merge SOP(in=SOP) CF(in=CF) CLF(in=CLF) STAT(in=STAT); by BUSINESS_UNIT SALESORG CHANNEL DP_MATERIAL EXPLODED_MATERIAL FLAG PLANTO LOCATION WEEK ; if SOP or CF or CLF or STAT; run; ... View more