About atul_desh

atul_desh · ‎05-11-2017

I've Multiple text file in one location, I'm able to import them into one. But Few files have 10 Variable/ few of them have 12 Variables/ Few of them are having 4 Variables. The Variable which I wanted in final dataset present in all of them. all of the text files have header and I want two of them. Can I put those column name somewhere in below code ?? proc import datafile="Dir_Name/*.txt" out=work.Metadata dbms=dlm replace; delimiter='09'x; getnames=yes; guessingrows=max; quit;

atul_desh · ‎04-24-2017

Thanks for the code but I don't have permission to use pipe .. is there any other way to do it ??

atul_desh · ‎04-24-2017

I want dataset with below two variable from one of directory(unix) location where multiple text files are present.. is there any way to do it ?? Name of File, Number of records Thanks

atul_desh · ‎04-21-2017

data Quick1(where=(ShipDays<3)) Slow (where=(3<=ShipDays<5)) veryslow (where=(ShipDays>5)); set orders; where Order_Type_Label in ("Web", "Catalogu"); ShipDays = Delivery_Date - Order_Date; run;

atul_desh · ‎04-18-2017

atul_desh · ‎11-14-2016

I want the difference of latest amount & previous amount according to loan_id, In Try1 I'm getting not correct output then I tried Try2 which worked but i'm not able to understand why Try1 Got failed ?? Try1: data loan1; input loan_id date ddmmyy10. amount; format date ddmmyy10.; datalines; 1 10/11/2015 800 1 12/11/2015 400 2 09/11/2015 800 2 10/11/2015 0 3 01/11/2015 2000 1 11/11/2015 600 3 02/11/2015 800 3 03/11/2015 600 2 08/11/2015 1000 ; run; proc sort data=loan1; by loan_id descending date; run; data want; set loan1; by loan_id; if first.loan_id then n=1; else n+1; if n=2 then diff_amt=amount-lag1(amount); run; proc print data=want; run; Output : SAS Output Obs loan_id date amount n diff_amt 1 2 3 4 5 6 7 8 9 1 12/11/2015 400 1 . 1 11/11/2015 600 2 . 1 10/11/2015 800 3 . 2 10/11/2015 0 1 . 2 09/11/2015 800 2 200 2 08/11/2015 1000 3 . 3 03/11/2015 600 1 . 3 02/11/2015 800 2 0 3 01/11/2015 2000 3 . Try 2: This gave me correc o/p : data want; set loan1; by loan_id; if first.loan_id then n=1; else n+1; prev_value=lag1(amount); if n=2 then diff_amt=amount-prev_value; run; proc print data=want; run;

atul_desh · ‎11-14-2016

yeah...i got the output..thanks...but just a quick question (I was missing that base table should have same schema similar to data from which i'm appending) : proc sql; select count(*) into : obs from sashelp.vtable where libname = 'ABC'; %LET OBS=&OBS; SELECT catx('.', 'abc', memname) INTO : TAB1-:TAB&OBS FROM sashelp.vtable where libname = 'ABC'; QUIT; %MACRO append; %DO i=1 %to &obs; proc append base=tot_comb data=&&tab&i force;run; %end; %mend; %append; proc print data=tot_comb; run;

atul_desh · ‎11-14-2016

sorry...Its working !!

atul_desh · ‎11-14-2016

809 proc sql; 810 select count(*) into : obs from sashelp.vtable 811 where libname = 'ABC'; 812 %LET OBS=&OBS; SYMBOLGEN: Macro variable OBS resolves to 3 813 SELECT memname INTO : TAB1-:TAB&OBS FROM sashelp.vtable SYMBOLGEN: Macro variable OBS resolves to 3 814 where libanme = 'ABC'; ERROR: The following columns were not found in the contributing tables: libanme. 815 QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.13 seconds cpu time 0.03 seconds 816 %MACRO append; 817 %DO i=1 %to &obs; 818 proc append base=tot_comb data=&&tab&i force;run; 819 %end; 820 %mend; 821 %append; MLOGIC(APPEND): Beginning execution. SYMBOLGEN: Macro variable OBS resolves to 3 MLOGIC(APPEND): %DO loop beginning; index variable I; start value is 1; stop value is 3; by value is 1. SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 1 NOTE: Line generated by the macro variable "I". 1 &tab1 - 22 200 WARNING: Apparent symbolic reference TAB1 not resolved. ERROR: File WORK.TAB1.DATA does not exist. MPRINT(APPEND): proc append base=tot_comb data=&tab1 force; MPRINT(APPEND): run; ERROR 22-322: Expecting a name. ERROR 200-322: The symbol is not recognized and will be ignored. NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE APPEND used (Total process time): real time 0.02 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. MLOGIC(APPEND): %DO loop index variable I is now 2; loop will iterate again. SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 2 NOTE: Line generated by the macro variable "I". 1 &tab2 - 22 200 WARNING: Apparent symbolic reference TAB2 not resolved. ERROR: File WORK.TAB2.DATA does not exist. MPRINT(APPEND): proc append base=tot_comb data=&tab2 force; MPRINT(APPEND): run; ERROR 22-322: Expecting a name. ERROR 200-322: The symbol is not recognized and will be ignored. NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE APPEND used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. MLOGIC(APPEND): %DO loop index variable I is now 3; loop will iterate again. SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 3 NOTE: Line generated by the macro variable "I". 1 &tab3 - 22 200 WARNING: Apparent symbolic reference TAB3 not resolved. ERROR: File WORK.TAB3.DATA does not exist. MPRINT(APPEND): proc append base=tot_comb data=&tab3 force; MPRINT(APPEND): run; ERROR 22-322: Expecting a name. ERROR 200-322: The symbol is not recognized and will be ignored. NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE APPEND used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. MLOGIC(APPEND): %DO loop index variable I is now 4; loop will not iterate again. MLOGIC(APPEND): Ending execution.

atul_desh · ‎11-14-2016

I want to append all dataset into one (using proc append) I'm using below code, but not giving output Please help !! proc sql; select count(*) into : obs from sashelp.vtable where libname = 'ABC'; %LET OBS=&OBS; SELECT memname INTO : TAB1-:TAB&OBS FROM sashelp.vtable where libanme = 'ABC'; QUIT; %MACRO append; %DO i=1 %to &obs; proc append base=tot_comb data=&&tab&i force;run; %end; %mend; %append;

atul_desh · ‎11-14-2016

I've corrected the line "seprated by ' ' but now i'm not getting why work1, work2 & work3 are searching in work library. I've given abc.&names Code : libname abc 'C:\Users\Sony\Desktop\datasets'; OPTIONS SYMBOLGEN; proc sql noprint; select memname into: names seprated by ' ' from Dictionary.tables where libname="ABC" ; quit; data want; set abc.&names; run; Error : SYMBOLGEN: Macro variable NAMES resolves to WORK1 WORK2 WORK3 360 set abc.&names; ERROR: File WORK.WORK2.DATA does not exist. ERROR: File WORK.WORK3.DATA does not exist.

atul_desh · ‎11-14-2016

After Reading multiple threads i'm able to write below code, but not getting output... Please help !! Code : libname abc 'C:\Users\Sony\Desktop\datasets'; OPTIONS SYMBOLGEN; proc sql noprint; select memname into: names seprated by '' from Dictionary.tables where libname="ABC" ; quit; data want; set abc.&names; run; Error : SYMBOLGEN: Macro variable NAMES resolves to WORK1WORK2WORK3 180 set abc.&names; ERROR: File ABC.WORK1WORK2WORK3.DATA does not exist.

atul_desh · ‎10-31-2016

Yes I know I should write as below : "on a.ManagerID=b.ID;" but when i'm writting as below how i'm getting the output can someone please explain logic how output calculated data ds1; input Name $ ID ManagerID; cards; Smith 123 456 Robert 456 . William 222 456 Daniel 777 222 Cook 383 222 ; run; proc sql; select a.*, b.Name as Manager_name from ds1 as a left join ds1 as b on b.ManagerID=a.ID; quit; Output : SAS Output Name ID ManagerID Manager_name Smith 123 456 William 222 456 Cook William 222 456 Daniel Cook 383 222 Robert 456 . Smith Robert 456 . William Daniel 777 222

atul_desh · ‎10-26-2016

Thanks Rick, but i want if it could done with proc sql; Thanks for your support !!

atul_desh · ‎10-26-2016

I want section, Std in output who is having highest Average marks... I'm not sure but having AVG_MARKS=max(AVG_MARKS) is not working Thanks,

Online Status	Offline
Date Last Visited	‎03-28-2022 11:30 PM

Re: array break until multiple condition met

Re: array break until multiple condition met

Re: array break until multiple condition met

array break until multiple condition met

Re: Not getting mail from sas Job when running on Unix SAS Grid

Re: Not getting mail from sas Job when running on Unix SAS Grid

Re: Not getting mail from sas Job when running on Unix SAS Grid

Re: Not getting mail from sas Job when running on Unix SAS Grid

Re: Not getting mail from sas Job when running on Unix SAS Grid

Not getting mail from sas Job when running on Unix SAS Grid

Re: array break until multiple condition met

Re: proc sql problem adding new variable

Re: proc sql problem adding new variable

Re: Set All Datasets present in library into one dataset

Re: Set All Datasets present in library into one dataset

Not getting mail from sas Job when running on Unix SAS Grid

Re: Catx or trim? Help with Problem

can I choose few variable name from multiple text file

Re: count number of records of multiple text file seperately ??

count number of records of multiple text file seperately ??

Re: How does one output certain observations to certain data sets?

Re: Catx or trim? Help with Problem

logic behind lag() when using with first. ??

Re: PROC APPEND FROM MULTIPLE TABLE

Re: PROC APPEND FROM MULTIPLE TABLE

Re: PROC APPEND FROM MULTIPLE TABLE

PROC APPEND FROM MULTIPLE TABLE

Re: Set All Datasets present in library into one dataset

Set All Datasets present in library into one dataset

Logic behind left join ??

Re: how to get Max(avg(Variable))

Re: how to get Max(avg(Variable))