About atul_desh

atul_desh · ‎07-11-2017

command : sasgsub -gridwait -gridsubmitpgm /path1/test.sas -gridsasopts "(-sysparm 'dest_path/fol1 testds')" test.sas : %let path=%scan(sysparm(),1,' '); %let ds=%scan(sysparm(),2,' '); libname pt "&path"; data pt.&ds; input a; datalines; 1 2 ; run; path & ds are not resolving !!

atul_desh · ‎07-11-2017

Thank you so much @art297and @Tom

atul_desh · ‎07-10-2017

@art297 I'm getting issue when my first column is blank...even though i've tried missover, truncover but issue still persist.

atul_desh · ‎07-10-2017

/*SAS Job name test.sas*/ libname srcf "$1"; data srcf.$2; input a; datalines; 1 2 ; run; I want to run as below : /*value of $1 = /mdir/subdir/*/ /*value of $2 = test_par*/ Unix command as below : sasgsub -gridwait -gridsubmitpgm test.sas /mdir/subdir/1 test_par

atul_desh · ‎06-28-2017

Thank you so much.... 🙂

atul_desh · ‎06-28-2017

I wants value like in want column : have want 625355 $625,355 856422.5412 $856,422.54 818935.584 $818,935.58 456464.51 $456,464.51 560843.1 $560,843.10 558.55 $558.55 58.00 $58 5 $5

atul_desh · ‎06-28-2017

I want dollar32. format for non-decimnal value. and dollar32.2 for decimal containing value.. I've write below code but its not working as expected. data ds5; input var5 32. ; if scan(var5,2,'.') gt 0 then var5=input(var5,dollar32.2); else var5=input(var5,dollar32.); datalines; 625355 856422.54121 818935.584 456464.51 560843.1 558.55 58.00 5 ; run;

atul_desh · ‎06-26-2017

yup.. is there any way so that dsd don't consider double quotes & single quotes as delimiter and only consider Pipe or '09'x ??

atul_desh · ‎06-26-2017

In Actaul file it is tab delimeted... I'm trying to replace | with '09'x..

atul_desh · ‎06-26-2017

Yes I do need quotation mark !! 😞

atul_desh · ‎06-26-2017

thank you but Actual data which I'm having is having 180 variable and 85 million observation.. so using array make them more difficult to run...longer to run.

atul_desh · ‎06-26-2017

My data is in tab delimited text file... but I shown here as pipe delimited just to more readable.

atul_desh · ‎06-26-2017

I've want to read var2 & var8 with (") in it. I think dsd considering inverted comma as delimeter. how can I read value ? please help !! data ds2; infile datalines dsd dlm="|" missover; input (var1-var8) ($); datalines; 2|"28 |4|||||29" | run; proc print data=ds2; run;

atul_desh · ‎06-23-2017

But my actual file is not pipe delimited it is tab delimeted... Here I've given example of pipe delimited just to get more understand.

atul_desh · ‎06-23-2017

Hello, I'm having two single quote (') seprated by delimeter. its is reading them as 1 and var3 is equal to "8" which should be var4 in second observation. data ds1; infile datalines dsd dlm='|'; input var1-var4; datalines; 1|2|3|4| 9|'|'|8| run; proc print data=ds1; run; Also I don't want to "~" before variable because in actual case I don't which two consuctive variable will contain single quotation. Actual text which I'm trying to import from unix contains 200 variable and that is tab delimited.. I've given above example of pipe delimited just to more readable. Please help me out !! Thanks Atul Deshmukh

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

Re: Run SAS Job on Unix for multiple files

Re: Read Value with inverted comma

Re: Read Value with inverted comma

Run SAS Job on Unix for multiple files

Re: Two Formats for one variable

Re: Two Formats for one variable

Two Formats for one variable

Re: Read Value with inverted comma

Re: Read Value with inverted comma

Re: Read Value with inverted comma

Re: Read Value with inverted comma

Re: Read Value with inverted comma

Read Value with inverted comma

Re: single quotation between two delimetere causing issue

single quotation between two delimetere causing issue