About ali_far

ali_far · ‎07-22-2019

Hi, Here is the log of the code which has been run. No errors.! but the Id_date_birth are missing. Again if I just import these variables they will be imported properly. 660 Filename Alii'D:\want.tsv' encoding='utf8'; 661 662 data want; 663 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 664 infile Alii delimiter='09'x TRUNCOVER DSD lrecl=32767 firstobs=2 ; 665 666 informat panel_year best32. ; 667 informat projection_factor best32. ; 668 informat projection_factor_magnet best32. ; 669 informat Id_Date_birth_1 anydtdtm40. ; 670 informat Id_Date_birth_2 anydtdtm40. ; 671 informat dma_code best32. ; 672 673 format panel_year best12. ; 674 format projection_factor best12. ; 675 format projection_factor_magnet best12. ; 676 format Id_Date_birth_1 datetime. ; 677 format Id_Date_birth_2 datetime. ; 678 format dma_code best12. ; 679 680 input 681 panel_year 682 projection_factor 683 projection_factor_magnet 684 Id_Date_birth_1 685 Id_Date_birth_2 686 dma_code 687 688 ; 689 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 690 run; NOTE: The infile Alii is: Filename=D:\want.tsv, RECFM=V,LRECL=131068, File Size (bytes)=10131988, Last Modified=11Jul2018:23:45:43, Create Time=19Jul2019:16:20:57 NOTE: 63150 records were read from the infile Alii. The minimum record length was 130. The maximum record length was 220. NOTE: The data set WORK.want has 63150 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.15 seconds cpu time 0.14 seconds

ali_far · ‎07-21-2019

Thanks @Reeza for sharing your thoughts. Actually, I had tried TRUNCOVER before but It did not work. In terms of Input statement, Of course, it is must and I had it in the code before entering the range of variables but I forgot to write it here! One thing I found is that when I import the variable individually (only one id_birth) it looks fine. but when I even import two variables ( two id_birth ) one of them will be completely missing. and when I run the whole code all id_birth variables are missing. Do you have any idea about it?

ali_far · ‎07-21-2019

Hi, Thanks for your reply. I dont have the format of the date from the TSV file( I should not have written that format).However, in the similar datafile I have ( I imported them from TSV to SAS with the similar code) the format of the variable (numeric) is DATETIME16. If I dont use any format then the variable will only contain the year!

ali_far · ‎07-21-2019

Hi all, I have a question about importing TSV file to sas. the datafile has got date of birth variable ( yy/mm/dd). However, we importing the data, this variable is missing. data want; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ Filename Alii 'E:\want.tsv' encoding='utf8'; infile Alii delimiter='09'x MISSOVER DSD lrecl=32767 firstobs=2 ;informat male_head_birth anydtdtm40. ; /*for all variables*/ informat ID_date_birth anydtdtm40. ; format ID_date_birth datetime. ; ID_date_birth; if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ run; Thanks

ali_far · ‎05-26-2019

Thanks for your reply. I just tested the code here and it works for my sample data! You are right.. However, dont know why it does work ( I mean the way I want) for my real data.. I need to recheck other things perhaps...

ali_far · ‎05-26-2019

Hi all, I have a quick simple question. data have; input Id a b ; 1 2 2 1 2 2 1 3 2 2 4 . 2 4 . ; run; Proc sql; Create table want as Id, a, sum(b) as new from have group by ID, a; quit; This code does not account for the missing B. it means in "want table" it does not give the ID2. If I merge the want table with the "have table' my problem will solve. However, I was wonder if I can count for the missing directly in this code. So the data have should be like below: data want; input Id a new ; 1 2 4 1 3 2 2 4 . ; run; Thanks

ali_far · ‎05-06-2019

Hi draycut, your code works well

ali_far · ‎05-01-2019

Thanks for your reply. exactly, other variables might also get updated. Table 1 gets updated using the same id with table 2 where we the id has the highest value of B. Then other variable relevant to that ID also should be updated. Hope it is clear! appreciate your time

ali_far · ‎05-01-2019

Thanks a lot. Your code also works well and it is so cool...

ali_far · ‎05-01-2019

Thanks Jag, both codes work well! appreciate your time

ali_far · ‎05-01-2019

Thanks for your reply. Your code works well for what I wanted but unfortunately I got one mistake in the want data set: Here is the one I want: data updated table 1; input id A B C; cards; 1 7 34 3 2 11 3 1 3 23 3 2 4 9 6 1 5 5 7 2 6 7 8 1 run;

ali_far · ‎05-01-2019

Hi , my question is how I can only keep the IDs with the highest value of A data have; input id A B C; cards; 1 2 3 4 1 4 2 5 1 5 3 12 1 7 34 3 2 5 5 5 2 6 12 0 2 9 3 2 2 11 3 1 3 7 6 5 3 23 3 2 3 12 12 44 4 4 23 33 4 9 6 1 5 5 7 2 6 7 8 1 run; data want; input id A B C; cards; 1 7 34 3 2 11 3 1 3 23 3 2 4 9 6 1 5 5 7 2 6 7 8 1 run; Thanks

ali_far · ‎05-01-2019

Hi, I have a simple question: data table 1; input id A B C; cards; 1 2 3 4 2 5 5 5 3 7 6 5 4 9 6 1 5 5 7 2 6 7 8 1 run; data table 2 ; input id A B C; cards; 1 2 3 4 1 4 2 5 1 5 3 12 1 7 34 3 2 5 5 5 2 6 12 0 2 9 3 2 2 11 3 1 3 7 6 5 3 23 3 2 3 12 12 44 4 4 23 33 4 9 6 1 5 5 7 2 6 7 8 1 run; I want to update variable B in Table 1 where the id in two tables are the same (first condition) and A is at maximum in table 2. Because for some id( say 1, 2) in table 2 I have several rows. So, it will be the updated table: data table 1; input id A B C; cards; 1 2 34 4 2 5 3 5 3 7 3 5 4 9 6 1 5 5 7 2 6 7 8 1 run; proc SQL; update table 1 set B= (select B from table 2 where table 1.id=table 2.id and table 2.A=max); quit; I know the above code, after the and is not correct!!! Thanks

ali_far · ‎05-01-2019

Hi, I have a simple question: data table 1; input id A B C; cards; 1 2 3 4 2 5 5 5 3 7 6 5 4 9 6 1 5 5 7 2 6 7 8 1 run; data table 2 ; input id A B C; cards; 1 2 3 4 1 4 2 5 1 5 3 12 1 7 34 3 2 5 5 5 2 6 12 0 2 9 3 2 2 11 3 1 3 7 6 5 3 23 3 2 3 12 12 44 4 4 23 33 4 9 6 1 5 5 7 2 6 7 8 1 run; I want to update variable B in Table 1 where the id in two tables are the same (first condition) and A is at maximum in table 2. Because for some id( say 1, 2) in table 2 I have several rows. So, it will be the updated table: data table 1; input id A B C; cards; 1 2 34 4 2 5 3 5 3 7 3 5 4 9 6 1 5 5 7 2 6 7 8 1 run; proc SQL; update table 1 set B= (select B from table 2 where table 1.id=table 2.id and table 2.A=max); quit; I know the above code, after the and is not correct!!! Thanks

ali_far · ‎06-03-2018

Thanks for your reply. However, the code calculates the mean of var3 where var2 in (1,2). However, I want the mean of var3 where var2=0 and else var3.. I appreciate your help

Online Status	Offline
Date Last Visited	‎12-15-2019 09:17 PM

Re: Importing TSV file to SAS _date of birth issue

Re: Importing TSV file to SAS _date of birth issue

Re: Importing TSV file to SAS _date of birth issue

Importing TSV file to SAS _date of birth issue

Re: Creating Table with proc sql

Creating Table with proc sql

Re: proc sql update

Re: proc sql update

Re: Keep observations using a condition

Re: Keep observations using a condition

Re: Importing TSV file to SAS _date of birth issue

Re: do loop over the same observations

Re: do loop over the same observations

Re: first and second non-missing value in a row

Re: first and second non-missing value in a row

Re: Importing TSV file to SAS _date of birth issue

Re: Importing TSV file to SAS _date of birth issue

Re: Importing TSV file to SAS _date of birth issue

Importing TSV file to SAS _date of birth issue

Re: Creating Table with proc sql

Creating Table with proc sql

Re: proc sql update

Re: proc sql update

Re: Keep observations using a condition

Re: Keep observations using a condition

Re: proc sql update

Keep observations using a condition

proc sql update

proc sql update

Re: getting average in a column