About sasbasls

sasbasls · ‎02-29-2012

I don't understand 2nd part of your question. Here is how formats looked: fmtlib1 had formats fmt1, fmt2, fmt3 etc fmtlib2 has fmt2. So when I combine both formats, resulting format should have fmt1, fmt2(with values from fmtlib1 & fmtlib2 - after deduping), fmt3 etc. thanks in advance for any ideas!!

sasbasls · ‎02-29-2012

I want to confirm one more doubt. fmtlib1has so many format names and fmtlib2 has one format name. So what I wanted to output is: all formats that are there in fmtlib1 + updated format name which is common to both libraries (should include values from fmtlib1 & fmtlib2 for that common format name). Thanks!!

sasbasls · ‎02-27-2012

hi, I have 2 format catalog that I want to combine. For example, there is a format catalog with different format names - fmtlib1 Also there is another format catalog for just one format name(fmtnm1) which is in "fmtlib1" - fmtlib2 How can I combine both format names and update fmtlib1 with all values from "fmtlib2" for fmtnm1 ? (It will be just update, not overwrite and fmtlib1 should have all formats remain same except for fmtnm1) thanks and appreciate any help!!

sasbasls · ‎01-25-2012

One doubt-- What does "&ftpcommands" in first filename statement correspond to ? thanks again for help!

sasbasls · ‎01-23-2012

hi, I need to get a set of datasets from a remote server. And I am connected to a unix server as well. How to accomplish this ? So task is getting a set of files or sasdatasets from a remote unix server to another unix server using SAS commands. thanks! sasbase9

sasbasls · ‎01-18-2012

Please let me know if fipstate functions with only take in variable values as input, not variable names ? and if there is a function to convert full state name to 2 digit state postal code or fips state code ? thanks!

sasbasls · ‎01-05-2012

Thank you too.

sasbasls · ‎01-05-2012

Thank you art297, it worked.

sasbasls · ‎01-05-2012

Thanks for quick response. I am getting error "Variable mydate has been defined as both character and numeric" I have variable "mydate" in a dataset, I am not passing inline data using cards statement. But when I did proc datasets on my dataset, I see variable as character type with length as 30. Any insight what's wrong I am doing in here ?

sasbasls · ‎01-05-2012

I have a variable in a dataset with value like "ccyy-mm-dd" as character. How can I convert to date ? I have used input(date,yymmdd10.);, but using this I am still getting variable type as character with a value like a numeric number, not date value. Please advise. thanks in advance!

sasbasls · ‎11-30-2011

Actually I need something else, not the value NA. Below code - if Trim(put(compress(sex),$gender.)) eq 'NA' then gend_code = sex; else gend_code= put(compress(sex),$gender.) ; This is like sample code. I have something else actually with major percentage of records going to NA and for those records I wanted to input the value used in format originally with out using a lookuo value. In above case, when value = NA from put function, then use value in sex variable to gend_code. Thanks!

sasbasls · ‎11-29-2011

hello, If we have defined proc format for a character variable and if in proc format if we have not defined other value, it will default to "NA", correct ? But we wanted to output all values where it is NA after applying format, how to do this ? For ex - put(compress(sex),$gender.) if value from this function is NA, can we just output what ever value that came in for variable : sex ? thanks!

sasbasls · ‎11-28-2011

Hi, If I wanted to check in a proc sql for a null date values and convert to a furture date if null and then compare that date using current date, can't I use nvl function? It's throwing an error. Please help. For example, I may have null date value in a date field and when I wanted to compare this null date value after converting to a furture date agains current date .... thanks!!

sasbasls · ‎11-16-2011

hi Ksharp!!, Would you please post an example on how to use batch mode to run SAS Code ? thanks, sasbase

sasbasls · ‎11-16-2011

I want to access remote server using SAS in filename ftp command. And then once remote server got connected, there are some datasets in a libary and I have a program on remote server to access those datasets and are downloaded to one of directories on remote server. So my question was - once we get connected to remote server, how can I run that SAS program ? thanks in advance for help.

Online Status	Offline
Date Last Visited	‎03-15-2016 08:16 AM

Need help to flag a value

how to merge variables

Issue when importing data from excel to sas dataset

Re: need help with summarizing data

need help with summarizing data

error in proc format

Re: How to accomplish this

How to accomplish this

Re: How can I check this in a file

How can I check this in a file

Re: Need help with combining 2 libraries using proc format

Re: Need help with combining 2 libraries using proc format

Need help with combining 2 libraries using proc format

how to sftp files

how to sftp files

How to converts state full name to fips state code ?

How to convert numeric date to sasdate ?

How to convert numeric date to sasdate ?

How to convert numeric date to sasdate ?

How to convert numeric date to sasdate ?

Need some info on proc format default values

Need some info on proc format default values

Need some help with date fields

Can someone please help?

Can someone please help?