About sagulolo

sagulolo · ‎11-17-2017

Hi Ksharp, Thank for your code. appreciated if you could explain more on part below:- "if missing(lag(group_no)) then set key;" thanks in advance

sagulolo · ‎11-16-2017

Hi gamotte, Thank you so much, it help me a lot and it totally out of my mind, it can be done by this way. Best regards and thank for your time

sagulolo · ‎11-15-2017

Dear All, I got a dataset as per below:- group_no item_name company 020101 banana 020101 apple 020101 grape Company A 020101 apple 020101 pineapple Company B 020102 pineapple 020102 apple 020102 grape 020102 papaya Company C How to transform it into below dataset? Just want the company to be first row instead of last row? The no of items can be any number. group_no item_name company 020101 banana Company A 020101 apple 020101 grape 020101 apple Company B 020101 pineapple 020102 pineapple Company C 020102 apple 020102 grape 020102 papaya Thank you in advance

sagulolo · ‎10-31-2017

Hi Reeza, thank for the sample, but my issue is unable to read from sharefolder(as describe by KurtBremser). Best Regards

sagulolo · ‎10-31-2017

Hi s_lassen, tried the code and no record was retrieved. checked the log and saw message below:- Stderr output: Access is denied. Best Regards

sagulolo · ‎10-30-2017

Hi KurtBremser, Just clarification, IWA means Integrated Windows Authentication? Means i need to refer to folder owner? Actually I'm able to access the share folder, but SAS session is not necessary able to access, right? Best Regards

sagulolo · ‎10-30-2017

Hi KurtBremser, Apologize as i posted my version log to you. FYI, dir address was amended. Please refer below:- NOTE: The infile OSCMD is: Unnamed Pipe Access Device, PROCESS=dir \\sharefolder\NAME_1710* /s /b 2>&1, RECFM=V,LRECL=32767 Access is denied. NOTE: 1 record was read from the infile OSCMD. The minimum record length was 17. The maximum record length was 17. NOTE: DATA statement used (Total process time): real time 0.33 seconds cpu time 0.01 seconds Please advice.

sagulolo · ‎10-30-2017

Hi KurtBremser, no record was retrieved. Checked the log and I get below:- NOTE: The infile OSCMD is: Unnamed Pipe Access Device, PROCESS=dir \\sharefolder\name_1710* /s /b 2>&1, RECFM=V,LRECL=32767 NOTE: 1 record was read from the infile OSCMD. The minimum record length was 17. The maximum record length was 17. NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK.MULTIPLE_CMC_FITAS has 0 observations and 33 variables. NOTE: DATA statement used (Total process time): real time 0.21 seconds cpu time 0.03 seconds Best Regards

sagulolo · ‎10-30-2017

Dear All, Need advice from your all, I have a raw file from sharefolder with a common name and follow by date(yymmdd), the file have no extension something like below:- name_171030 have a difficulty to import a range of file into SAS Dataset. How do i import file range from name_171001 till name_171031? How to infile common file like [name1_171001 till name1_171031] and [name2_171001 till name2_171031]? I have code infile as per below:- infile 'dir \\sharefolder\* /s /b' pipe truncover; try below but not success infile 'dir \\sharefolder\name_1710* /s /b' pipe truncover; ***no record was retrieved infile 'dir \\sharefolder\name_1710*.* /s /b' pipe truncover; ***no record was retrieved Thank you in advance

sagulolo · ‎09-14-2017

Thank you, Astounding. Now I understand how it work. Thank for your time and guidance. Really help me a lot

sagulolo · ‎09-14-2017

Astounding, thank you so much. Would you mind to tell me how it work, by study the else code your give, Im confuse how SAS run the data already. Best Regards

sagulolo · ‎09-14-2017

Hi All, I have a code below:- data testing; infile datalines dlm='|'; input date $ acctno $ due $ pic $; ; datalines; 20170801 | 12345 | 0000000 | UserA 20170802 | 12345 | 0000000 | UserA 20170803 | 12345 | 0000000 | UserX 20170804 | 12345 | 0000001 | UserA 20170805 | 12345 | 0000002 | UserC 20170806 | 12345 | 0000003 | UserC 20170807 | 12345 | 0000004 | UserA 20170802 | 22222 | 0000000 | UserX 20170803 | 22222 | 0000000 | UserB 20170804 | 22222 | 0000001 | UserA 20170805 | 22222 | 0000002 | UserA ; proc sort data=testing; by acctno date; run; data want; set testing; by acctno date; retain tag; if first.acctno then do; if pic NE 'UserX' then tag = 'Normal'; else tag = 'UserX'; end; else tag = lag(tag); run; and outcome as below:- date acctno due pic tag 20170801 12345 0 UserA Normal 20170802 12345 0 UserA 20170803 12345 0 UserX Normal 20170804 12345 1 UserA 20170805 12345 2 UserC Normal 20170806 12345 3 UserC 20170807 12345 4 UserA Normal 20170802 22222 0 UserX UserX 20170803 22222 0 UserB 20170804 22222 1 UserA UserX 20170805 22222 2 UserA How can i get below output? logic is once acc's pic is UserX, then later the rest will become UserX. date acctno due pic tag 20170801 12345 0 UserA Normal 20170802 12345 0 UserA Normal 20170803 12345 0 UserX UserX 20170804 12345 1 UserA UserX 20170805 12345 2 UserC UserX 20170806 12345 3 UserC UserX 20170807 12345 4 UserA UserX 20170802 22222 0 UserX UserX 20170803 22222 0 UserB UserX 20170804 22222 1 UserA UserX 20170805 22222 2 UserA UserX Thank in advance

sagulolo · ‎09-13-2017

Hi RW9, Thank for the code and guidance, it work. Apologise for inconvenience caused. Noted the test data and wording(uppercase), next time will use lowercase. Best Regards

sagulolo · ‎09-13-2017

Dear All, Any idea of how to tag/remark a certain group of acc base on example acc no. my dataset will be as below:- CDCYCCODE ACCTNO OUTSTANDING DUE STATE 20170801 ACCT 1 100 000000000009 C41 20170802 ACCT 1 100 000000000010 C41 20170803 ACCT 1 100 000000000011 C41 20170804 ACCT 1 100 000000000012 C41 20170805 ACCT 1 155 000000000013 C41 20170806 ACCT 1 155 000000000014 C41 20170807 ACCT 1 155 000000000015 C41 20170808 ACCT 1 155 000000000016 C41 20170809 ACCT 1 160 000000000017 C41 20170810 ACCT 1 160 000000000018 C51 20170811 ACCT 1 160 000000000019 C51 20170812 ACCT 1 160 000000000020 C51 20170813 ACCT 1 160 000000000021 C51 20170813 ACCT2 65 000000000005 V51 20170814 ACCT2 65 000000000006 V05 20170815 ACCT2 65 000000000007 V05 20170801 ACCT3 300 000000000001 E05 20170818 ACCT4 500 000000000005 C41 20170819 ACCT4 500 000000000006 E59 20170820 ACCT4 500 000000000007 E59 20170821 ACCT4 500 000000000008 E59 20170822 ACCT4 500 000000000009 E05 20170823 ACCT4 505 000000000010 E05 20170824 ACCT4 505 000000000011 E05 20170825 ACCT4 505 000000000012 E05 20170826 ACCT4 505 000000000013 E05 20170827 ACCT4 506 000000000014 E32 20170828 ACCT4 506 000000000015 E32 20170829 ACCT4 506 000000000016 E32 20170830 ACCT4 506 000000000017 E32 20170831 ACCT4 506 000000000018 E32 expecting outcome:- CDCYCCODE ACCTNO OUTSTANDING DUE STATE TAG 20170801 ACCT 1 100 000000000009 C41 C41 20170802 ACCT 1 100 000000000010 C41 C41 20170803 ACCT 1 100 000000000011 C41 C41 20170804 ACCT 1 100 000000000012 C41 C41 20170805 ACCT 1 155 000000000013 C41 C41 20170806 ACCT 1 155 000000000014 C41 C41 20170807 ACCT 1 155 000000000015 C41 C41 20170808 ACCT 1 155 000000000016 C41 C41 20170809 ACCT 1 160 000000000017 C41 C41 20170810 ACCT 1 160 000000000018 C51 C41 20170811 ACCT 1 160 000000000019 C51 C41 20170812 ACCT 1 160 000000000020 C51 C41 20170813 ACCT 1 160 000000000021 C51 C41 20170813 ACCT2 65 000000000005 V51 V51 20170814 ACCT2 65 000000000006 V05 V51 20170815 ACCT2 65 000000000007 V05 V51 20170801 ACCT3 300 000000000001 E05 E05 20170818 ACCT4 500 000000000005 C41 C41 20170819 ACCT4 500 000000000006 E59 C41 20170820 ACCT4 500 000000000007 E59 C41 20170821 ACCT4 500 000000000008 E59 C41 20170822 ACCT4 500 000000000009 E05 C41 20170823 ACCT4 505 000000000010 E05 C41 20170824 ACCT4 505 000000000011 E05 C41 20170825 ACCT4 505 000000000012 E05 C41 20170826 ACCT4 505 000000000013 E05 C41 20170827 ACCT4 506 000000000014 E32 C41 20170828 ACCT4 506 000000000015 E32 C41 20170829 ACCT4 506 000000000016 E32 C41 20170830 ACCT4 506 000000000017 E32 C41 20170831 ACCT4 506 000000000018 E32 C41 Logic is tag always follow the first ACCTNO -> state from the first record. Thank in advance.

sagulolo · ‎09-12-2017

Hi All, I have a dataset as per below:- YYYYMMDD ACCTNO OUTSTANDING DUE 20170810 ACCT 1 10.000000 000000000000 20170810 ACCT2 45.000000 000000000000 20170811 ACCT2 20.000000 000000000000 20170812 ACCT2 30.000000 000000000000 20170813 ACCT2 40.000000 000000000000 20170814 ACCT2 40.000000 000000000001 20170815 ACCT2 45.000000 000000000002 20170816 ACCT2 45.000000 000000000003 20170811 ACCT3 20.000000 000000000000 20170812 ACCT3 20.000000 000000000000 20170813 ACCT3 20.000000 000000000000 20170819 ACCT3 20.000000 000000000000 20170820 ACCT4 30.000000 000000000000 20170821 ACCT4 30.000000 000000000000 20170821 ACCT4 34.000000 000000000000 20170822 ACCT4 30.000000 000000000000 20170823 ACCT4 32.000000 000000000001 20170824 ACCT4 32.000000 000000000002 20170825 ACCT4 32.000000 000000000003 20170826 ACCT4 33.000000 000000000004 how I'm able to get output as per below:- YYYYMMDD ACCTNO OUTSTANDING DUE 20170810 ACCT 1 10.000000 000000000000 20170810 ACCT2 45.000000 000000000000 20170814 ACCT2 40.000000 000000000001 20170815 ACCT2 45.000000 000000000002 20170816 ACCT2 45.000000 000000000003 20170811 ACCT3 20.000000 000000000000 20170820 ACCT4 30.000000 000000000000 20170823 ACCT4 32.000000 000000000001 20170824 ACCT4 32.000000 000000000002 20170825 ACCT4 32.000000 000000000003 20170826 ACCT4 33.000000 000000000004 The logic would be I want the first record date(YYYYMMDD) account was recorded. Secondly I want those record when due become 1, 2, 3 and so on. Thank in advance

Online Status	Offline
Date Last Visited	‎09-18-2023 11:35 PM

Re: Vbscript - How to put path or SAS program name with spaces in betw...

Vbscript - How to put path or SAS program name with spaces in between

Re: How to workout keep track the variable

Re: How to workout keep track the variable

Re: How to workout keep track the variable

Re: How to workout keep track the variable

Re: How to workout keep track the variable

Re: How to workout keep track the variable

Re: How to workout keep track the variable

Re: How to workout keep track the variable

Re: How to workout keep track the variable

Re: How to workout keep track the variable

Re: How to workout keep track the variable

Re: How to workout keep track the variable

Re: How to workout keep track the variable

Re: infile multiple file by common file with date and no file extensio...

Re: calculating amounts by roll up Supplementary acc to basic acc

Re: how to shift the last row company name data into first row

Re: how to shift the last row company name data into first row

how to shift the last row company name data into first row

Re: infile multiple file by common file with date and no file extensio...

Re: infile multiple file by common file with date and no file extensio...

Re: infile multiple file by common file with date and no file extensio...

Re: infile multiple file by common file with date and no file extensio...

Re: infile multiple file by common file with date and no file extensio...

infile multiple file by common file with date and no file extension

Re: put a tag base on variable condition

Re: put a tag base on variable condition

put a tag base on variable condition

Re: HOW TO CREATE NEW VARIABLE TAG BASE ON CURRENT VARIABLE CONDITION

HOW TO CREATE NEW VARIABLE TAG BASE ON CURRENT VARIABLE CONDITION

how to delete row data base on variable conditions

SAS Analytics Explorers