About Tal

Tal · ‎07-17-2017

I go to the unix folders through a ftp. Hers shows 3.2GB mine for example 7.8GB

Tal · ‎07-17-2017

By default you mean some settings in pc sas?

Tal · ‎07-17-2017

Hi, My co-worker and I are running the same program on pc sas but remotly loginin in on 2 different SAS servers. The size of the datasets.my pc sas creates are twice the size hers does. How do you guys explains this. Anything i can change in the settings of my pc sas? Any idea please? Thx

Tal · ‎06-28-2017

yea,i also tried the same code on EG SAS and works but did not on PC SAS so definately not a syntax issue thank you

Tal · ‎06-28-2017

%global not working either 😞 the code works fine if i use tab2.CREATION_DATE >="01MAR2015"d but not if i use the macro var below and it resolves fine everywhere out of the query but not in the query below %LET today = %sysfunc(today()); %LET month_27 = %sysfunc(intnx(month, &today, -27)); %put &month_27; CREATE TABLE clkb_base AS SELECT x,y,z FROM tab1 JOIN tab2 ON tab1.ADDR_ENTITY_ID = tab2.CUSTOMER_ID JOIN tab3. ON tab1.ID = tab3.ENTITY_ID ........................ ......................... WHERE tab2.CREATION_DATE >="&month_27" QUIT;

Tal · ‎06-28-2017

yes it does ,sorry %LET today = %sysfunc(today());

Tal · ‎06-28-2017

hello, %LET dte = %sysfunc(intnx(month, &today, -27)); i am running a query with a pass through connection and when using where>'01Mar2015'd everything looks fine but if i use a macro variable where>&dte then i get the warning 'symbolic reference dte not being resolved" which leads to an error i also tried to double qoute this macro var and again the same warning and error Any idea why is this happening?

Tal · ‎05-11-2017

In fact flag the master with "existing" only and update the date to current and then append (A) to the master table?

Tal · ‎05-11-2017

Thx Patrick I can get the records (A) from the daily file which are brand new and those with changes. So are you saying i can left join the master with (A) and flag it with "new" and "existing" and if its existing than set the date to current and then simply append (A) to the master?

Tal · ‎05-11-2017

hi, I have a master table which gets updated by daily SAS datasets. a) if the record from the daily table is new then simply append it to the master table b) if the record exists(no changes) in the master then do nothing to it c)if the clientt exists in the master but he has some updates in the daily file then append his new reocrd to the master and also update the Date field of his previous record with the current date. In other words after the appending only clients whose two last records in the master table have missing date need to be updated(the Date field of his second last record) I have attached samles of how table need to look like Tried with last.id and first.id but got stuck. Any hints please? Thx

Tal · ‎05-11-2017

hi, i have a master dataset which gets updated by a daily file. a) if the record from the daily table exists in the master then nothing to be done b) if new record then simply append it to the master table c) if the client from the daily exists in the master table but with changes then his new record from the daily gets appended to the master table and the date field of his previous record gets updated with the date of the update occured daily: current master: master table after appending: master table with date field updated: id x y id x y date id x y date id x y date --------- ------------------------------ -------------------------------- ---------------------------------------- 100 1 2 100 1 2 100 1 2 100 1 2 101 3 4 101 2 2 13/04/2016 101 2 2 13/04/2016 101 2 2 13/04/2016 102 5 6 101 3 4 101 3 4 101 3 4 103 3 3 102 1 1 13/04/2016 103 3 3 103 3 3 102 1 3 15/04/2016 102 1 1 13/04/2016 102 1 1 13/04/2016 102 2 3 102 1 3 15/04/2016 102 1 3 15/04/2016 102 2 3 102 2 3 12/5/2017 102 5 6 102 5 6 updating the DATE field is what troubles me. Tried first.id and last.id,tried merging..... nothing worked. Any hints pleasE? Thx

Tal · ‎05-09-2017

hmm you have admin rights to select the "check this account" then with the pass and user you have in your code and try again? I mean we dont need credentials to access the share drives then i dont understand why we would need to provide them in the proc import code

Tal · ‎05-09-2017

hey go,sorry i still dont have an answer to that. Remove the SERVERUSER='dryrock\gnayaki'; SERVERPASS='***; from you code and see if you get the error that i got. I can easily connect to my c drive but not to the share drives

Tal · ‎05-05-2017

thanks

Tal · ‎05-05-2017

i just wonder what does the following do: if countw(_infile_,'|','mq') > 3 then put / @; else put ' ' @;

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: SAS Datasets size

Re: SAS Datasets size

SAS Datasets size

Re: macro var not being resolved

Re: macro var not being resolved

Re: macro var not being resolved

macro var not being resolved

Re: update master table

Re: update master table

update master table

updating master table

Re: pc files server

Re: pc files server

Re: pipe delimietd file with no specific layout

Re: pipe delimietd file with no specific layout