About Tal

Tal · ‎06-13-2018

Thanks for the quick response PaigeMiller 1. don't know what u mean by seasonal 2.it will always be linearly dependent on sum(x)/sum(y) 3.Did not get that. I mean z=sum(x)/sum(y) so it depends on both variables No statisticians in my team or nearby 😞

Tal · ‎06-13-2018

Hello Data Mining Experts. Need your advice here 🙂 Never built any predictive model before but I have read a lot I have a simple data of 28 months . Each month has 2 variables x and y denoting number of clicks (either 0 or 1) happened on a daily basis I create another variable z=sum(x)/sum(y). So having these 28 tables and the value of z in each of the 28 tables I need to forecast the value Z in the year of 2019 What I need to understand here is : 1.will z of all these tables be enough to predict its value in 2019( model z=sum(x) sum(y)) ? 2. do I need to predict sum(x) and sum(y) first if that is possible before forecasting z? 3/ What would be the right model to accomplish 1 or 1 and 2? This might be a silly question but I would take any advice :). Thanks January: x y ------ 0 1 1 1 0 0 .... .... ....

Tal · ‎05-31-2018

sorry, I don't see how your code replaces ":" with "." but I found a way how to remove the last part of the date and that would be good enough for me y='2018-5-9 13:18:31:377'; n = length(y) - length(scan(y, -1, ':') ); y=substr(y,1,n-1); Thank you guys for your help

Tal · ‎05-30-2018

there will be more records on a given date in both tables so I will need to keep the hh mm and ss from the time part to be able to match correctly I was wondering if the last ":" can be replaced with "." or truncate the string, remove everything after the last ":" including the ":"

Tal · ‎05-30-2018

right , the second one is correct but what I am saying is the date in one of the tables has value of this type :2018-5-9 13:18:31:377 not 2018-5-9 13:18:31.377 and seems like the 1st one is not a valid date format so no way I can convert it can SAS remove the ":377" ?

Tal · ‎05-30-2018

data test; y='2018-5-9 13:18:31:377'; dd=input(y,anydtdtm32.);run; SAS displays dd as missing when running this data test; y='2018-5-9 13:18:31.377'; dd=input(y,anydtdtm32.);run; SAS displays dd=1841491111.4

Tal · ‎05-30-2018

thanks for your response ballardw.. the problem is that I cannot convert this date 2018-4-6 11:59:55:377 to a SAS date value. Looks like SAS does not recognize it if it was 2018-4-6 11:59:55.377 would have been fine but 2018-4-6 11:59:55:377 no good. Any way SAS can convert the second ":" into "."? or remove the second ":" and everything after it? I tried with substr but the length of the date is not the same

Tal · ‎05-29-2018

Hello guys, I have 2 tables that I need to match on date field but the format in both tables is a bit different 1st table : 2018-04-06 11:59:55 2nd table: 2018-4-6 11:59:55:377 This field is a string in both tables How can I convert 2018-4-6 11:59:55:377 to 2018-04-06 11:59:55. any ideas please? Thx

Tal · ‎04-27-2018

Thank u both!

Tal · ‎04-24-2018

Hi, Whats the best way to move a dataset or a list of datasets from sharedrive " \x\y\z" to unix '/a/b/c"? Thx

Tal · ‎12-05-2017

Thanks all for your inputs Turns out that the text file I was provided had a lot of bad data. I was only reading in 5 records but when I pulled a 1000 I realized everything is fine Looks like the first records from that file were clients from different countries out of Canada with missing gender, weird postal codes.... which I thought were truncated But all good Thanks again

Tal · ‎12-04-2017

I just ran this: data _null_; infile "&rootname\clientinfo.txt"; input; put _infile_; if _n_ > 20 then stop; run; and in the log I got exactly the same that I'd get in my output file from the above code so looks like the text file I was provided is all messed up

Tal · ‎12-04-2017

sorry I was not clear enough when I said same format I meant all fiels have blanks between the fields and the next row starts right after the previous so for example if one of the smaller files had 3 variables :code1 age and code2 the text file would be like : AAA 45 BBBAAA 55 BBBAAA 66 BBBAAA....... so when I use a code like: data clientinfo; infile "&rootname\clientinfo.txt" truncover lrecl=32767 pad obs=5; input @1 code1 $3. @6 age $2. @10 code2 $3. I'd get a perfect output All these files have different layout though(completely different files) it just that I cannot open the huge file Can you please share a link to some docs about the powershell thing? ps. I have 2 blank spaces between each field

Tal · ‎12-04-2017

I just tried with fixed column and got same result the first 4 variables are importing properly. Truncation starts after that so I guess I need to keep guessing about the layout...

Tal · ‎12-04-2017

Hi all, I have a huge text file which I need to import into SAS. I cannot open it in notepad (too big) and when I open it in wordpad the rows get messed up and no way I can determine the starting position of each field so I write my code based on some of the layout I got from business Column Name DATA TYPE CONTACT_ID VARCHAR2 (17 Byte) COMPANY_NAME VARCHAR2 (39 Byte) FIRST_NAME VARCHAR2 (30 Byte) LAST_NAME VARCHAR2 (33 Byte) GENDER VARCHAR2 (3 Byte) PREFERED_LANGUAGE VARCHAR2 (4 Byte) MARITAL_STATUS VARCHAR2 (12 Byte) HOME_PHONE VARCHAR2 (19 Byte) CELL_PHONE VARCHAR2 (19 Byte) BUISINESS_PHONE VARCHAR2 (21 Byte) EMAIL VARCHAR2 (50 Byte) DT_BIRTH VARCHAR2 (8 Byte) VIP_INDICATOR VARCHAR2 (3 Byte) STAFF_INDICATOR VARCHAR2 (3 Byte) CLIENT_SINCE_DATE VARCHAR2 (8 Byte) DNSH VARCHAR2 (3 Byte) HOME_DNCL VARCHAR2 (3 Byte) CELL_DNCL VARCHAR2 (3 Byte) BUSINESS_DNCL VARCHAR2 (3 Byte) DNSO VARCHAR2 (3 Byte) DT_TO_DATE VARCHAR2 (8 Byte) data clientinfo; infile "&rootname\clientinfo.txt" truncover lrecl=32767 pad obs=5; input @1 CONTACT_ID $17. @18 COMPANY_NAME $39. @57 FIRST_NAME $30. @87 LAST_NAME $33. @110 GENDER $3. @113 PREFERED_LANGUAGE $4. @117 MARITAL_STATUS $12. @129 HOME_PHONE $19. @148 CELL_PHONE $19. @167 BUISINESS_PHONE $21. @188 EMAIL $50. @238 DT_BIRTH $8. @246 VIP_INDICATOR $3. @249 STAFF_INDICATOR $3. @252 CLIENT_SINCE_DATE $8. @260 DNSH $3. @263 HOME_DNCL $3. @266 CELL_DNCL $3. @269 BUSINESS_DNCL $3. @272 DNSO $3. @275 DT_TO_DATE $8.; but when I run this I don't get an accurate output (some of the values getting truncated). Is there any way to find out the starting position of the fields or even to import the file? I even tried with the proc import wizard on pc sas and did not work. I was able to import 3 other small text files which was able to open and I know this big one is in the same format as those 3 (the value of the first field from the next row start right after the end of value of the last field from the previous one) Any suggestions please? 🙂

Online Status	Offline
Date Last Visited	‎06-01-2024 03:49 PM

Re: 6 months back

6 months back

Re: Copying files from the SAS server to a NAS folder (sharedrive)

Copying files from the SAS server to a NAS folder (sharedrive)

Re: Parsing a JSON File

Parsing a JSON File

Re: Parsing JSON data

Re: Parsing JSON data

Re: Parsing JSON data

Re: Parsing JSON data

Re: Parsing JSON data

Re: Parsing JSON data

Re: Parsing JSON data

Re: Parsing JSON data

Re: Parsing JSON data

macro question

Re: Data Step

Re: How not to loose observations in PROC TABULATE when having missin...

Re: date format

Re: Four if statements in one data step

Re: Choosing the right Predicitve Model

Choosing the right Predicitve Model

Re: date format

Re: date format

Re: date format

Re: date format

Re: date format

date format

Re: Moving a sas dataset from windows to unix

Moving a sas dataset from windows to unix

Re: importing a text file with no headers

Re: importing a text file with no headers

Re: importing a text file with no headers

Re: importing a text file with no headers

importing a text file with no headers