About hexx18

hexx18 · ‎09-25-2018

I am not sure if my code works it might be wrong too

hexx18 · ‎09-25-2018

Hi I am trying to update the value for x in table zz Proc SQL; Update apple.zz Set x = 'Y'; (select * from apple.hh p join apple.zz d on d.id = p.ID and p.drd = 20 and c_ga =5 and x = 'N'); Quit; can anyone please help

hexx18 · ‎08-08-2016

Hi , I am running in a loop if i drop C column when i running i a loop i will not have C column in Auto2 also right but i want that column in Auto2 I need to write code n0284330in such a way that it drops the empty columns automatically from each dataset while creating the output so that the same code used for Auto1 it will drop CD EFGH and for Auto2 it will drop D Can anyone pls help Thanks

hexx18 · ‎08-08-2016

Hi , I used proc import and get datasets a and b PROC IMPORT OUT= WORK.auto&i DATAFILE= "C:\auto\&&price&i.xlsx" DBMS=xlsx REPLACE; SHEET="auto"; GETNAMES=YES; RUN; and i get two datasets as below and how to delete the columns which are empty like C,D,E,F,G,H from auto1and column D in auto2 Auto1 Zone pricing C D E F G H 876231 1428 650123 1556 754258 1235 Auto2 Safety measures dimension D floor 1 2 lock 0.95 3 alarm 0.85 5 alarm 0.98 7

hexx18 · ‎06-30-2016

I have two text files t1 and t2 and t6 and the output should be t3 and t4 and t7 (sas datasets) respectively . While importing i have to import in such a way that when the first coulmn has numberic data (1,2,10) i want that to be imported as numeric column (Memid) else when first column has character data and i want it to be character column (numV) T1 item0 item1 item2 item3 item4 item5 item6 item7 item8 "C,P,0,9" "C,18,P,7" "C,18,P,7" "C,18,P,7" "C,18,P,7" Memid xy Price Credit price Debit Price yy Price other price all price nhh price 1 356.00 234.00 23434 5757 7357 736767 63666 2 4878 3546.00 6565 5656 7467 6686 7688 10 74676 6478.00 65465 83648 6888 5767 6767.00 T2 item0 item1 item2 item3 item4 item5 item6 item7 item8 "C,P,0,9" "C,18,P,7" "C,18,P,7" "C,18,P,7" "C,18,P,7" numV xy Price Credit price Debit Price yy Price other price all price ABA 456.00 236.00 23434 5757 7357 736767 63666 CBC 4878 3546.00 6565 5656 7467 6686 7688 DBA 64676 6478.00 65465 83648 6888 5767 6767.00 T6 item0 item1 item2 item3 item4 item5 item6 item7 item8 "C,P,0,9" "C,18,P,7" "C,18,P,7" "C,18,P,7" "C,18,P,7" group Pin xy Price Credit price Debit Price yy Price other price all price group 01 3 456.00 236.00 23434 5757 7357 736767 63666 group 01 -99 4878 3546.00 6565 5656 7467 6686 7688 group 02 4 64676 6478.00 65465 83648 6888 5767 6767.00 group 03 10 84676 6478.00 65465 83648 6888 4767 6767.00 T3 var1 xy Credit Debit yy other all nhhh 1 356.00 234.00 23434 5757 7357 736767 63666 2 4878 3546.00 6565 5656 7467 6686 7688 10 74676 6478.00 65465 83648 6888 5767 6767.00 T4 var1 xy Credit Debit yy other all nhhh ABA 456.00 236.00 23434 5757 7357 736767 63666 CBC 4878 3546.00 6565 5656 7467 6686 7688 DBA 64676 6478.00 65465 83648 6888 5767 6767.00 T7 group Pin xy Credit Debit yy other all group 01 -99 456.00 236.00 23434 5757 7357 736767 63666 group 01 3 4878 3546.00 6565 5656 7467 6686 7688 group 02 4 64676 6478.00 65465 83648 6888 5767 6767.00 group 03 10 84676 6478.00 65465 83648 6888 4767 6767.00 Currently i have written below code but i need to modify code to get output t3 and t4 and t7 . Can anyone suggest me ? %macro tm(data,filenm); DATA WORK.XX; length VAR1 $15 var2 $4; INFILE "C\Desktop" LRECL=1000 DLM='09'x pad dsd firstobs=3; INPUT var1 $ var2 $ var3 $ ; run; %mend; %tm(txt,Pricing_03_20_2015);

hexx18 · ‎06-29-2016

when i use below code data xx; input NUMBER$ ITEMS$; datalines; 0 222223 1 222228 3 141111 4 999999 19 15151515 18 8888888 run; proc sort data=xx out=yy; by number items; run; the output is 0 222223 1 222228 18 8888888 19 15151515 3 141111 4 999999 but i want them to be 0 1 3 4 ---

hexx18 · ‎06-29-2016

Hi , I have three data sets B1 NUMBER ITEMS CODES 2 222223 2222 2 222228 2288 7 141111 545454 7 999999 5623 3 15151515 454545 1 8888888 484888 b2 ID ITEMS CODES 2 1151515 746467 2 1151313 746957 6 155444 48784 6 155255 48784 5 7884878 234454 1 7515787 4864487 b3 pin ITEMS CODES LIC 1151515 746467 LIC 1551547 48784 KKK 7884878 234454 KKK 7515787 4864487 for all three tables except first column all others are same and first column is character and i am taking first coulmn into macro variable &varname as shown above and i am doing sorting but my b1 and b2 datsets doesnot get sorted by first coulum can anyone help

hexx18 · ‎06-29-2016

was just checking instead can i add a column in B1 and B2 as count saying that when number is 2 then 1 but when number changes to 7 then count+ 1 . same way for b2 . The count varibale should be dyanmic for B1 and B2 when i do some logic it should work for B1 and B2 irrespective whether the first column is numeric or character B1 NUMBER ITEMS CODES 2 222223 2222 2 222228 2288 7 141111 545454 7 999999 5623 3 15151515 454545 1 8888888 484888 b2 ID ITEMS CODES LIC 1151515 746467 LIC 1551547 48784 KKK 7884878 234454 KKK 7515787 4864487 Thanks

hexx18 · ‎06-29-2016

Actually Number and id coloumns are character and i changed them to numeric to use in proc sort but when if i encounter chacter data in ID coulumn and its a problem and now i am unable to sort

hexx18 · ‎06-29-2016

Hi , I have two datasets B1 and B2 and i want to sort both datasets by first column can i do it dyanmically without indicating the name of teh column ? B1 NUMBER ITEMS CODES 2 222223 2222 2 222228 2288 7 141111 545454 7 999999 5623 3 15151515 454545 1 8888888 484888 b2 ID ITEMS CODES 2 1151515 746467 2 1151313 746957 6 155444 48784 6 155255 48784 5 7884878 234454 1 7515787 4864487 %macro xc; proc sort data=B_&i out= c_&i; by ; run; %mend; %xc; i want to order by first column for B1 and B2 . So I have used this %macro xc(i); data _null_; set sashelp.vcolumn; where upcase(libname) = 'WORK' and upcase(memname) = upcase("B_&i"); if _n_ = 1 then do; call symput('varname',name); stop; end; run; proc sort data=B_&i out=c_&i; by &varname; run; %mend; %xc(1); what if My B2 Dataset looks like below b2 ID ITEMS CODES LIC 1151515 746467 LIC 1551547 48784 KKK 7884878 234454 KKK 7515787 4864487

hexx18 · ‎06-29-2016

Thanks a lot it worked

hexx18 · ‎06-29-2016

its not working probably my ID nad number coloumns are character is there a way that i can change ID and number coloumns from both B1 and B2 datasets to numberic while its getting imported ? so that when there is a sas dataset i will have id and number coloumns numeric Thanks

hexx18 · ‎06-28-2016

i did proc sql; create table c_&i. as select * from b_&i. order by 1; quit; but its not working its because the first column is character ?

hexx18 · ‎06-28-2016

what if i want to order by only first column ?

hexx18 · ‎06-28-2016

Hi , I have two datasets B1 and B2 and i want to sort both datasets by first column can i do it dyanmically without indicating the name of teh column ? B1 NUMBER ITEMS CODES 2 222223 2222 7 141111 545454 3 15151515 454545 1 8888888 484888 b2 ID ITEMS CODES 2 1151515 746467 6 1551547 48784 5 7884878 234454 1 7515787 4864487 %macro xc; proc sort data=B_&i out= c_&i; by ; run; %mend; %xc; i want to order by first column for B1 and B2 . Can anyone suggest me what should i do ?

Online Status	Offline
Date Last Visited	3 weeks ago

Re: Extracting date part from Timestamp

Re: Extracting date part from Timestamp

Re: Extracting date part from Timestamp

Extracting date part from Timestamp

Re: Creating a Report from SAS Dataset

Re: Creating a Report from SAS Dataset

Re: Creating a Report from SAS Dataset

Re: Creating a Report from SAS Dataset

Re: Creating a Report from SAS Dataset

Re: Creating a Report from SAS Dataset

Re: Extracting date part from Timestamp

Re: Extracting date part from Timestamp

Re: Extracting date part from Timestamp

Re: Creating a Report from SAS Dataset

Re: Creating a Report from SAS Dataset

Re: delete columns if they are empty

delete columns if they are empty

Re: Update value in table

Update value in table

Re: delete columns if they are empty

delete columns if they are empty

import columns based on data and rename them

Re: Proc sort for character coloumns having numeric values

Re: Proc sort for character coloumns having numeric values

Re: Proc sort for character coloumns having numeric values

Re: Proc sort for character coloumns having numeric values

Proc sort for character coloumns having numeric values

Re: how to use proc sort dyanmically

Re: how to use proc sort dyanmically

Re: how to use proc sort dyanmically

Re: how to use proc sort dyanmically

how to use proc sort dyanmically