About rajdeep

rajdeep · ‎08-12-2019

Hi William, Exactly I don't get it what you are trying to do. I mean you wanted to disable the attachment or you want only one format of attachments should traverse over email. Anyways here are some explanations are there regarding Content Type and Attachments in the Filename statement. I hope the below information will help you. xt' | ATTACH= ('filename.ext' attachment-options) specifies the physical name of the file or files to be attached to the message and any options to modify attachment specifications. The physical name is the name that is recognized by the operating environment. Enclose the physical name in quotation marks. To attach more than one file, enclose the group of files in parentheses, enclose each file in quotation marks, and separate each with a space. Here are examples: attach="/u/userid/opinion.txt" attach=('C:\Status\June2001.txt' 'C:\Status\July2001.txt') attach="user.misc.pds(member)" The attachment-options include these values: CONTENT_TYPE='content/type' specifies the content type for the attached file. You must enclose the value in quotation marks. If you do not specify a content type, SAS tries to determine the correct content type based on the filename. For example, if you do not specify a content type, a filename of home.html is sent with a content type of text/html. Alias CT= and TYPE= Default If SAS cannot determine a content type based on the filename and extension, the default value is text/plain. Thanks and Cheers.

rajdeep · ‎08-12-2019

Hi, If you will use the LSF then you will get a good insight of the same and you can run the below code also to get the scheduled flows. Yes, it's obvious that you need to change the path... or else try to look for something in SMC installation folder and try to replicate the same code. /*Set this value to the location of your Platform Process Manager installation folder*/ %let pm_install_loc = /sasconfig/pm; /*Scheduled Flows information. This file seems to be updated by LSF/PM every day at midnight*/ DATA SCHEDULED_FLOWS; INFILE "&pm_install_loc./work/system/triggerevents.dat" DSD TRUNCOVER; LENGTH TEXT $512. FLOW_OWNER $10. FLOW_NAME $64.; INPUT @1 TEXT; IF FIND(TEXT,":") THEN DO; FLOW_OWNER = SCAN(TEXT,1,":"); FLOW_NAME = SCAN(TEXT,2,":"); END; IF NOT MISSING(FLOW_NAME); RUN; /*Flow Information. These files are updated any time a flow is scheduled/rescheduled in SMC or Flow Manager*/ FILENAME XCMD PIPE "ls -ltr &pm_install_loc./work/storage/flow_storage"; /*Create dataset of output from X command*/ DATA FLOW_STORAGE; INFILE XCMD DSD TRUNCOVER; LENGTH TEXT LOG FILEPATH $512.; INPUT @1 TEXT; LOG = SCAN(TEXT,-1," "); IF FIND(TEXT,".dat"); FILEPATH = "&pm_install_loc./work/storage/flow_storage/"||STRIP(LOG); FLOW_OWNER = SCAN(LOG,1,":"); FLOW_NAME = SCAN(SCAN(LOG,2,":"),1,"%"); /*Ensuring that only root directory is included in output*/ DROP TEXT; RUN; Bcoz as of my knowledge I think under the scheduled manager list in SMC, we use to see all the flows which are scheduled, so if you need something else then please explain. Thanks...

rajdeep · ‎08-12-2019

HI Amity, Please try to run the code. The "hdfs ls" will show the filesize as well in the output list. Like in the code it's in *, but if you need any specific file then you can mention that. Yeah, you need to change the username password and path as per the hadoop location. The libname what you had mapped in your EG from that you might get the credentials and path probably. Have a try and check. I hope you are using 9.4. options set=SAS_HADOOP_CONFIG_PATH="\\sashq\root\u\abcdef\cdh45p1"; options set=SAS_HADOOP_JAR_PATH="\\sashq\root\u\abcdef\cdh45"; options set=SAS_HADOOP_RESTFUL 1; proc hadoop username='sasabc' password='sasabc' verbose; hdfs cat='/user/sasabc/*'; hdfs ls='/user/sasabc/*'; run;

rajdeep · ‎08-12-2019

Hi I think you need to perform a join with 3 tables and then one table loader and load the data based on the control table where you need to make something conditions based on the start and end date. I hope you are aware about the control table parameters or else have a check with Google. Because with SAS DI JOB design I might not help you from here. Gud luck.

rajdeep · ‎08-12-2019

Hi elainathewonder, Greetings of the day. I have done something for you, just have a check and let me know if you mean this. data test; patternID=prxparse("/L\w+E/o"); input address $80. ; position = prxmatch(patternID, address); if position ^= 0 then address= tranwrd(address,substr(address,POSITION,5),'Love'); datalines; Zack Johnson, 153 LirsE Str, Chapel Hill, NC27514 Dan Zack, 67891 64th st, Brea, CA Sally Johns, 4 Moritz LtreE, Duarte, CA 91010 ; run; In the above example LirsE, LtreE few words are there which got replaced with a common word 'Love'. So if think like there is some kind of similarity in the misspelling texts you can identify that and parse the same as per example and you are done. Please check and let me know if there is any disconnect.

rajdeep · ‎03-15-2019

Thanks Rick for your reply. I think the Graph was behaving random because of the Data. I had checked the same code over Enterprise Guide and I found out that the order was changing for X axis and Y axis columns. So I tried to fix the order and now if we clicking on the refresh icon of the Browser, the plot is fixed and it's not changing. Thanks a lot for sharing the workarounds. Cheers..

rajdeep · ‎02-28-2019

HI Rick, No, I am not changing the image repeatedly neither we want the view should be changed repeatedly on page refresh. 1.Inside a stored process the complete program is written. 2.Running the same stored process with the stored process server link (http://stp_server:7980/SASStoredProcess/do) over Internet Explorer. 3.We don't want to refresh the graph to get another image, but ideally the bar graph or any plot graph should not change if at all we are clicking on the refresh browser icon. 4. We are running the same stp on Windows 7 Env. 5. In simple words, the requirement is not to change the view or plot of a graph on every refresh, but if at all you had clicked mistakenly the refresh icon of the browser then the plot should not change ideally, no matter how many times you refresh. 6. Atleast, if you want to save the same Graph plot in a pdf format, then it should download the same what you see in the browser, but currently after opening the PDF file the plot is scattered and random. It's not the same currently, it's a mismatch between PDF file and browser plot. Hope I am clear this time. Please let me know if any disconnect.

rajdeep · ‎02-28-2019

Hey Rick, Thanks for the reply. I am running the program inside a Stored Process, so while viewing the output over the browser, the Bars are not stable, so it's changing in every page refresh. Infact I have enabled the PDF download button inside the program in order to save the output in PDF format, but surprise thing is after PDF download sometimes the graph is coming or sometimes the bars are not coming like a blank container. For an Example, Suppose I have 3 values for the Year 2017 2018 and 2019 in x_axis and I have Disbursement percentage in Y-axis, so by default for 2017 -> 50%, 2018->60% and 2019-> 70% suppose to come, so it's coming as per the first load or run, but If I refresh the graph or refresh the browser then the size of the bars are changing randomly, so in the other way the percentage is changing. Why it's happening like this I am not getting, Dataset is same and static, there is no such kind of macro is been used for the dataset name. Please let me know if there is any disconnect. Thanks in advance

rajdeep · ‎02-25-2019

ODS ESCAPECHAR="^" ; ods graphics on / width=10in HEIGHT=10in imagemap=on; /*options orientation=landscape; */ /*options papersize=(10in 10in);*/ /*options pdfpageview=fitwidth;*/ proc sgpanel data=Test_Dataset noautolegend; format name $na. ; format MTH fmn_ffym3.; panelby name / layout=COLUMNLATTICE onepanel colheaderpos=bottom rows=20 NOHEADERBORDER nowall novarname spacing=20 noborder headerattrs=(size=07) sort=data; vbar &mcv_sort. / group=&mcv_sort. response=Percent stat=percent nostatlabel barwidth=0.6 tip=(Percent); colaxis VALUESROTATE=VERTICAL valueattrs=(size=10) display=(nolabel noline) ; rowaxis grid label="Test" ; Footnote ' '; run; title; proc sgpanel data=Test_Dataset noautolegend nocycleattrs; format name $n.; format Disbursements DOLLAR21.2; format MTH fmn_ffym.; panelby name / layout=COLUMNLATTICE onepanel colheaderpos=bottom nowall novarname spacing=11 noborder noheaderborder headerattrs=(size=8) sort=data; vbar &mcv_sort. / group=&mcv_sort. response=Disbursements nostatlabel barwidth=0.6 tip=(Disbursements); colaxis &MCV_VR. valueattrs=(size=6) display=(nolabel noticks); rowaxis grid LABEL="Disbursements" ; run; Hi Team, I have written the below code and the Bargraph is also coming with the below code, but if I am clicking on the refresh icon in the Internet Explorer then the Bars size are changing in the graph on every refresh. I don't understand why it's happening like this though the dataset and the values are same no new data is flowing. Please help me what I am missing or it's a defect in SGpanel in SAS, please let me know if anyone have any idea.

rajdeep · ‎01-17-2018

Hi mkeintz, Thanks for your help. I am sorry I was trying something wrong. Now it's working. Thanks a lot for your help. Cheers.

rajdeep · ‎01-17-2018

Hi Astounding, Thanks for the reply. The firstobs=2 is actually limiting the data. Like in the real scenario, suppose the "Oh!" word is not starting at row no.2 and think if there would be more than 1000 of records then we might not open the dataset each time to look at, in order to know about the "Oh!" word starting row. Looking for a generic solution. Thanks

rajdeep · ‎01-17-2018

Hi mkeintz, I am looking for a generic solution. The firstobs=2 is actually limiting the data making it limited to the scenario specific. If I have more than 1000 records then it might not work. Hope you can understand. Thanks

rajdeep · ‎01-16-2018

Hi novinosrin, Thanks for the quick reply, but it's deleting the "Hello world" line from the output. That is also needed. Thanks in advance.

rajdeep · ‎01-16-2018

Hi Folks, I am trying to append two rows one after another based on a condition data test1; input x $1-15; cards; Hello There Oh! No Hello World See You Guys Oh! Yes ; run; data test2; set test1; if findw(cat,'DATA',1,'.','i') then do Concat_var1=_n_; end; Concat_var2=Concat_var1-1; if scan(cat,1)='DATA' and Concat_var1 eq . then Concat_var1=Concat_var2; run; Expected Output : Whenever the "Oh!" word encounters it should be appended with just to prior row value. Like for example in the output should be like below Hello There Oh! No Hello World See You Guys Oh! Yes Please help if possible. Thanks in advance.

rajdeep · ‎12-20-2017

Hi Team, I just wanted to retrieve the Word prior to the "=" sign. The below code I tried. DATA T1; LENGTH string _string str1 str2 $500; string="Set Medicine; HEADACHE=24-JAN-2013; SEVERE=04-FEB-2013; MODERATE=04-DEC-2013"; _string=string; Pos=0; Curr=0; prev=0; DO WHILE (INDEX(_string,"=")>0); Prev=prev+pos; Pos=INDEX(_string,"="); _string=SUBSTR(_string,pos+1,LENGTH(_string)-pos); Curr=curr+pos; END; str1=SUBSTR(string, 1,prev-1); str2=SCAN(string,-2,"="); PUT str1 "," str2; y=substr(string,(index(string,"=")),10); x=scan(substr(string,index(UPCASE(string),"=")),1,';'); /*scan(substr(sas_code2,index(UPCASE(sas_code2),"SELECT")),2,' ');*/ RUN; Please help me to retrieve the HEADACHE SEVERE MODERATE as an output. Thanks Rajdeep

Online Status	Offline
Date Last Visited	‎05-20-2022 03:42 AM

Re: Address Validation Using SAS

Re: No matching authentication protocol-Oracle 19C

No matching authentication protocol-Oracle 19C

No ids found for LabelPath while creating STR on ECM 6.3

Re: Extract Scheduled Jobs from SMC

Re: Extract Scheduled Jobs from SMC

Re: Extract Scheduled Jobs from SMC

Re: Extract Scheduled Jobs from SMC

Re: Macro variable null check based on count(*)

Re: Macro variable null check based on count(*)

Re: Extract Scheduled Jobs from SMC

Re: Extract Scheduled Jobs from SMC

Re: PROC DS2 ERROR: Syntax error at or near "CONTAINS"

Re: Disable Automatic Attachment when sending a mail in Stored Process...

Re: Extract Scheduled Jobs from SMC

Re: Finding how much space is used in Hadoop using SAS EG

Re: SAS DI : Data Management

Re: Text Mining Question RegEx

Re: Bargraph in SGpanel is changing on page refresh over the browser.

Re: Bargraph in SGpanel is changing on page refresh over the browser.

Re: Bargraph in SGpanel is changing on page refresh over the browser.

Bargraph in SGpanel is changing on page refresh over the browser.

Re: how to append two observations based on a condition

Re: how to append two observations based on a condition

Re: how to append two observations based on a condition

Re: how to append two observations based on a condition

how to append two observations based on a condition

How to find a string prior to a special character