Do you know how to set column type as int in sas studio? right now it is double.
My code :data gems;
input Name $ Carats comma3. Color $char10.;
informat Name $char10.;
format Carats comma3.;
aquamarine 20 blue
proc print data=gems; run;
proc contents data=gems; run;
PROC SQL;CREATE TABLE cas_sme.gems AS SELECT * FROMwork.gems;QUIT;PROC CASUTIL;SAVE CASDATA = "gems" INCASLIB = "cas_sme" OUTCASLIB = "cas_sme"CASOUT = "gems.sashdat" REPLACE;QUIT;
Moreover, I have tried Int function but still column type is double.
data r ;set work.gems ;y = round(Carats,1);z1 = Int(Carats);z2 = Intz(Carats);run;PROC SQL;CREATE TABLE cas_sme.gems AS SELECT * FROMwork.r;QUIT;PROC CASUTIL;SAVE CASDATA = "gems" INCASLIB = "cas_sme" OUTCASLIB = "cas_sme"CASOUT = "gems.sashdat" REPLACE;QUIT;
You need to test that your data step reads correctly before providing it to us.
If you use an informat like 3.1 on an input statement it will force a decimal. Do you intend to read that 15 for emerald as 1.5?
data gems; input Name $10. Carats :3.1 Color $char10.; informat Name $char10.; format Carats comma3.1; datalines; emerald 15 green aquamarine 20 blue ;
Your code read the carats for emerald as part of the Color value. When using list input with a format like comma3.1 or 3.1 SAS starts reading immediately after the end of the previous value so the spaces were read as the carats.
And why is there any concern about "integer" value when you are apparently forcing at least one decimal to be part of the value????
Why the Comma3.1 ? Forcing one decimal means that 2 of the 3 character positions possible are the decimal and whatever digit follows. Do you have data with a currency symbol followed by decimal? Any value that actually has comma in it would be a minimum of 5 characters.
My bad.. I have corrected my code as the updated code on the top, but the carats column is still double.
And it will continue to be so because there is no such thing as an "integer" variable type.
You data step code now throws an invalid data error:
data gems; input Name $ Carats comma3. Color $char10.; informat Name $char10.; format Carats comma3.; datalines; emerald 15green aquamarine 20 blue ;
With no space between the 15 and "green" you have told SAS to read 3 characters and g of green is the third. Which is invalid for the comma3 (and pretty much any SAS supplied numeric informat) And note the value of Color for the first observation. List input expects a space between values. Datalines are a bit pickier in some respects than an Infile statement for reading data and may need to modify informats.
47 data gems; 48 input Name $ Carats comma3. Color $char10.; 49 informat Name $char10.; 50 format Carats comma3.; 51 datalines; NOTE: Invalid data for Carats in line 52 9-11. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+-- 52 emerald 15green Name=emerald Carats=. Color=reen _ERROR_=1 _N_=1
You have mixed FORMATTED and LIST MODE input style in the same INPUT statement.
When you use LIST MODE then SAS reads the next "field" from the line, where field boundaries are defined by the combination of DSD, DLM= and DLMSTR= settings.
When you use FORMATTED mode the it just reads exactly the number of bytes you told it to read.
You have also used the special $CHAR informat instead of the normal character informat $. So the leading spaces are preserved. Another side effect of using $CHAR instead of $ is that you cannot designate a missing character value by just using a period. When a single period is read by $ the result is a blank value. But when read by $CHAR the period becomes part of the actual value of the variable.
If for some reason you wanted to include an informat specification in the INPUT statement (perhaps you have DATE values to read?) then prefix the informat with the colon modifier to tell INPUT to use LIST MODE.
From the documentation apparently NOT.
SAS only has two data types. Fixed length strings and floating point numbers. CAS has added a variable length character variable type. It does not appear to have added any additional numeric data types.
Note your example data step cannot work. NAME is not defined long enough to hold that last value. You are inserting a leading space into one of the values of COLOR.
To insure that the variables are defined as you want them define them with a LENGTH statement before using them in statements like INPUT or FORMAT or INFORMAT. None of your three variables needs special instructions for reading or writing. SAS already knows how to read and display character strings and numbers. There is no need to use COMMA format or informat to display 3 digit numbers. The commas will start to appear for values larger than 999.
data gems; length Name $10 Carats 8 Color $10 ; input Name Carats Color; datalines; emerald 15 green aquamarine 20 blue ;
I don't know what CAS allows, just what the documentation page linked above says.
Normally when you transfer a SAS dataset to a foreign database SAS will assume any variable that has the normal numeric format permanently attach that specifies zero decimal places is an integer type (or DECIMAL type if the foreign database has such a type). For systems with DECIMAL type they can even use that when the attached format has decimal places.
So try attaching the normal numeric format 3. instead of the comma3. format your code used to your numeric variable and see what CAS does with it. You can also use F3. format specification since F is an alias for the normal numeric format.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.